Most Recent Blog Posts

standby button
12/23/2011 - 12:03pm

Off-Box Backups and Luke-Warm Standby Servers – Part II

Following up on my previous post, when it comes to the need to create off-box backups, there are really only two (well, three) main reasons you’d....More
screenshot of Back Up Database - SSV3
12/13/2011 - 12:32pm

Off-Box Backups and Luke-Warm Standby Servers – Part I

SQL Server’s RESTORE statement is insanely powerful. Not only because of the obvious fact that it can be handy in a disaster (when you have regular....More
SQL Server diagram of FULL Backup
11/29/2011 - 7:15pm

Breaking the Backup Chain – REDUX (Or Eating Crow)

While I like to pride myself on being professional enough to admit when I’m wrong, it turns out that I’m a bit more shallow than I’d like to be....More
11/17/2011 - 11:21am

Unused Secret Weapon: COPY_ONLY Backups

COPY_ONLY backups were a great addition to SQL Server 2005 (and up). Without them, it was all to easy for DBAs, devs, and SysAdmins to create a ‘....More
blue backup key on keyboard
10/31/2011 - 11:22am

SQL Server Backups: When More is Less

For most reluctant-DBAs there’s a certain degree of mysticism or ‘unknown’ about the SQL Server backups that they get ‘roped’ into managing. Moreover....More
10/25/2011 - 10:02am

Essential Techniques for SQL Server Memory Management

In my free webcast on Essential Techniques for SQL Server Memory Management, I made a number of references to additional resources that I would make....More
10/12/2011 - 5:38pm

Preemptive RowGuidCols on Merge Replicated Databases

One thing I’ve started doing more and more frequently with Merge Publications is preemptively adding in a rowguid column to tables that I know will....More
09/30/2011 - 12:08pm

Staying Safe from the Coming Storm

Hackers have been taking advantage of Graphical Processing Units (GPUs or Video Cards) for some time now to leverage their ‘massively parallel’....More
tmpdb Properties computer screenshot
09/27/2011 - 2:11pm

Long-winded thoughts on Migrating TempDB

One of the problems of having a developer background is that I tend to think of things in terms of distinct operations. Most of the time that can be....More
Hints and Tips yellow road sign
09/19/2011 - 4:00pm

Practical Tips for Initializing Replication Snapshots

I’ve recently spent a bit of time helping a client initialize snapshots for a number of production databases....More
Microsoft SQL Server Database Properties Auto Close screenshot
09/08/2011 - 2:05pm

Worst Practice: Allowing AutoClose on SQL Server Databases

Simply stated, allowing or enabling AutoClose on production SQL Server databases is a worst practice. What is AutoClose and why is it bad? AutoClose....More
database word cloud
08/23/2011 - 11:33am

Finding Potentially Unused Views in Your Databases

If I were granted two ‘wishes’ for SQL Server meta-data they would be: The addition of a created datetime column on sys.indexes. The addition of this....More
Microsoft SQL Server Replication Schema Option Parser screenshot
08/17/2011 - 6:42pm

Free Tool: Replication Schema_Option Translator

How’s Your Hex? I don’t spend nearly as much time with SQL Server Replication as I’d like. It’s a fun technology (even with its warts) that provides....More
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

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) ×