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.
SQL SERVER – FIX: Error – The Job Failed. Unable to Determine If The Owner Domain\User of Job Job_Name Has Server Access
A SQL Agent job failed with: The job failed. Unable to determine if the owner of the job has server access. Here is how I fixed this error in my lab.
Which is Faster – INSERT INTO SELECT or SELECT INTO? – Interview Question of the Week #187
Which is faster, INSERT INTO SELECT or SELECT INTO? A client moving large data between tables asked me, and here is what we found when we tested both.
SQL SERVER – Unable to Remove Replication Publication – Could not Delete the Subscription at Subscriber ‘SubServer’ in Database ‘SubDB’
On my broken replication lab, removing a publication failed with: Could not delete the subscription at Subscriber ‘SubServer’. Here is the command that fixed it.