Most Recent Blog Posts

04/08/2014 - 1:28pm

NoSQL: Eventual Consistency Yields Major Flaws

While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a....More
04/01/2014 - 1:35pm

SQL Server 2014 Now Available—No Joke

Initial word on the street is that SQL Server 2014 has been very stable so far—which is probably why it went to release so quickly and bypassed what....More
Alt key on computer keyboard
03/25/2014 - 5:14pm

Simple SQL Server Management Studio Trick: Multiple Line Text Editing

I've bumped into a few folks over the past year or so who simply don't know that you can easily edit (contiguous/similar) details across multiple....More
SQL Server acceptance testing at a desk
03/17/2014 - 3:27pm

SQL Server Acceptance Testing: A Subtle Trick

For people who are simply too busy to tackle much needed SQL Server acceptance testing, I've found that a key way to tackle this is to simply....More
yellow and blue datacenter cables
03/11/2014 - 1:36pm

Detailed Migration Steps for SQL Server Upgrades, Part III

Important post migration tasks are outlined in part III of this series on the steps you'll want to use when demoting an older server and promoting a....More
Man in a datacenter
03/11/2014 - 1:09pm

Detailed Migration Steps for SQL Server Upgrades, Part II

Here's Part II of an overview of actual steps you'll want to use when demoting an older server and promoting a newer server as part of a SQL Server....More
computer key labeled Upgrade
03/11/2014 - 12:01pm

Detailed Migration Steps for SQL Server Upgrades, Part I

Get an overview of actual steps you'll want to use when demoting an older server and promoting a newer server as part of a SQL Server upgrade or....More
Problems and Solutions road signs
02/28/2014 - 3:15pm

Reasons to Avoid SQL Server In-Place Upgrades

As a consultant, one of the things I commonly do is help organizations 'upgrade' to newer editions of SQL Server. When doing so, I never recommend in....More
database digram
02/25/2014 (All day)

Using Cache to Save $200,000

Recently, I've been working with a consulting client to help them tame CPU usage. Typically, they're clocking over 20,000 queries and operations per....More
02/19/2014 - 1:04pm

A Day in the Life of a DBA

What should most database administrators be doing on a regular basis? Here's a comprehensive list from Michael K. Campbell of many of the things DBAs....More
01/31/2014 - 7:18pm

The Importance of Properly Documenting Job Responsibilities and Expectations

Key concepts and concerns about documenting job responsibilities and expectations that anyone working in IT or with databases should keep in mind....More
01/29/2014 - 12:21pm

IPMuncher for Internet Facing SQL Servers

IPMuncher is a fantastic tool that offers simple functionality, great flexibility, and easy configurability—meaning that it can be used to tackle a....More
01/24/2014 - 6:08pm

The Value of a Good SQL Server Book

I’ve learned a lot about SQL Server in the past 14 year—and continue to learn more about it every day as I troubleshoot tons of problems and issues....More
12/30/2013 - 9:02pm

My Favorite Tool of 2013: CloudBerry Backup - Server Edition

I’ve increasingly been bumping into clients with the need to find a dependable, configurable, durable, and secure off-site backup mechanism and....More
12/27/2013 - 7:14pm

Cycling (and Retaining) SQL Server Logs

While it is cool to see a SQL Server running for months at a time, that ‘coolness’ is lost when everything during those 100+ days has been logged to....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) ×