Most Recent Blog Posts

08/09/2011 - 7:43pm

Book Review: Microsoft SQL Server 2008 R2 Administration Cookbook

I read lots of books on SQL Server. In fact, I’m probably the Imelda Marcos of SQL Server books in some ways – as I’m constantly collecting and....More
07/25/2011 - 11:30am

Dilbert, Billiards, the US Navy, and SQL Server Backups

What do Dilbert, Billiards (or Pool), the US Navy, and your SQL Server Backups all have in common?....More
06/29/2011 - 11:20am

Don’t Confuse High Availability with Disaster Recovery

I recently spoke at WindowsIT Pro’s Keeping Mission-Critical Applications Available online event. My session, High Availability Isn’t Disaster....More
06/22/2011 - 9:08pm

Forcing Collation in the WHERE Clause - 22 Jun 2011

The ability to granularly define collation settings can be a huge win when it comes to the need to localize data—because it allows you localize at....More
06/07/2011 - 9:40am

Why is SQL Server running DBCC CHECKDB against my databases at Server Startup?

Question: Checking the SQL Server Logs on a server that recently rebooted, it looks as if SQL Server is actually running DBCC CHECKDB against most of....More
05/27/2011 - 3:19pm

Twitter for SQL Server Professionals

Twitter has been compared to email, RSS, and even the web itself in terms of its impact on communication and the sharing of information. Yet many IT....More
05/20/2011 - 4:03pm

T-SQL Parameters and Variables: Basics and Best Practices

T-SQL basic guidelines and best practices for Parameters within Stored Procedures and Functions from SQL Server expert Michael Campbell....More
05/07/2011 - 4:46pm

Semi-Advanced Logging Options for SQL Server Agent Jobs

Take Advantage of some simple functionality within SQL Server Management Studio to gain practical insight and additional context and logging on....More
04/28/2011 - 9:30am

SQL Server Disaster Recovery and Prevention - Resources

On April 28, 2011 I presented part of a free presentation on SQL Server Disaster Recovery and Prevention. This online presentation will be available....More
04/22/2011 - 2:12pm

Essential Resources for DBAs

Earlier this week I presented a three part eLearning seminar: Essential Skills for SQL Server DBAs. Attendance was great and I got some great....More
04/14/2011 - 10:42am

Introducing SQLContinuitySIM

In my previous post, I outlined the importance of SQL Server RTOs and RPOs. I also explained why regularly testing Disaster Recovery (DR) and High....More
04/12/2011 - 2:34pm

SQL Server Recovery Time Objectives and Recovery Point Objectives

Learn how these often unaddressed considerations can be the key to taking control of your systems and ensuring increased availability....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) ×