That per-second counter on your dashboard is probably a running total. Here is how to turn it into a real rate with two samples.
Finding Schedule Clashes: Overlapping Sessions per Attendee
An attendee says two sessions run at the same time. Here is how to find every overlapping pair once, and why touching is not a clash.
Query Store Interval Length: Choosing How Fine Your History Is
An hourly average can hide the slowdown users remember. Here is a small demo of Query Store interval length and how to choose it.
Will the Next Autogrowth Fit? Checking Growth Against Free Disk
The drive has free space, yet the file will not grow. Here is how to calculate the next autogrowth and test it against disk and MAXSIZE.
ZIP Codes Stored as int: Lost Zeros and How to Repair Them
An int column turns 01234 into 1234 and never gives the zero back. Here is how to fix the column, and how to repair old rows without guessing.
Scalar Subqueries: An Empty Input Produces NULL
Scalar subqueries contribute one value to an outer row. Keep row absence separate from a present NULL and enforce the at-most-one-row contract.
sp_execute_external_script: Run Python Inside SQL Server
Before you write any Python, check four switches. Here is how to read them, what error 39023 means, and what to test on your own server.