Scripting Blog

A place to learn about PowerShell and share stories of automation

Nearly everything has changed for SQL Server PowerShell

2016 was the best year in SQL PowerShell history! I guess I should have mentioned that here sooner. Wired® Magazine recently said that Microsoft SQL Server was the surprise hit of the year. The primary cited reason is the SQL Server port to Linux, but there are several other reasons to be really excited about SQL Server and SQL Server ...

Where[-Object] clauses for people who use SQL Server

Summary: Learn about the power of the Where[-Object] cmdlet in PowerShell. Can I do a WHERE clause with an IN, in PowerShell?  Yes! Today’s post is from Aaron Nelson ( blog | twitter ), who is a Microsoft MVP for SQL Server (Data Platform), leads the PowerShell Virtual Chapters of PASS, volunteers for the local PASS Chapter AtlantaMDF, ...

Use PowerShell to Script SQL Database Objects

  Summary: Learn how to use Windows PowerShell to automate creation of SQL Database objects such as tables, stored procedures, and functions.   Hey, Scripting Guy! How can I use Windows PowerShell to script out SQL Server database objects? -- AA   Hello AA, Microsoft Scripting Guy Ed Wilson here. Today we have one final blog ...