A client’s production database was stuck in suspect state and they could not even drop it. Here is how I helped them drop the suspect database.
What Part of the SQLDump Suggest Database Corruption? – Interview Question of the Week #188
What part of the SQLDump suggest database corruption? A reader asked, and I show the DbccResults tag in the SQLDump text file that confirms it.
SQL SERVER – FIX: CREATE FILE Encountered Operating System Error 5 (Access is Denied.)
After a disk migration on a cluster, SQL Server would not start: CREATE FILE encountered operating system error 5 (Access is denied.) on TempDB. I share the fix.
SQL SERVER – Upgrade Blocked: The Specified Edition Upgrade is Not Supported
Upgrading SQL Server 2008 R2 Express to SQL Server 2012 Evaluation failed with: Upgrade Blocked: The specified edition upgrade is not supported. Let me explain why.
SQL SERVER – FIX: Backup to URL Error: Operating System Error 50(The Request is Not Supported.)
My Backup to URL jobs started failing with Operating system error 50 (The request is not supported.). Here are the ERRORLOG messages and how I fixed it.
SQL SERVER – Generating Fixed Width OTP Values with Cryptographic Randomness
A Random Function for a six-digit code needs suitable randomness and deliberate formatting. A reader wanted codes for new app registrations.
Finding Hard-Coded Passwords in Stored Procedures
A short regular expression can list the procedures that hide a password, without printing it. Here is the scan, its false alarms and its blind spots.