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.
Checking Every Database for Risky Settings
Find risky settings across every SQL Server database, including AUTO_SHRINK, AUTO_CLOSE, page verification, recovery model, and ownership.
SQLAuthority News – Fix : Remote Desktop Copy Paste Stop Working
My Remote Desktop copy paste stopped working both ways while I worked on a remote SQL Server. Restarting did not help, but the fix at the end of the post did.
Auditing Who Has sysadmin
Audit who has sysadmin in SQL Server, including direct members and Windows groups, then investigate nested access and forgotten logins.
SQL SERVER – Most Frequently Asked Generic Interview Questions
A list of the most frequently asked generic interview questions, from why you left your last job to what co-workers say about you. Think through your answers.