Database administrators tend to perform a lot of routine checks, referred to as sanity checks, on a daily, weekly, and monthly basis. Rob Gravelle shows you how to write some PowerShell scripts to automate a couple of fairly common sanity checks.
Prior to SQL Server 2012, Microsoft provided a mini shell called sqlps.exe; in SQL Server 2012, SQLPS exists in the form of module. Learn how to make use of the SQLPS module and how to access SQL Server components and features via Windows PowerShell.
I’ve been thoroughly enjoying my experience this year with the Scripting Games. This is the first year I've competed and...
Phil Factor demonstrates how to generate T-SQL scripts for databases, selected database objects, or table contents from PowerShell and SMO.