Author: Rob

It’s a Corrupt World

Luckily, in this day and age we don’t see so much database corruption, but it still sends a chill down the spine every time it pops up. Having doubt with a number of cases in a number of different places now it’s not the corruption that bothers me so much as the pure amount of time it takes to fix. Here’s some tips to get the application online as quickly as possible.

Read More →

TSQL to get last good DBCC CHECKDB

This is a piece of code I use to determine the last known good DBCC CHECKDB being run against a database. I’m surprised this information is so tricky to find. I’d expect it to be sitting on the database properties tab right under last known full backup. but it’s not. Instead it is listed as a database Info property, and we need to jump through some hoops to find it.

Read More →

Optober – SQL sp_configure options – Backup Compression Default

Optober continues with more sp_configure option descriptions. This time it’s all about backup compression default. I was surprised today when doing a review that a client was still under the impression that backup compression was still an enterprise feature. No no no no no. It’s there for everyone with standard edition since SQL Server 2008 R2 and there’s really no reason not to be using it.

Read More →