SQL Server Pro
Connect With Us
Home > Blogs > Practical SQL Server

Practical SQL Server

Most Recent Blog Posts

by Michael K. Campbell May. 21, 2013

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
by Michael K. Campbell May. 9, 2013

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
by Michael K. Campbell Apr. 25, 2013

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
by Michael K. Campbell Apr. 18, 2013

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
by Michael K. Campbell Apr. 10, 2013

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
by Michael K. Campbell Mar. 27, 2013

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
by Michael K. Campbell Feb. 26, 2013

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
by Michael K. Campbell Feb. 11, 2013

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
by Michael K. Campbell Jan. 28, 2013

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
by Michael K. Campbell Dec. 31, 2012

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
by Michael K. Campbell 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
by Michael K. Campbell 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
by Michael K. Campbell 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
by Michael K. Campbell Nov. 9, 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
by Michael K. Campbell 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
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...
View all Contributors
What's Practical SQL Server?

Practical advice, insight, and help for core SQL Server considerations.

Blog Archive
SQLMag.com
Related Sites
Copyright © 2013 Penton Media, Inc