September 2012

Use Powershell to Manage Idera SQL Diagnostic Manager

Idera SQL Diagnostic Manager (or as I call it “SQLdm”) is a great monitoring and performance tuning tool that I was introduced to a few years ago. There are no server-side agents, so it’s a very lightweight tool and good for monitoring all SQL Servers in your environment. The GUI is great for managing servers except when I need to put all monitored servers in maintenance mode. If I’m only monitoring a few servers, it’s not that big of a deal. However, if I’m monitoring a hundred servers, then using the GUI to place them all in maintenance mode could...

Continue reading...

Welcome to Everday SQL

My name is Patrick Keisler and I have been a Microsoft SQL Server DBA for over 12 years.  During that time I have been working for Wells Fargo Securities.  I have gained considerable knowledge over this time in various production support duties, including performance tuning, database design, database maintenance, monitoring, and project management.  I started this blog to share my knowledge of SQL Server with the hope of saving DBAs time and effort in their everyday tasks.

Continue reading...