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!
Top 3 Easy Help Queries for XEvents in Azure SQL
Tag: SQL Internals
Powerful Monitoring for Your Linked Servers with XEvents
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.
Easy Monitoring: Application Timeouts in SQL Server with 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.
Your Quick Introduction to Extended Events in Analysis Services
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.
Firewall Ports You Need to Open for Availability Groups
This article has demonstrated a meaningful and efficient method to test and validate the necessary firewall ports for Availability Groups (AG) and WFC.
How to Easily Grant Permissions to all Databases
This article demonstrates one method to grant READ access to all DBs while still keeping the environment secure & hitting that chord of doing it efficiently.
Time to Set Service Dependencies for SQL Server, it’s Easy
In this article, I share one easy script that could help eliminate one database feature as a culprit to an anomalous data masking suddenly getting enabled.
Here is an Easy Fix for SQL Service Startup Issues When Using an MSA
Running into startup issues with your services could be a nightmare on some days. Couple those issues with an MSA and you may be balding before long.
Simple Method to Add A Network in SQL Configuration Manager
In this article I have demonstrated a fairly simple method to help you modify your network adapters that are presented to SQL Server.
Decoded Statistics Names and More
Auto-generated statistics names can seem like they are entirely random, but there is a method to the madness. With a little effort and a bit of TSQL trickery, we can decode those names and reveal what the names really mean.