Measure faster backups by changing BUFFERCOUNT, MAXTRANSFERSIZE, and backup stripes one at a time while tracking speed and memory.
SQL SERVER – FIX: Error: 5511 – FILESTREAM’s file system log record under log folder is corrupted
Error 5511 says the FILESTREAM file system log record under the log folder is corrupted. Here is how I got the database back online.
What is SQL Server Launchpad Service? – Interview Question of the Week #168
What is the SQL Server Launchpad Service? I had to look it up myself. Here is the short answer: it launches the Advanced Analytics Extensions processes.
Find Deprecated SQL Server Features with Extended Events
To find deprecated SQL Server features, capture the deprecation announcement and deprecation final support events with Extended Events. This post builds a small session, runs four kinds of deprecated code, reads the captured features and statements, and lists the replacements to use before a compatibility level change or an upgrade.
SQL SERVER – FIX: Arithmetic Overflow Error in Object Execution Statistics Report in Management Studio
The SSMS Object Execution Statistics report suddenly failed for a client with Msg 8115, arithmetic overflow converting to int. Here is why and what to do.
SQL SERVER – AlwaysOn Automatic Seeding Failure – Failure_code 15 and Failure_message: VDI Client Failed
One database would not seed to the secondary replica. Here is how sys.dm_hadr_physical_seeding_stats showed failure_code 15 and VDI Client Failed.
How to Estimate Space Saved by Data Compression in SQL Server? – Interview Question of the Week #167
How to estimate space saved by data compression in SQL Server? Use the built-in sp_estimate_data_compression_savings procedure. Here is a quick example.