Most Recent Blog Posts

standby button
Dec 23, 2011

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
Dec 13, 2011

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
Nov 29, 2011

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
Nov 17, 2011

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
Oct 31, 2011

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
Oct 25, 2011

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
Oct 12, 2011

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
Sep 30, 2011

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
Sep 27, 2011

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
Sep 19, 2011

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
Sep 08, 2011

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
Aug 23, 2011

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
Aug 17, 2011

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
Aug 09, 2011

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
Jul 25, 2011

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