This script to update the default extended events session for ADS Profiler will make for a safer and more bandwidth-friendly query capture experience for Azure SQL Database.
Aaron Bertrand starts a series explaining how he evaluated the default trace and decided to replace it with a slimmer Extended Events session across all of production.
Erin Stellato (@erinstellato) of SQLskills shows how to use Extended Events to monitor for query plans with certain characteristics, such as joins missing predicates, columns missing statistics, and unmatched filtered indexes.
For T-SQL Tuesday #67, Aaron Bertrand (@AaronBertrand) describes a new way to track backup and restore operations using Extended Events in SQL Server 2016.
Aaron Bertrand (@AaronBertrand) takes a quick look at a couple of things you should be careful about when calling natively-compiled Hekaton stored procedures in SQL Server 2014.
Jonathan Kehayias (@SQLPoolBoy) of SQLskills discusses predicates in Extended Events, and demonstrates why you need to list state-related predicates last.
