Most Recent Blog Posts

Mar 07, 2012

SQL Server Database Corruption, Part VI: Regular Corruption Checks

Previously we looked at how to set up alerts for cases where SQL Server encounters issues with the storage subsystem. Setting those up is a key....More
Feb 24, 2012

SQL Server Database Corruption, Part V: Storage Problem Alerts

Continuing on from our last post where we looked at setting up CHECKSUM verification as one means of helping more readily detect corruption early-on....More
Feb 21, 2012

SQL Server Database Corruption, Part IV: CHECKSUM Page Verification

In order to be able to better deal with corruption, you need to be able to detect it early. To that end, there are actually a number of different....More
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

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