Most Recent Blog Posts

Screenshot showing how to setup sending email alerts
08/22/2013 - 11:38am

Sending SQL Server Database Mail Alerts via Amazon’s SES

Here's how to get SQL Server’s Database Mail functionality to work with Amazon's excellent (as in highly available and absurdly affordably) Simple....More
yellow envelope with email symbol on black computer keyboard
08/19/2013 - 3:40pm

A Better Way to Enable Email Alerts for Deadlocks

Here's a quick and easy way to enable email alerts for deadlocks, without requiring any system table modifications....More
chocolate 3 layer cake
07/26/2013 - 1:40pm

Disappointing News About SQL Server 2014

It looks like SQL Server 2014 will keep the artificially imposed limit of 64GB per instance (along with 16 cores max) for SQL Server Standard....More
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
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) ×