Latest from the Blog

Always Backup WITH CHECKSUM?

When you’re specifying WITH CHECKSUM as you’re backing up databases, SQL Server will use checksums to help catch any inconsistencies with pages. This seems like a setting that you should always use and would expect to be a default setting. So why doesn’t SQL Server include it by default? They Are Who We Thought They … Continue reading Always Backup WITH CHECKSUM?

Multiple Counts in One Query

Have you have been tasked with pulling multiple counts from the same table? Maybe you need to find how many records have a value for a column and how many are NULL. Or maybe you need to see how many records are true and how many are false. It’s simple enough to run a query … Continue reading Multiple Counts in One Query

Get new content delivered directly to your inbox.