Scripting Blog

A place to learn about PowerShell and share stories of automation

SQL Server - Scripting Blog

The Admin’s First Steps: Capacity Planning Part 2

November 11, 2013 Nov 11, 2013 11/11/13
Doctor Scripto
Summary: Richard Siddaway talks about using Windows PowerShell to store data for capacity planning.  Hey, Scripting Guy! I’ve just starting learning PowerShell and I understand how to use it as a scripting language and shell. I’ve been told to start performing capacity planning for my servers, and I am wondering how I can use ...

Use PowerShell to Discover, Diagnose, and Document SQL Server

May 7, 2013 May 7, 2013 05/7/13
Doctor Scripto
Summary: SQL Server MVP, Kendal VanDyke, talks about using Windows PowerShell to discover, diagnose, and document all your computers running SQL Server. Microsoft Scripting Guy, Ed Wilson, is here. Kendal VanDyke is with us today to wrap up SQL Server Week. Kendal VanDyke is a practiced IT professional with over a decade of experience in SQL ...

10 Tips for the SQL Server PowerShell Scripter

May 6, 2013 May 6, 2013 05/6/13
Doctor Scripto
Summary: Microsoft PowerShell MVP, Chad Miller shares his top ten tips for the SQL Server Windows PowerShell scripter. Microsoft Scripting Guy, Ed Wilson, is here. Today’s blog is a bit unique. I was throwing around ideas with Chad Miller, and somehow we came up with the idea that he would share some tips for the SQL Server Windows ...

Use PowerShell to Clean-up SQL Server Jobs

May 5, 2013 May 5, 2013 05/5/13
Doctor Scripto
Summary: SQL Server MVP, Sean McCown, shows how to use Windows PowerShell to clean-up SQL Server jobs. Microsoft Scripting Guy, Ed Wilson, is here. Today we wrap up the weekend with the last of three blogs by guest blogger, Sean McCown. You can read more about Sean and his previous guest blogs on the Hey, Scripting Guy! Blog site. Take it away...

Use PowerShell to Examine Dirty and Expensive SQL Server Properties

May 4, 2013 May 4, 2013 05/4/13
Doctor Scripto
Summary: SQL MVP, Sean McCown, talks about using Windows PowerShell to examine Dirty and Expensive SQL Server properties. Microsoft Scripting Guy, Ed Wilson, is here. Here is blog two of three in a series from guest blogger, Sean McCown. Yesterday, we published Use PowerShell to Work with SQL Server Instance-Level Properties. You can read more...