SSMS 18.5 fixed the Database Properties scrollbar that opened in the middle. Read the funny true story, see the original evidence, and enjoy the fix.
SQL SERVER – Multiple Log Files to Your Databases – Not Needed
I was asked a very interesting question by their DBA about log files. The question was – Is there ever need of multiple log files in SQL Server?
KILL WITH STATUSONLY: How Long Will This Rollback Take?
Read KILL WITH STATUSONLY rollback estimates, confirm the target session, avoid repeated kills, and account for accelerated recovery.
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.
Configuration Manager WMI Error: Cannot Connect to WMI Provider
A Configuration Manager WMI error blocks SQL Server Configuration Manager with the message that it cannot connect to the WMI provider. This is a second way to fix it, using mofcomp with the file for your SQL Server version. If mofcomp does not succeed, my earlier post has more steps.