SQL server

The SQL Server error log holds the evidence for your last outage. Here is how to read archives, group the noise, and spot 825 and… Read More »Reading the SQL Server Error Log Before It Reads You

ReportServer database size rarely grows from report definitions. See which tables, in the catalog and its temp database, actually reserve the space.

What is in master often surprises the team that has to rebuild it: credentials, triggers, and startup procedures nobody documented.

Most SQL Server maintenance window schedules are typed in once and never checked. Here is how to measure the quiet hours instead of guessing at… Read More »Your SQL Server Maintenance Window Is a Guess. Measure It

A management data warehouse can stop updating while its Agent jobs still show green. Here’s where SQL Server keeps the real failure text.

SQL Server index fragmentation percentage can be misleading. Here is the number that actually predicts what a rebuild will buy you, and where to find… Read More »SQL Server Index Fragmentation: Stop Chasing the Percent

See reserved versus used space for every table in your database, and find exactly which one is wasting space you could reclaim today.

See SQL Server table size ranked across every table, spot which ones dominate the database, and know before a restore or migration bites.

See your SQL Server blocking history as an hour-by-day heat map, so a recurring problem shows up as a pattern instead of a guess.