SQL Server Activity Monitor Script

You ever wonder what goes in the background of Activity Monitor? Me neither, I just used it every so often when I wanted a quick peek at what was going on for a server. Microsoft has actually made changes to Activity Monitor in SQL Server 2012 Service Pack 1 that... [Read More]
Tags: sqlserver

SSMS 2012–Object Reference issue with Maintenance Plans

I am amazed at some of the information you can find on the Internet when searching for an issue. Especially with forum posts that mention your issue (or flat out are the exact same), but do not include any final resolution. The best one I came across was this one... [Read More]
Tags: sqlserver

Check-InstanceConfig (part 2)

In the previous post I discussed the data table that holds the default values for the configuration options in SQL Server 2000 up to SQL Server 2014. [Read More]
Tags: powershell, sqlserver

Check-InstanceConfig (part 1)

I was reading a blog post Mike Walsh published on Linchpin People last week: SQL Server Configuration Check Script. [Read More]
Tags: powershell, sqlserver

Calc-MaxSample

I am working on building a function that will allow me to gather performance counter data across multiple servers. I knew this had done by someone in the SQL Server family and went to search the inter-web. I came across Aaron Bertrand’s (blog | twitter) blog post here. [Read More]
Tags: powershell