Tested TDE with Instant File Initialization on SQL Server databases

Testing impact of Transparent Data Encryption on Database Instant File Initialization Read more →

How to Benchmark SQL Server for a hardware migration

Benchmarking a SQL Server environment for a hardware migration has a few challenges Read more →

How to get members of BUILTIN\ADMINISTRATORS with Powershell

Get flexible with Powershell & BUILTIN\Administrators Read more →

How to return the character values based on ASCII character number values

I want to view the character values based on the ASCII character number values Read more →

How to check SSL encryption is enabled on SQL Server with Powershell

An easy way to find if SQL Server has SSL enabled Read more →

How to check Enforce a Password policy is enabled on SQL Server

How to check Enforce a Password policy is enable on SQL Server Read more →

Focus on OLDEST_PAGE as a factor that can delay LOG truncation

How do I fix the Oldest_page wait type desc Read more →