It’s 2 AM. Your phone is going off. Users can’t connect to the application, and when you open SSMS to…
Browsing: SQL
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks at how the proc works.Another post…
Your on-call phone rings at 2 AM. Application timeouts are climbing and someone is already asking for updates in the…
One of the popular features of Redgate Monitor has been the ability to add custom mertics for various purposes. This…
Thanks to everyone who joined the blog party this month. I noticed three themes in the responses. Every response had…
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster, deploy faster. But while we accelerate…
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB as the source) that I’ve managed…
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an example of why it can behave…
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards or optimisation scripts. Tools can highlight…
A query that ran in 200 milliseconds yesterday is taking 14 seconds today. The application team noticed before the monitoring…