There are a number of PowerShell modules which can make your life much easier when it comes to managing and reporting on your SQL servers. There is even a built-in module (also available now as a ...

To wrap up this series of PowerShell articles ... This can be done by using this script: This script simply creates an array, which holds all of the SQL Server related assemblies, and then ...

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 ...

PowerShell is cool, but it's not always appropriate. Here's a quick list to help you decide when to use it PowerShell is ... Sean McCown is a Certified Master in SQL Server and a SQL Server ...

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...