All day Workshops (with breaks)
Upcoming schedule for where you can catch these presentations.
Murder They Wrote!
- SQL Injection
- Row-by-Row / Iteration / Cursors
- Some of the many ways that Views can be abused
- Functions: which ones you should use for better performance, and why.
- Inherent design flaws of table variables that can lead to performance issues
- Assumptions in the use, or lack therein, of an ORDER BY clause
- The effects of SARG-ability on query performance and the Cardinality Estimator
- Data Types and the effects on storage, performance, and maintenance operations
- Explore some performance implications when using various methods in lieu of a Join
- Various tools can also have an impact on Database performance and we will explore that too!
- And much much more
A Masters Passport to Extended Events
by Jason Brimhall and Wayne Sheffield
As is commonly the case, all good things come to an end. And now is as good a time as any for the use of SQL Trace and Profiler to come to an end. Let’s face it, Trace was a good tool and had some wonderful uses. Profiler for that matter was a good tool and was useful at times. It is time to let those old tools retire gracefully and move into the world of XE. This full day workshop will provide you with the means to let Profiler and Trace be retired from your toolset as you discover all that XE has to offer.
This full day session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties. This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact. You will be exposed to advanced troubleshooting techniques as we work through complex issues that are made easier through the use of XE. Take advantage of this opportunity to dive into the world of Extended Events and learn how you can make best use of this tool in your SQL 2008+ environment.