Last time, I discussed how to get PowerShell and SQLPS up and running on your machines. And much like my dog chasing its tail, you're probably asking yourself, "Now that I have it, what do I do with ...

When you need a SQL database fast, the cloud is the best way to go. Azure provides a SQL database as a Platform as a Service (PaaS) that eliminates the need to get an entire SQL Server up and running.

Throughout this series of posts there have been a number of examples of how to use the SQL Server PowerShell provider. However, these were always in context with a specific task (i.e. automating ...

Let's follow up the last column with a step-by-step breakdown shows how the PowerShell script automates SQL Server backups, manages retention, logs activity and verifies data integrity. In my first ...