Extended Events - Top Features
2015TL; DR
Extended Events are replacing the old SQL Trace & Profiler, and there are many good reasons for that. In this session I want to demonstrate to you some of the best features and possibilities of this Tracing Framework.
Session Details
Extended Events are replacing the old SQL Trace & Profiler, and there are many good reasons for that. In this session I want to demonstrate to you some of the coolest features and possibilities of this Tracing Framework,
which is actually not so new anymore, having been introduced already in SQL Server 2008 and much earlier in Windows. If you want to find out how to trace in a flexible and lightweight way, do historical deadlock analysis for free, get a callstack without running a Debugger, and do advanced analysis directly inside the GUI together with some background information such as why actions are “actions” and not just simply “columns”, this session is just for you. You will never want to see Profiler again.
The SQL Deadlock Colletor & Parser is available here: https://sqldeadlockcollector.codeplex.com/
which is actually not so new anymore, having been introduced already in SQL Server 2008 and much earlier in Windows. If you want to find out how to trace in a flexible and lightweight way, do historical deadlock analysis for free, get a callstack without running a Debugger, and do advanced analysis directly inside the GUI together with some background information such as why actions are “actions” and not just simply “columns”, this session is just for you. You will never want to see Profiler again.
The SQL Deadlock Colletor & Parser is available here: https://sqldeadlockcollector.codeplex.com/
3 things you'll get out of this session
Speakers
Andreas Wolter's previous sessions
What’s new in SQL Server and Azure SQL Database Security
This session will focus on the new features and capabilities that help you meet compliance and security needs with SQL Server on-premises as well as in Azure SQL Database. This includes the new Static Data Masking, new authentication capabilities, new functionalities in Vulnerability Assessment and Threat Detection as well as Always Encrypted. If you want to know about the latest developments in SQL Security, this session is for you.
“SQL Attack…ed” - SQL Server under attack: SQL Injection
In this purely demo-based session, I will show several real-life attacks, from mere reading up to disrupting service availability via various types of manual and automated SQL Injection, including a broadly unknown elevation of privileges attack.