The speaker lineup for PASS SUMMIT 2015 was announced today and my Advanced Common Table Expressions session was accepted.
Here is the abstract:
You might have been introduced to Common Table Expressions (CTEs) and understand the WITH syntax, but want to know more. Learn how recursive queries work with CTEs and how to display hierarchical data. Did you know that you can INSERT, UPDATE, and DELETE data from CTEs? This session covers some common use cases for CTEs, including finding holes in patterns, finding and removing duplicate data, string parsing, and more. Get an in-depth understanding of the performance behind a CTE and learn when a CTE is the right (or wrong) solution. Finally, take a look at some classic recursive algorithms and how they can be implemented with CTEs.
Earlier this year I created my Epic Life Goals list (level 1) which included speaking at PASS Summit. It looks like I will be able to check that one off in October.
Here is a link to the speaker line-up check it out, there are some great speakers listed there. http://www.sqlpass.org/summit/2015/Sessions/Speakers.aspx
If you are going to PASS Summit then I will see you in October.