Transaction log backups on a schedule can miss a burst of activity that fills the disk. This post builds a procedure that reads the log written since the last backup and takes a log backup once it passes a limit you choose. It also explains why the old habit of shrinking the log after each backup does harm.
SQL SERVER – SharePoint not Working After Failover to Another Node
After a SQL Server cluster failover, SharePoint users could not open any page, though all SQL resources were online. Here is what we found and how we fixed it.
How to Force a Parallel Execution Plan for a Query? – Interview Question of the Week #170
A customer asked how to force a Parallel Execution Plan for a query. Here are two methods, including QUERYTRACEON 8649, with a simple example.
SQL SERVER – Be Careful with Logon Triggers – Don’t use Host_Name
A reader used HOST_NAME() in a logon trigger to limit access. Here is why that is risky, and why Logon Triggers can lock everyone out if you are not careful.
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.