Read KILL WITH STATUSONLY rollback estimates, confirm the target session, avoid repeated kills, and account for accelerated recovery.
Activity Monitor Keeps Freezing: Fix WMI and Permissions
When Activity Monitor keeps freezing, the cause can be a missing SQL permission or a missing WMI permission for the Windows account. This post tests the SQL side on SQL Server 2025, walks through the WMI security fix and explains what CIMV2 means. It also gives a query that reads the same activity without Activity Monitor.
SQL SERVER – SQL_NO_CACHE and OPTION RECOMPILE Target Different Caches
OPTION (RECOMPILE) and SQL_NO_CACHE concern different cached objects. A banking customer using MySQL and SQL Server prompted my comparison.
Schema Discovery for JSON Columns: Listing Every Key With OPENJSON
Use schema discovery on JSON columns to count keys and types, inspect nested objects, and find missing required paths with guarded input.
Twenty Practice Queries on One Small Schema
Work through twenty practice queries on one small sales schema, with expected results for filters, joins, totals, windows, and gaps.
SQL SERVER – Fix: Configuration Manager- Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable
Let us learn how to solve Configuration Manager – Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable.
Disable Query Store on an Always On Database: What Blocks It
To disable Query Store on an Always On database, run ALTER DATABASE with QUERY_STORE = OFF, and try OFF (FORCED) when the statement waits. This post shows the states to read, the background commands that block the statement and the steps used on an Always On database. It marks which parts were tested on a single server and which come from a client case.