PowerShell

This article looks at using PowerShell invoke-nz.

Checking for SQL Server Agent jobs and their status is part of your daily task as a DBA. How do we use Windows PowerShell to check for SQL Server Agent jobs?

In a previous tip, Retrieve List of Databases and their Properties using PowerShell, you have seen how you can use Windows PowerShell to audit database properties and use Microsoft Excel to generate a report. Part of the daily SQL Server DBA tasks is to c

In this tip we look at how to retrieve databases and database properties for SQL Server databases using PowerShell.

To continue this series on Introduction to Windows PowerShell for the SQL Server DBA, this tip will look at writing and running PowerShell scripts. In this tip, we will start writing PowerShell scripts and introduce SQL Server Management Objects (SMO).

In Part 1, we introduced Windows PowerShell, cmdlets, aliases and how we can take advantage of help available. To continue this series on Introduction to Windows PowerShell for the SQL Server DBA, this tip will look at the pipeline and output processing.

In my organization we write scripts to perform all sorts of administrative functions on our many SQL Server instances as well as other server products. We are just getting started with using PowerShell and have heard that SQL Server 2008 provides some bu

I have been hearing about Microsoft's scripting language called Windows PowerShell which is extensively used for administering Windows servers. I want to know how Windows PowerShell can help me as a SQL Server DBA.

Learn how to automate a database restore using PowerShell restore-sqldb.