While preparing for a security demo, I broke my SQL Server and was unable to start it. In this blog, we would lean about fixing error Unable to load user-specified certificate.
SQL SERVER – ERROR: Failed to verify the Authenticode signature of FileName
Sometimes there is some malware which would do changes on the machine which is impossible to track. Most of the time, based on my interactions with various clients, we need to format and rebuild the OS because you never know what data is getting compromised using which program running in the background. In this blog, we would learn about an interesting error Failed to verify the Authenticode signature of the filename.
SQL SERVER – Script – Turn off Firewall Remotely (PowerShell, NetSh, PsExec)
I was working with a client to deploy an automated solution to install SQL Server. Since this involved scripting and running PowerShell remotely, we wanted to disable the firewall. Due to automation, we were not supposed to log in to the server and use UI. So, I search on the internet and found a few ways to do that. In this blog, I am going to share scripts which can turn off the firewall remotely.
How to Convert Hex Windows Error Codes to the Meaningful Error Message – 0x80040002 and 0x80040005 and others? – Interview Question of the Week #182
This blog is not specific to SQL Server, but I have recently seen hex error codes in SQL Server ERRORLOG and it took me little time to get the meaning of it. In this blog, we would learn about how to convert a hex windows error codes to meaningful error messages.
SQL SERVER – Backup to URL – Script to Generate the Create Credential and Backup Command using Access Keys
Backup to URL is one of the common methods used in SQL Server perform backup to Azure Blob Storage. In this blog, I am going to share a script to generate the create credential and backup command using access keys.
How to Generate Random Password in SQL Server? – Interview Question of the Week #181
Question: How to Generate Random Password in SQL Server?
Answer: This is a fantastic question and here is the script to generate a random password in SQL Server
SQL SERVER – Backup to Microsoft Azure Tool – ERROR: Account Verification Failed
I have been seeing many customers moving their SQL Server to Cloud. Few of them have chosen Microsoft Azure platform to host their production server and few others have selected other cloud platforms like AWS. When they host SQL in Azure, they can choose various backup methods. In this blog, we would learn about fixing an interesting error “Account Verification Failed” while using Microsoft SQL Server Backup to Microsoft Azure Tool.