A Password Protected SSIS Package Can Stall a Migration
A password protected SSIS package can stall a migration for days. Here is how to find every one hiding inside msdb first.
SteveStedman
Why Your Management Data Warehouse Stopped Updating
A management data warehouse can stop updating while its Agent jobs still show green. Here’s where SQL Server keeps the real failure text.
What a SQL Server Index Health Score Really Tells You
SQL Server index health is more than a fragmentation percentage: one score with its reasons, backed by ten indexing reports rolled into cards.
SQL Server Index Fragmentation: Stop Chasing the Percent
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
SQL Server LOB Columns in Indexes Are Costing You Disk
SQL Server LOB columns in indexes duplicate data on disk. Here’s how to find every one, measure the cost, and know which are safe to… Read More »SQL Server LOB Columns in Indexes Are Costing You Disk
Backup and recovery for SQL Server
As a database professional, you know how critical it is to have a solid backup and recovery plan in place for your SQL Server environment.… Read More »Backup and recovery for SQL Server
What SQL Server Suspect Pages Are Trying to Tell You
SQL Server suspect pages sit quietly in msdb until a disk finally fails. Learn what each event means and how to tell damage from a… Read More »What SQL Server Suspect Pages Are Trying to Tell You
SQL Server Scalar UDF Inlining: Free Speed You’re Missing
SQL Server scalar UDF inlining can erase a function’s cost entirely, or it can silently never fire. Here is how to see which is true… Read More »SQL Server Scalar UDF Inlining: Free Speed You’re Missing
Happy Labor Day
In observance of the US federal holiday Labor Day, Stedman Solutions, LLC will be closed for the first Monday in September. As the founder of… Read More »Happy Labor Day
How to Find Local SQL Server Instances Without Guessing
See how Database Health Monitor can find local SQL Server instances automatically, so you are not guessing a name during an incident.