Browsing the blog archives for September, 2014

Color code SSMS status bar

I work with all kinds of SQL Server instances.  All of them are one of three possible types: Development Test Production Many of my scripts have a quick query at the top to get the server name (@@servername).  I use this to double check the server instance I’m on.  More specifically, I use this to […]

0 Comments

Using EVENT NOTIFCATION to ALERT on user query CPU usage

We often have customers running ad hoc queries on the databases that we host.  Most of the time the queries run fine… sometimes they don’t. The first step we took towards managing rogue queries was to deploy Resource Governor (only available in Enterprise or Developer editions) to limit their MAXDOP.  In general, a rule of […]

0 Comments