SQLBits 2012
Extended Events and the new Profiler in SQL Server 2012
Extended Events made its appearance in SQL Server 2008, but in SQL Server 2012, the number of lightweight events have been expanded. After a quick review of how Extended Events work, I’ll cover the enhancements in detail.
Extended Events made its appearance in SQL Server 2008, but in SQL Server 2012, the number of lightweight events have been expanded. All of the events and fields available in SQL Profiler are now available in Extended Events as well as a graphic user interface, covering more use cases and enabling new debugging opportunities. After a quick review of how Extended Events work, I’ll cover the enhancements in detail. In addition to more events, Extended Events also exposed in the 2012 SQL Server PowerShell provider and SMO, and I’ll show working with Extended Events in PowerShell.
Speakers
Bob Beauchemin's previous sessions
Extended Events and the new Profiler in SQL Server 2012
Extended Events made its appearance in SQL Server 2008, but in SQL Server 2012, the number of lightweight events have been expanded. After a quick review of how Extended Events work, I’ll cover the enhancements in detail.
Spatial Data “Stretches Out” in SQL Server 2012
The addition of spatial data to SQL Server 2008 is one of the most important in terms of integration in line-of-business applications. This talk will discuss the new features and performance enhancements in SQL Server 2012.