Most Recent Blog Posts

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 Logs

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 To

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
Jun 14, 2012

SQL Server Database Corruption, Part XIII: RECAP

One of the things I wish I had done a bit better in my previous ‘series’ of posts on SQL Server database corruption was provide better links and....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) ×