Most Recent Blog Posts

Dec 31, 2012

My Favorite Tool of 2012: Remote Desktop Manager3

I’ve used gobs of tools this year. Too many to mention. Many of them just plain awesome. But one tool stands out above the rest – to the point where....More
Dec 18, 2012

SQL Server and Anti-Virus

Every once in a while, one of my SQL Server Consulting clients asks me for my opinions about running Anti-Virus on production SQL Servers. And,....More
Nov 26, 2012

Avoiding 'Failed to notify <operator> via email' errors

If a picture is worth a thousand words, then the words associated with the following picture would probably involve a decent amount of muttering and....More
SQL Server Log File Viewer screen shot
Nov 12, 2012

Who's Guarding Your Guard?

My grandfather (who was a Marine pilot during WWII and who was later issued the Navy Commendation Medal in person, by President John F. Kennedy, for....More
Phoenix, Arizona highway Loop 101 road signs above streets
Nov 09, 2012

Another Analogy About the Importance of Statistics

In my most recent post, I touched upon the importance of SQL Server Statistics by way of an analogy—in terms of comparing the importance of up-to-....More
Oct 10, 2012

The Importance of SQL Server Statistics

It’s impossible to overstate just how important statistics are to SQL Server. Without them, SQL Server’s impressive cost-based optimizer simply....More
videos written on a blue keyboard key
Oct 02, 2012

Free SQL Server Videos

A few years ago I spent an obscene amount of time creating a website where I could offer a number of free video tutorials about SQL Server. My idea....More
computer keyboard with blue tool key
Sep 18, 2012

Don't Forget about Backup Compression

I recently ‘inherited’ a couple of SQL Servers for a client – running SQL Server 2008 (Enterprise Edition). In the process of ‘taking over’ these....More
performance check list
Sep 13, 2012

Performance Tip: Find Your Most Expensive Queries

One thing I’m asked on a regular basis when working with SQL Server Consulting clients that don’t have much experience with performance tuning, is....More
screenshot of SQL Server Agent
Aug 28, 2012

DBAs and the SQL Server Agent

Following-up on previous posts where I addressed some basics about how DBAs should regularly review SQL Server Logs and be aware of what’s going on....More
Aug 17, 2012

DBAs and SQL Server Logs1

In a previous post I opined about how import it can be for DBAs to keep tabs on their underlying hosts by paying attention to Windows Event Logs. In....More
Jul 25, 2012

DBAs and Windows Event Logs

While watching a military documentary with my son the other night, I was struck by just how crazy it is that snipers need to account for wind. I mean....More
Check Point sign on metal fence
Jul 13, 2012


SQL Server 2012’s AlwaysOn functionality rightly deserves to ‘steal the show’ in terms of all of the press and attention it gets when people learn....More
Jun 30, 2012

Teaching this Old Dog New Tricks – Database Mail Management

I have an embarrassing confession about something I learned a while back about the GUI within SQL Server Management Studio (SSMS) for managing the....More
SQL Server data storage rack
Jun 26, 2012

Disk Space Monitoring: How To1

Keeping tabs on available disk space on your SQL Servers is something that every DBA should do—because once SQL Server runs out of disk on the....More

Michael K. Campbell

Michael K. Campbell is a contributing editor for SQL Server Pro and Dev Pro and is an ASPInsider. Michael is the president of OverAchiever Productions, a consultancy dedicated to technical evangelism...
What's Practical SQL Server?

Practical advice, insight, and help for core SQL Server considerations.

Blog Archive

Sponsored Introduction Continue on to (or wait seconds) ×