PowerShell for the SQL DBA

October 19, 2010

I teach ‘PowerShell Essentials’ and am often  asked for hints and tips on using PowerShell with SQL. So, here is a list of links you may find useful. Please let me know your own suggestions and I’ll add them to the list.

SQL Server PowerShell Extensions (SQLPSX) http://sqlpsx.codeplex.com/

SQL Server PowerShell Overview http://msdn.microsoft.com/en-us/library/cc281954.aspx

Use PowerShell to Administer SQL Server 2008 http://blogs.technet.com/b/heyscriptingguy/archive/2010/09/30/use-powershell-to-administer-sql-server-2008.aspx

Monitoring SQL Server Agent with Powershell http://www.sqlteam.com/article/monitoring-sql-server-agent-with-powershell

Interacting with SQL Databases in PowerShell: Invoke-SqlCommand http://www.leeholmes.com/blog/2007/10/19/interacting-with-sql-databases-in-powershell-invoke-sqlcommand/

Ground-Zero PowerShell for the SQL Server DBA http://oreillynet.com/pub/e/1399

Connecting to SQL Server via Windows PowerShell with SQL Server authentication http://www.mssqltips.com/tip.asp?tip=1947

SQLTIPS on PowerShell http://www.mssqltips.com/category.asp?catid=81