What is Lock Pages in Memory? It keeps data in physical RAM instead of paging it to disk, and here is the gotcha and how to enable it step by step.
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 – Database Mirroring Login Attempt Failed With Error: ‘Connection Handshake Failed. An OS Call Failed: (80090350)
Connection handshake failed with 0x80090350 on an availability group replica. What the code means, why it says mirroring, and what to check.
How to Check Status of Instant File Initialization? – Interview Question of the Week #184
Here are two quick ways to check status of Instant File Initialization: read the error log, or query sys.dm_server_services on SQL Server 2016 and later.
SQL SERVER – How to Check If Instant File Initialization Enabled or Not?
Is Instant File Initialization enabled on your server? Before SQL Server 2016 there was no quick answer, but from 2016 onward you can check it in seconds.
SQL SERVER – Install Error: Microsoft Cluster Service (MSCS) Cluster Verification Errors – Part 2
Part 2 of my series on the MSCS cluster verification errors rule in SQL Server setup: another cause we found in Detail.txt during install or AddNode.
SQL SERVER – Install Error: Microsoft Cluster Service (MSCS) Cluster Verification Errors – Part 1
Installing a SQL Server clustered instance failed the Microsoft Cluster Service (MSCS) Cluster Verification rule. Part 1 covers the verification report cause.