An untested backup is the darkest joke in the DBA world. Here’s how the story usually ends, and the simple restore drill that keeps you out of it.
SQL Server – Good Articles on Database Collation
Database Collation defines default character comparison rules for a database. I also inspect the columns and expressions involved.
SQLAuthority News – 500th Post – An Interesting Journey with SQL Server
I am very pleased to write my 500th post on SQLAuthority. Thank you to my family and to all of you, plus a look at the blog’s milestones so far.
Planning a Move Off an Old SQL Server Version
Plan a move off an old SQL Server version with a complete inventory, compatibility testing, a supported target, and a dated exit plan.
Rolling Back a Cumulative Update Safely
Rolling Back a Cumulative Update needs backups, setup evidence, a tested uninstall path, and special care for databases changed after patching.
SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Microsoft Quotes
I have received many emails that I should write more post like SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Quotes.
Standard Settings for a New SQL Server Install
Review standard settings for a new SQL Server install, including memory, MAXDOP, tempdb, backups, and alerts before users depend on it.