Most Recent Blog Posts

Feb 09, 2012

SQL Server Database Corruption, Part III: Preventing Corruption

In this post we’ll talk about more about corruption—in terms of addressing how you can prevent it....More
Jan 30, 2012

SQL Server Database Corruption, Part II: Simulating Corruption

In my last post I provided an overview of what SQL Server database corruption is—and how it’s almost always caused by problems at the IO subsystem (....More
broken data disk
Jan 27, 2012

SQL Server Database Corruption, Part I: What Is Corruption?

When it all comes down to it there are really only two main things that DBAs need to worry about: making data available to the proper people, and....More
computer keyboard with red backup key
Jan 02, 2012

Off-Box Backups and Luke-Warm Standby Servers, Part III

Just having copies of your SQL Server backups in secondary/remote locations is not a disaster recovery plan....More
standby button
Dec 23, 2011

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

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

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 Backups8

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 Less3

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 Databases2

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

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