Category: PowerShell

Monthly DBA Maintenance Tasks for SQL Server
Posted by Rob Risetto on July 22, 2015

This is Jason’s take on the monthly tasks for a SQL Server DBA (10 Monthly Maintenance Tasks for SQL Server). My recommendation is that these tasks should be automated where possible.

Continue Reading

Powershell for DBAs – Working with DB Exclude Lists
Posted by Rob Risetto on October 02, 2014

This post is part 2 of the Powershell for DBA – Working with INI Files and describes a simple method and then a more complex method to exclude databases from subsequent processing within a Powershell script.

Continue Reading

PowerShell for DBAs – Working with INI files
Posted by Rob Risetto on June 25, 2014

Over the last 3 years I have developed a range of major PowerShell scripts to deploy/configure Replication, SQL Server clustering onto multiple nodes and to perform Database Maintenance tasks (think Ola Hallengren SQL maintenance solution but in PowerShell).

Continue Reading