The “Hey, Scripting Guys!” blog has been retired. There are many useful posts in this blog, so we keep the blog here for historical reference. However, some information might be very outdated and many of the links might not work anymore.

New PowerShell content is being posted to the PowerShell Community blog where members of the community can create posts by submitting content in the GitHub repository.

Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

Nearly everything has changed for SQL Server PowerShell

January 25, 2017 Jan 25, 2017 01/25/17

Doctor Scripto

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

January 4, 2017 Jan 4, 2017 01/4/17

Doctor Scripto

Summary: Learn about the power of the Where[-Object] cmdlet in PowerShell. (image) Can I do a WHERE clause with an IN, in PowerShell? (image) 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 ...

Use PowerShell to Script SQL Database Objects

November 4, 2010 Nov 4, 2010 11/4/10

ScriptingGuy1

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

Use PowerShell to Change SQL Server Service Accounts

November 3, 2010 Nov 3, 2010 11/3/10

ScriptingGuy1

Summary: Learn how to use Windows PowerShell to change SQL Server service accounts. (image) Hey, Scripting Guy! How can I use PowerShell to change SQL Server service accounts? -- NM (image) Hello NM, Microsoft Scripting Guy Ed Wilson here. This week I am hosting guest bloggers from the SQL side of life. This is in honor of...

Use PowerShell to obtain SQL Server database sizes

November 2, 2010 Nov 2, 2010 11/2/10

ScriptingGuy1

Summary: Learn how to use Windows PowerShell to obtain SQL Server database information. (image) Hey, Scripting Guy! Is there an easy way to obtain database size information by using Windows PowerShell? -- NA (image) Hello NA, Microsoft Scripting Guy Ed Wilson here. As I mentioned yesterday, this week we are hosting ...

Scripting Blog [archived]

Aaron Nelson - Scripting Blog [archived]