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.
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 – Learning New Multipurpose FORMAT Function
Before SQL Server 2012 you needed CONVERT with style codes to format dates. See how the FORMAT function gives you dd/mm/yyyy, mm/dd/yyyy and more in one call.
SQL SERVER – Why We have Audit Trace in DATA Folder? What are These Files?
The DATA drive filled up with thousands of audittrace .trc files. Here is why SQL Server writes audit trace files there and how to stop them.
PowerShell – Tip: How to Format PowerShell Script Output?
Raw PowerShell output is hard to read. Here are three common ways to format PowerShell script output, starting with Format-Table, so results make sense.
SQL SERVER – Installation Error – File Format is Not Valid
At the license agreement step, SQL Server setup stopped with ‘File format is not valid’. Here is what caused this Installation Error for my client and the fix.