![[Video] Office Hours, Standing in the Ocean Edition](https://allblogs.blob.core.windows.net/alldevblogs/thumbs/article-d4626251b58f-full-d0df0a7f.webp)
A Q&A video covering SQL Server topics like stats maintenance, XE, certifications, upgrades, and database management.
A guide to implementing fine-grained permissions for SQL Server Extended Events to enforce the Principle of Least Privilege with role separation examples.
A guide to converting SQL Server Profiler templates to Extended Events (XEvents) sessions using the SSMS GUI for performance monitoring.
Explores the heuristics and conditions under which SQL Server's Query Optimizer decides to use Batch Mode execution for query processing.
A guide to using Extended Events (XEvents) for advanced tracing and diagnostics in Azure SQL Database, covering setup and specific use cases.
A database professional's travelogue of speaking at SQL Server and tech conferences across Asia, Europe, and America in late 2015.
A technical guide on using SQL Server Extended Events to capture, import, and parse deadlock graphs for analysis and troubleshooting.
Overview of new Extended Events packages and features introduced in SQL Server 2014, focusing on the In-Memory OLTP (XTP) engine.
Announcement and agenda for a full-day SQL Server performance analysis and tuning PreCon workshop at SQLSaturday Istanbul.
Benchmarks comparing the CPU performance overhead of SQL Server Extended Events vs. SQL Trace under high CPU load.
Compares file sizes between SQL Server Extended Events and deprecated SQL Trace, finding XML format adds ~29% overhead.
A technical guide on using SQL Server Extended Events for tracing and monitoring Analysis Services (SSAS) performance, replacing SQL Profiler.
