By combining the raw power of the Extended Events engine in SQL Server with the Blocked Process Report, we are able to achieve real value in blocking monitoring.
Blocked Process Report: How to Get More Value
Stability and Reporting – Love at First Sight
Stability and reporting go hand in hand. You cannot truly have stability without reporting. Take the time to share the stability successes with the business. Let them revel in the successes you have brought to the enterprise data footprint.
Tech Debt – Free Yourself from the Precipice
No matter how you name it, “hairball”, “spaghetti code”, “tech debt” or “DIY code”, the result is the same – you are dealing with legacy code that nobody wants to update or maintain.
3 Important Queries for Testing Your Availability Group Endpoints
In this article, I have shown the importance of performing three different validation tests against your Availability Group Endpoints. Each test also demonstrates what can be run in the event the validation test fails.
3 Highly Improved Help Queries for XEvents in Azure SQL
XEvents is here to stay and is a powerful tool for ALL of your SQL implementations – whether they be Azure SQL or the traditional on-premises SQL Server.