Most Recent Blog Posts

computer software disks with handcuffs laying on top
01/28/2013 - 4:38pm

SQL Server Standard Edition Licensing Limits

SQL Server 2008 R2 and SQL Server 2012 Standard Edition are both limited to a maximum of 4 sockets/16 cores and a measly 64GB of RAM....More
12/31/2012 - 2:07pm

My Favorite Tool of 2012: Remote Desktop Manager

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
12/18/2012 - 1:31pm

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
11/26/2012 - 5:03pm

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
11/12/2012 - 5:00pm

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
11/09/2012 - 12:39pm

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
10/10/2012 - 12:30pm

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
10/02/2012 - 11:14am

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
09/18/2012 - 3:16pm

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
09/13/2012 - 11:33am

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
08/28/2012 - 10:25am

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
08/17/2012 - 10:18am

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
07/25/2012 - 5:30pm

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
07/13/2012 - 12:29pm

SQL Server 2012's INDIRECT CHECKPOINTs

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
06/30/2012 - 12:01pm

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
Contributors

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) ×