Most Recent Blog Posts

traffic orange hazard lights
07/18/2013 - 1:32pm

Tracking Live SQL Server File Stalls

Given that SQL Server workloads are commonly I/O bound, a great way to get a sense for how a given server is keeping up with its current workload is....More
SQL Server Managment Studio alerts
06/26/2013 - 6:21pm

Enabling Email Alerts for SQL Server Deadlocks

Learn how to trigger email (or other) alerts when a deadlock occurs on any given Microsoft SQL Server....More
Microsoft SQL Server Profiler output screen
06/25/2013 (All day)

Debugging (Nested) Stored Procedures with SQL Server Profiler

Nested stored procedures (or stored procedures that call other stored procedures) are a mixed blessing and a curse. They also serve as powerful....More
06/18/2013 - 2:59pm

Configuring and Troubleshooting Database Mail for SQL Server

In the past I've blogged a bit about the importance of enabling your SQL Servers to be pro-active in terms of alerting you via email when something....More
05/29/2013 - 5:04pm

Common Misconceptions about CXPACKET Waits

A number of things can contribute to CXPACKET waits within SQL Server....More
05/21/2013 - 12:45pm

A Common Misconception about MAXDOP

Out of the box, SQL Server is (and has been) able to take advantage of multiple processors/cores without any effort on behalf of administrators....More
05/09/2013 - 12:37pm

My ISO 8601-Compliant Signature

My family recently just "officially" announced that we're in the process of adopting a child from South Africa. We're quite excited, of course, but....More
Man drawing a SQL Server database plan
04/25/2013 - 5:53pm

SQL Server Index Naming Guidelines

In terms of actual, concrete, guidelines for naming SQL Server Indexes, I only have two pieces of what I would consider perfect advice....More
04/18/2013 - 1:37pm

SQL Server 2014 on the Horizon?

Microsoft is not only obviously busy on the next version of SQL Server, but that they’ve actually been at work on it for a long while now....More
04/10/2013 - 4:33pm

Migrating Custom Error Messages Between Servers

Over the past few years I’ve helped a number of clients migrate their SQL Server workloads from one server to another. In many cases, this has....More
03/27/2013 - 5:00am

Synchronizing Time on Workgroup Servers

If you’re operating servers in a workgroup, I highly recommend a special tutorial/approach as a great way to help keep your servers better....More
02/26/2013 - 11:38am

SQL Server Essentials For Non-DBAs

In my session on SQL Server Essentials for Non-DBAs I tried to provide a very high-level overview of key concepts and concerns that ‘reluctant’ or ‘....More
02/11/2013 - 3:27pm

Using Dropbox for SQL Server Backups

It should go without saying that organizations aren’t created equally; what works for some would be preposterous for others, and so on....More
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
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) ×