1 DBA's Professional Blog
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.
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.
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.
These are a few simple queries to help you along your way to becoming better acquainted w/ XEvents in Azure SQL. These queries will make XEvents easier for you!
SSCM likes to disappear from time to time. When it does, what is your backup plan? This article shows how not to be fooled by the vanishing act of SSCM.
Linked Servers can certainly provide an enigma to your finely tuned Database environment. In this article, I share how to decrypt that enigma via XEvents.
Application timeouts can be surprising little problems causing grey hairs. Never fear, this article with the XEvents session I shared are the perfect solution.
XEvents is a power tool in SQL Server. While it may still be rather immature in the world of SSAS, it still has a great deal of benefit and power to offer.
This article has demonstrated a meaningful and efficient method to test and validate the necessary firewall ports for Availability Groups (AG) and WFC.
Explore an easy method to create a table of all unicode (and emoji) characters to store within your database environment. This easy solution can save you a significant amount of time as you become more familiar with the world of code points and special characters.