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.

Read More

SQL SERVER – Database Mirroring Login Attempt Failed With Error: ‘Connection Handshake Failed. An OS Call Failed: (80090350)

While Microsoft has introduced an AlwaysOn availability group feature in SQL Server 2012 and people have been using it instead of database mirroring. In this blog, we would learn how to fix error Database Mirroring login attempt failed with error: ‘Connection handshake failed. An OS call failed: (80090350).

Read More

How to Check Status of Instant File Initialization? – Interview Question of the Week #184

Question: How to Check Status of Instant File Initialization?

Answer: This is a follow-up question of the previous blog post which I shared earlier. Please read this blog post before reading this blog for complete information: How to Check If Instant File Initialization Enabled or Not?

Read More

SQL SERVER – How to Check If Instant File Initialization Enabled or Not?

The question such as this makes my day during the Comprehensive Database Performance Health Check. One of the DBA asked if there is an easy way to know if they have Instant File Initialization Enabled or Not for their server. Honestly, this is a very simple question but there was no quick answer to this one before SQL Server 2016. However, if you are using SQL Server 2016 or later version of SQL Server, you can figure out the status of the instant file initialization pretty quickly.

Read More

SQL SERVER – Install Error: Microsoft Cluster Service (MSCS) Cluster Verification Errors – Part 2

In recent past, I was assisting a client in installing SQL Server clustered instance in a Windows Cluster. There were many errors encountered and I learned a lot from this experience. In this blog, we would learn about Microsoft Cluster Service (MSCS) cluster verification errors which might appear during installation or AddNode.

Read More

SQL SERVER – Install Error: Microsoft Cluster Service (MSCS) Cluster Verification Errors – Part 1

In recent past, I was assisting a client in installing SQL Server clustered instance in a Windows Cluster. There were many errors encountered and I learned a lot from this experience. In this blog, we would learn about Microsoft Cluster Service (MSCS) cluster verification errors which might appear during installation or AddNode.

Read More

SQL SERVER – Installation Error – Unable to Open Windows Installer File – 2147286960

SQL installation and parching are the processes which every DBA has to do. Some smart DBAs do this via script and some go with a manual approach. When it fails, it is fun to debug it because you have to take help from internet to find possible causes and solution. In this blog, we would learn about how to fix error Unable to open Windows Installer file -2147286960.

Read More
Menu