After a ransomware attack, a client could not attach database files and saw: The PageAudit property is incorrect. Here is what the error means.
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 – How to Generate Random Password? – Enhanced Version – Part 2
James Curran built on Tim Cartwright’s work to create a stored procedure that can generate random password strings with letters, digits and special characters.
SQL SERVER – Unable to Load User-Specified Certificate [Cert Hash(sha1) “Thumbprint.here”]. The Server Will Not Accept a Connection
While preparing a security demo, I broke my SQL Server and it would not start: Unable to load user-specified certificate. Here is how I fixed error 26014.
SQL SERVER – ERROR: Failed to verify the Authenticode signature of FileName
SQL Server logged: Failed to verify the Authenticode signature of sqlservr.exe. Here is what the message means and why it can point to malware on the machine.
SQL SERVER – Script – Turn off Firewall Remotely (PowerShell, NetSh, PsExec)
An automated SQL Server install meant we had to disable the firewall without logging in. Here are three ways to turn it off remotely: NetSh, PowerShell and PsExec.
How to Convert Hex Windows Error Codes to the Meaningful Error Message – 0x80040002 and 0x80040005 and others? – Interview Question of the Week #182
Seen hex error codes like 0x80070070 in the ERRORLOG? Here are the simple steps I use to convert hex Windows error codes into meaningful error messages.