A small innodb_buffer_pool_size contributed to one customer slow MySQL query. The comparable SQL Server workload ran quickly.
Recovery Model Changes and the Log Backup Chain
Explain the log backup chain across FULL and SIMPLE changes, inspect recovery LSNs and backup history, and establish a new backup boundary.
Status Changes Only: Collapsing Repeated Rows With LAG
Hundreds of repeated readings, three real changes. Here is how LAG finds them, and why a plain not-equal test quietly drops rows.
max_column_id_used: How Many Columns a Table Once Had
The max_column_id_used column shows how many columns a table ever had. See it grow, find tables that lost columns, and avoid treating column_id as a position.
Query Progress: Watching a Running Plan With dm_exec_query_profiles
Elapsed time cannot tell you if a query is almost done. Live operator rows can. See how to read them and how far to trust the percentage.
UPDATEUSAGE and Space: What It Fixes and What It Does Not
UPDATEUSAGE and space are two jobs: the command corrects page and row counts but frees no space. See a test where it finds nothing and a rebuild shrinks the table.
Experience – My Very First YouTube Live
My very first YouTube Live started with a microphone problem. Here is my honest look at what went well, what I must improve, and the topics we covered.