Free space today cannot tell you when the drive fills up. Save daily file sizes and let a short query turn the growth into a date.
Parquet Exports From SQL Server 2022 With CETAS
Build Parquet exports from SQL Server 2022 with PolyBase CETAS, S3-compatible storage, and checks for rows, types, and files.
SQL SERVER – Timeout Occurred While Waiting for Latch: Class FGCB_ADD_REMOVE
Latch FGCB_ADD_REMOVE timeouts mean a data file is growing slowly. Measured on SQL Server 2025: 4 GB of data in 98 ms, 4 GB of log in 2.3 seconds.
How to Move SQL Server MDF and LDF Files? – Interview Question of the Week #189
How do you move SQL Server MDF and LDF files? Detach and attach is the old way, so here is the step-by-step method I use for my clients today.
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.
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.