2016/2017 Whitepaper Updates

One of the problems with whitepapers is that they get out of date pretty quickly. It’s important to update them regularly to keep them relevant. A few of my older whitepapers have been updated by my friend and colleague Kenneth Fisher (blog|@sqlstudent144). I helped with some technical review and provided the original content, but the rewrites were all his. You can download the updated whitepapers using the links below: DBA Tactics for optimizing SQL Server Network Performance Initializing Replication from
read more

T-SQL Tuesday #85 Part Deux: Backup Myth Restoring Differential Backups

Welcome to T-SQL Tuesday #85 being hosted this month by Kenneth Fisher (blog|@SQLStudent144). This month’s topic is “Backup and Recovery”. This is one of my favorite topics, so the hard part was narrowing down what I want to cover .. as you can probably tell by me doing a second post for this month. I call this one T-SQL Tuesday #85 Part Deux. If you would like to participate in this month’s blog party, go to Kenneth’s invitational blog post:
read more

T-SQL Tuesday #85: Backup Log With NoRecovery

Welcome to T-SQL Tuesday #85 being hosted this month by Kenneth Fisher (blog|@SQLStudent144). This month’s topic is “Backup and Recovery”. This is one of my favorite topics, so the hard part was narrowing down what I want to cover. If you would like to participate in this month’s blog party, go to Kenneth’s invitational blog post: T-SQL Tuesday #85: Backup and Recovery. NoRecovery Many of you already familiar with the NORECOVERY option for performing restores to allow you to continue
read more

T-SQL Tuesday #81 – Migrating Databases with Dell LiteSpeed

It’s time for T-SQL Tuesday again, and this month’s host is fellow Certified Master and Data Platform MVP Jason Brimhall (Blog|@sqlrnnr). Jason has challenged us to spend some time sharpening a skill and then blog about it. For my participation, I found myself needing to get reacquainted with a third-party backup software that I had not used in many years, LiteSpeed for SQL Server by Dell. I worked with LiteSpeed extensively many years ago when I was a DBA at
read more

Schema-only Backups and Restores

I was reading the blog post Time for a Quick Rant by Grant Fritchey (blog|@GFritchey) about people who choose to not back up a database simply because it is large. I agree wholeheartedly with Grant on this topic. Simply choosing not to back up a database is, well to put it nicely, reckless. The comments that followed brought up some good points about some scenarios where you might choose to not back up a very large database. I performed operations
read more

Who Owns SQL Backups?

I was asked by Idera to take a look at the things that could cost a DBA their job. This has lead to a new whitepaper I wrote about the 5 mistakes that DBAs make that can cost them their jobs. Watch Idera’s Resource Central or follow @Idera_Software on Twitter to see when the whitepaper is released. In this post, I’m going to take a peek at one of the mistakes. This is a topic I hear come up time
read more

Introduction to Integrity: Data Purity Errors

The final day of this six part series, Introduction to Integrity, sponsored by Idera and their new free tool SQL Integrity Checkhas finally reached its conclusion. Today is the final post and the final integrity issue that I am going to talk about: Data Purity Errors. Data purity issues are when the value stored in a column is out of range for the data type. This is a rare error for databases created in SQL Server 2005 or newer. The
read more

Introduction to Integrity: Chain Linkage Problems

We’re approaching the end of our six part series Introduction to Integrity, sponsored by Idera with our last two postings this week. One of the last two integrity issues, and the one I’ll cover today is chain linkage problems. Chain linkage problems are metadata corruption issues. It is possible in certain situations for the links from one page to another to get corrupted. All pages in an object or index have pointers to the previous and next pages in the
read more

New Whitepaper: 5 Most Common Critical SQL Integrity Issues

Have you been putting off running integrity checks on your databases? Are you unsire where to start or what to do? Stop hesitating and get started right now. If you are new to database integrity and corruption, we have a helping hand to get you started. A new whitepaper on the 5 Most Common Critical SQL Integrity Issues that DBAs will face in their career will get you started. A crucial part of managing SQL Server is performing regular integrity
read more

Introduction to Integrity: Corruption in Nonclustered Indexes

It’s day four of our six part series Introduction to Integrity, sponsored by Idera, and tonight’s topic is going to be an easy one. You won’t even need good backups to deal with this one. After you have dealt with several incidents of corruption, you will find yourself hoping for an index ID greater than 1 when you encounter corruption. Corruption in nonclustered indexes is the easiest form of corruption to fix as long as the underlying heap or clustered
read more