PowerShell is a powerful scripting tool that allows you to automate routine tasks, and script administrative tasks, allowing you to automate a lot of the routine work in a SQL envirionment. Ben Miller's Stairway Series introduces PowerShell from the beginning, guiding you through how to configure and get started with the framework before working towards more advanced scripting.  Read more...

We came across a scenario where database bak files being created from long time which are no more in use...  Read more...

Learn how to write a script for regular database backups using Powershell and SMO.  Read more...

PowerShell script to SlipStream SQL Server 2008 installer with SPx patch.  Read more...

This tip will demonstrate how to monitor SQL Failover Cluster Instances if they become unbalanced using Windows PowerShell.  Read more...

Query Active Directory Computer objects to verify existence  Read more...

Pre-Create Active Directory Virtual Computer objects to support a new SQL Cluster   Read more...

We all know that we should document our SQL Servers, right? RIGHT? So let's say you had some time on...  Read more...

Restores the latest backup of a database to a destination server of your choice, and creates a new backup if needed.  Read more...

Reading/scanning SQL Server Logs is a required DBA work item in all my work environments. I know there are lots...  Read more...

SQL Server SMO is a great resource for DBAs, unfortunately, before PowerShell, it is a pretty deep learning curve to...  Read more...

You should be on your way with PowerShell with the previous levels and now the topic shifts to using Functions and Assemblies built in to .NET for use with automation. This topic will be used in your PowerShell adventures throughout your career and this Stairway.  Read more...

This script is an improvement from my original script entitled "Powershell - Query SQL Servers Operating system details".   Read more...

Welcome to Day 27 of my “A Month of PowerShell” series. This series will use the series landing page on...  Read more...

Welcome to Day 25 of my “A Month of PowerShell” series. This series will use the series landing page on...  Read more...

Welcome to Day 22 of my “A Month of PowerShell” series. This series will use the series landing page on...  Read more...

Welcome to Day 21 of my “A Month of PowerShell” series. This series will use the series landing page on...  Read more...

The script works through the CMS you have set up to manage your environment and gathers various server information.  Read more...

Powershell. I have seen the word but what is it? This article gives you a basic introduction to what PowerShell is and how you might use it.  Read more...

Welcome to Day 13 of my “A Month of PowerShell” series. This series will use the series landing page on...  Read more...