Most Recent Blog Posts

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
SQL Server data storage rack
06/26/2012 - 1:55pm

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
06/14/2012 - 10:24am

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
05/31/2012 - 2:56pm

SQL Server Database Corruption, Part XII: Recovery Sample

In my last post in this ongoing series on SQL Server database corruption I mentioned that my next post would be to provide a ‘soup to nuts’ sample or....More
green corrupt data illustration
05/25/2012 - 12:53pm

SQL Server Database Corruption, Part XI: Full Recovery Operations

In part 9 of this series on SQL Server database corruption I defined a list of key things to do when responding to database corruption. And in that....More
05/18/2012 - 5:18pm

SQL Server Database Corruption, Part X: Page Level Restore Operations

In my previous post in my ongoing series on SQL Server database corruption I covered a list of best practices for responding to database corruption....More
04/26/2012 - 10:13am

SQL Server 2012 eLearning Resources

What makes AlwaysOn Availability Groups so powerful is the fact that DBAs can now use this single technology to achieve solutions that enable high....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) ×