Most Recent Blog Posts

01/30/2012 - 7:19pm

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
01/27/2012 - 8:55am

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
01/02/2012 - 6:26pm

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