TSQL INNER JOIN
>>> Try our JOIN Types Course Today! The INNER JOIN has to be the most common JOIN type in SQL Server. This is where we… Read More »TSQL INNER JOIN
SQL Server
SQL Server Join Types Poster (Version 2)
Try our JOIN types course today! So many times I have been asked for help with a query, where the question really comes down to… Read More »SQL Server Join Types Poster (Version 2)
Epic Life Quest Level 1 – partially completed today.
After being inspired by reading about Brent Ozar’s Epic Life Quest, I created my own Epic Life Quest list, and for level 1 one of… Read More »Epic Life Quest Level 1 – partially completed today.
Simple Introduction to TSQL Cursors
A cursor is a tool in SQL Server that allows a user to traverse through the rows of a result set one row at a… Read More »Simple Introduction to TSQL Cursors
SQL Server Join Types Poster
This has been replaced with a new updated version of the poster. Click here to visit the new page. >>> Try our JOIN types course… Read More »SQL Server Join Types Poster
T-SQL: A Listing Databases Example Using a Cursor
In SQL Server the cursor is a tool that is used to iterate over a result set, or to loop through each row of a… Read More »T-SQL: A Listing Databases Example Using a Cursor
Announcing the new Bellingham SQL Server Users Group (PASS Chapter)
Aaron Buma and I, with help from the Professional Association for SQL Server (PASS) have formed an official PASS chapter called the Bellingham SQL Server… Read More »Announcing the new Bellingham SQL Server Users Group (PASS Chapter)
Next Weekly Free SQL Training: A Review
We are currently about 25% of the way through the SQL Server 70-461 exam preparation class, which has been available through Google On Air Broadcasts… Read More »Next Weekly Free SQL Training: A Review
Using a Common Table Expression Instead of a Derived Table
Here is a short video that shows how to convert those ugly derived table (SubQuery) queries into a common table expression to help clean up… Read More »Using a Common Table Expression Instead of a Derived Table
What is a Common Table Expression
I just a added a video to YouTube titled “What is a Common Table Expression”. This video covers the extreme basics of what a CTE… Read More »What is a Common Table Expression