Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.
Default SQL Server auto-growth settings cause VLF fragmentation and autogrowth wait events. This script analyses every database and generates the correct ALTER DATABASE statements automatically.
Read article →Microsoft released then quickly pulled Cumulative Update 7 for SQL Server 2019 after a critical defect surfaced. Here is what was fixed, what went wrong, and what it means for your patching process.
Read article →SQL Server 2019 CU5 delivers critical fixes including a database corruption bug and scalar UDF inlining issues, but incomplete KB documentation means you should assess carefully before deploying.
Read article →Recompile all stored procedures in a SQL Server database with a single script. Refresh stale execution plans after schema or statistics changes without dropping any objects.
Read article →Learn how to query SQL Server index fragmentation using DMV views and identify which indexes need rebuilding or reorganising to restore query performance.
Read article →Stop updating maintenance plans every time a database is added or dropped. This stored procedure dynamically discovers and backs up all user databases with compression enabled.
Read article →Running with SQL Server's default autogrowth settings is quietly hurting your performance. Learn how to bulk-update file growth settings across all databases using a single T-SQL script.
Read article →A bloated MSDB database can cause maintenance jobs to fail and monitoring alerts to fire. Learn how to identify the cause and fix it safely.
Read article →Most SQL Server problems build quietly over months before anything breaks. Find out what regular maintenance covers and why your environment needs it.
Read article →Performance tips, security advisories, and industry analysis. No fluff, no spam.