Month: March 2015

Introducing Stedman Solutions, LLC.

As of today, March 31st 2015, I am off on a new adventure in my life. As of today I am 100% focused on my new business. Here are the details. FOR IMMEDIATE RELEASE: Stedman Solutions, LLC. To Offer SQL

Tagged with: , , , , , , ,

TSQL Training: JOINs

Today’s training will be on JOINs.  Here is the outline for the training. —Basic SELECT —INNER JOIN —LEFT OUTER JOIN —RIGHT OUTER JOIN —LEFT OUTER JOIN with exclusion —RIGHT OUTER JOIN with exclusion —SEMI JOIN —ANTI SEMI JOIN —CROSS JOIN

Tagged with:

Using The TSQL EOMONTH Function

Here is a quick video training on how to use the T-SQL EOMONTH function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. The EOMONTH function returns the last day of a given

Tagged with: , , , , , ,

TSQL JOIN Types Poster (Version 3)

NOTE:: There is an updated version of the poster available now.   Version 4 is now available. So many times I have been asked for help with a query, where the question really comes down to the understanding of the difference

Tagged with: , , , ,

Using The TSQL DATEADD Function

Here is a quick video training on how to use the T-SQL DATEADD function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. And here is the sample code to go with the

Tagged with: , ,

Using The TSQL DATEDIFF Function

Here is a quick video training on how to use the T-SQL DATEDIFF function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. And here is the sample code to go with the

Tagged with: , ,

FULL OUTER JOIN vs CROSS JOIN

As I have been working on the SQL Server JOIN Types poster, I have received several questions around the difference between a CROSS JOIN, and a FULL OUTER JOIN. After looking at the Venn diagrams for the two, they are

Tagged with: , , , ,

Using The TSQL DATEPART Function

Here is a quick video training on how to use the T-SQL DATEPART function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. And here is the sample code to go with the

Tagged with: , ,

Using the TSQL GetDate Function

Here is a quick video tutorial on how to use the T-SQL GetDate function on SQL Server 2012, SQL Server 2014 or newer. This was originally part of my free SQL query training for the 70-461 certification exam. Here is the

Tagged with: , , , ,

Using the TSQL CASE Statement

Here is a quick video tutorial on how to use the T-SQL CASE function on SQL Server 2012, SQL Server 2014 0r newer. This was originally part of my free SQL query training for the 70-461 certification exam. Here is the

Tagged with: , , ,
Top