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.
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.
Huge Transaction Log File in SQL Server: Find the Cause
A huge transaction log file has a named reason in log_reuse_wait_desc. This post builds a small demo database, reads that reason, backs up the log and finds the open transaction that holds it. It ends with a one time shrink and a safe growth step.
SQL SERVER – Error: 17300 – The Error is Printed in Terse Mode Because There was Error During Formatting
SQL SERVER – Error: 17300 – The Error is Printed in Terse Mode Because There was Error During Formatting. Let us fix that in this blog.