TSQL Basics Part 2: Inner Join – Video Explanation
This is part 2 “inner JOIN” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each… Read More »TSQL Basics Part 2: Inner Join – Video Explanation
This is part 2 “inner JOIN” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each… Read More »TSQL Basics Part 2: Inner Join – Video Explanation
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… Read More »2018 PASS Summit Community Speakers Announced
After someone reported a small bug in the “two INNER JOINs” diagram, I have created an update to the poster. This is update 4.1, only… Read More »TSQL JOIN Types Poster (version 21.5)
I am attending and speaking at SQL Saturday Redmond today. My presentation is at 2:45pm and on SQL JOIN Types, and the following topics will… Read More »SQL Saturday Redmond
So many times I have been asked for help with a query, where the question really comes down to the understanding of the difference between… Read More »TSQL JOIN Types Poster (Version 4)
Yesterday I blogged about submitting to SQL Saturday Denver, which is about 5 months away, after writing that post, I realized that I haven’t even blogged about SQL Saturday Redmond which is occurring in just over 2 weeks.
SQL Saturday #393 Redmond marks just 3 years since my first time speaking at a SQL Saturday #108 in Redmond. So lets take a look back, at Feb 5th, 2012, it was my first time presenting at a SQL Saturday ever, I had discovered this cool new query tool called the Common Table Expression, and I prepared my presentation. I practiced my presentation once before Saturday, and I was ready. Did I mention, that this was also my first time every attending a PASS event, or a SQL Saturday, and I was presenting. I was in the morning time slot after the keynote, and boy was I nervous. Over the next year I presented at I few other SQL Saturdays, and finally a book publisher, Joes 2 Pros noticed my presentation and asked me if I wanted to turn it into a book. In 2012 and 2013, I turned it into a book, which was released the same day as SQL Saturday #212 Redmond, where I again was selected to present on Common Table Expressions, this time I had books to give away as a prize.
Today I had the opportunity to present at LinuxFest Northwest on MySQL Join Types, using the MySQL JOIN Types poster in the presentation. It was… Read More »MySQL JOIN Types for LinuxFest Northwest
NOTE:: There is an updated version of the poster available now. Version 4 is now available. So many times I have been asked… Read More »TSQL JOIN Types Poster (Version 3)
>>> Try our online JOIN Types Course Today! As I have been working on the SQL Server JOIN Types poster, I have received several questions… Read More »FULL OUTER JOIN vs CROSS JOIN