Today was the announcement of the 2018 PASS Summit Community Speakers, and I am fortunate enough to have been included on that list for the 4th year in a row. This conference will be in Seattle in November.
Here is the session that was accepted.
Steve Stedman75 minutesDesignApplication DevelopmentDBA, Database Developer, Developer100Joining tables is one of the fundamental aspects of any relational database, but the different ways of joining tables are often misunderstood. Learn about INNER JOINS, OUTER JOINS (LEFT, RIGHT and FULL), OUTER JOIN with exclusions, CROSS JOIN. Also find out how multiple INNER JOINS impact your result set versus multiple OUTER JOINS. CROSS APPLY and OUTER APPLY behave much like a JOIN; learn how to quickly understand APPLY and how it can be conceptualized as a JOIN. By the end of this presentation you will at a minimum be able to answer that common question “explain the difference between an INNER JOIN and an OUTER JOIN”. You will also be ready to write better queries with your more complete understanding to JOIN types.
This session is one of my favorite beginner presentations in that it is a lot of fun to help get rid of some of the confusion around JOINs.
Time to buy a new laptop. Why you might ask? Well last year I had some trouble with getting my current laptop to connect to the presentation screens. I even practiced ahead of time and confirmed that all the connections worked. During my frustration last year with this issue I said that if I am selected as a speaker again next year, I will bring 2 laptops to help avoid this issue.
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!