Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: September 2013

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…

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…

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…

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…

Read more

Introduction to Integrity: Corruption in Clustered Indexes and Heaps

For day three of this six part series Introduction to Integrity, sponsored by Idera, we will take a look at my number two integrity issue: corruption in clustered indexes or heaps. Unlike corruption in allocation pages, we have several options for dealing with this type of corruption. This particular corruption…

Read more

Introduction to Integrity: Corruption in Allocation Pages

Welcome back for day two of this six part series Introduction to Integrity, sponsored by Idera. In this post, I want to dig into the first integrity issue, corruption in allocation pages. If you run the DBCC CHECKDB command and get errors, I isolate the most important errors (Level 16)…

Read more

Introduction to Integrity: Interpreting DBCC CHECKDB Results

I want to start a short 6 post series to serve as an introduction to integrity in SQL Server. Most posts that I write on this subject are for intermediate or advanced users, so this is a break from the normal for me. I think it is a good break…

Read more

Is the Master Certification Dead or Will it be Born Again?

The Certified Master and Architect community was collectively notified Friday, August 30, 10 PM Pacific Time (Microsoft Time) that the Certified Master (MCM/MCSM) and Certified Architect (MCA) programs are essentially dead. For those of you who are already in the process of earning the certification, you have until October 1,…

Read more