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?
T-SQL Tuesday #150 – My First Technical Job
It’s time for T-SQL Tuesday. This month’s invite comes from Kenneth Fisher who asks to hear about our first technical job. Check out the full invite by clicking the T-SQL Tuesday image below: The Long Magenta Line Have you tried turning it off and on again? My first technical job was working in CNS (Computer … Continue reading T-SQL Tuesday #150 – My First Technical Job
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
- May 2022 (3)
- April 2022 (4)
- March 2022 (4)
- February 2022 (4)
- January 2022 (5)
- December 2021 (8)
- November 2021 (9)
- October 2021 (8)
- September 2021 (9)
- August 2021 (9)
- July 2021 (7)
- June 2021 (9)
- May 2021 (8)
- April 2021 (8)
- March 2021 (8)
- February 2021 (8)
- January 2021 (9)
- December 2020 (10)
Get new content delivered directly to your inbox.
Chad Callihan 