Speaking at SQL Saturday #136 – Wellington, New Zealand


On Saturday 14th April I’ll be speaking at SQL Saturday 136 in Wellington, New Zealand.

My presentation is titled “Extended Events – A whirlwind tour”  - I first gave the presentation at SQL Saturday 76 in Auckland back in January and again at Christchurch code camp  a little while later.

This will probably be the largest audience that I’ve given the presentation to and I’ve enhanced it a little since I last gave it.

The presentation is firmly based around  SQL SERVER 2008, and as SQL SERVER 2012 has just been released I pondered whether to upgrade the presentation also. In the end I decided to leave it with SQL SERVER 2008, as

  • The vast majority of people will be using the 2008 version.
  • The lack of a built in UI forces us to learn a scripting approach to XEvents – giving us a solid understanding of what’s going on.
  • I’ll be able to compare a few of the new features – such as the addition of a UI and lots more events.

The last twice that I have given this presentation, I asked the question “who currently uses XEvents” and I’ve been surprised at the small number of people who actually are using them.

Perhaps that’s due to the lack of built in UI – of course we could always use Jonathan Kehayias’s extended events add on.

Or maybe it’s due to the connection they have with XML.

Whatever the reason, I think gaining a strong understanding of the fundamentals of XEvents (even if you’re using the UI features in SQL SERVER 2012) will pay huge dividends.

The biggest reason I feel that people should learn about Extended Events are that.

  • They are extremely flexible.
  • Fully scriptable with DML.
  • Can be modified on the fly (meaning they don’t have to be stopped and restarted.)
  • Going forward they are going to take over from the deprecated SQL SERVER profiler

Right, time to check my flights to Wellington.

have a nice day.




About Martin Catherall

Martin Catherall is RockSolid SQL consultant, a SQL Server MVP and Regional Mentor (RM) for the Professional Association for SQL Server. Martin is an SQL SERVER Database Administrator in the Christchurch Area and has been active in the local IT community for over 10 years. He likes learning interesting stuff about databases and passing on his knowledge. In his spare time he likes to learn guitar and hang out with his two young sons Callum Glen and Robert Michael.