Most Recent Blog Posts

computer key labeled Upgrade
Mar 11, 2014

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
Feb 28, 2014

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
Feb 25, 2014

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
Feb 19, 2014

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
Jan 31, 2014

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
Jan 29, 2014

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
Jan 24, 2014

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
Dec 30, 2013

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
Dec 27, 2013

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
virus detected message on computer screen
Dec 19, 2013

Another Reason to Avoid Anti-Virus on SQL Server

If you install anti-virus on SQL Server, many 'bigger' anti-virus vendors either offer 'options' that let them 'monitor' SQL Server—or just plain....More
Nov 26, 2013

Setting Up Alerts for Long-Running Transactions

Learn how to set up alerts for long-running SQL Server transactions....More
Nov 19, 2013

Common SQL Server AlwaysOn Gotchas

As part of my "5 Common Gotchas with SQL Server AlwaysOn" presentation, I mentioned that I'd provide a links and additional resources as a follow up....More
scary ghoul
Oct 31, 2013

SQL Injection: Something Really Scary

As far as I'm concerned we'll likely always have SQL Injection around to haunt us. Even though this attack vector has been well-publicized and well-....More
Tired old dog on laptop.
Oct 29, 2013

SQL Server and Health Checks: A Slightly Different Take

Physical health is important for database professionals. Mentally, we do lots of heavy lifting....More
man in a datacenter explaing sql server performance
Oct 22, 2013

Creating Simple Performance Baselines with SQL Server Profiler

Use SQL Server Profiler to create a performance baseline and then measure performance metrics that you can compare against the baseline....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) ×