The following SQL Freebies are available from Stedman Solutions, LLC.
Free SQL Server Health Check Checklist
A one-page, 25-point checklist to find SQL Server downtime, performance and corruption risks in about 15 minutes.
Get it free
Common Table Expressions Book
Over 250 pages on T-SQL and Common Table Expressions, with sample code, as a free PDF.
Get it free
SQL Server Whitepapers
Free whitepapers on maintaining, securing and tuning SQL Server, and what management really costs.
Get it free
T-SQL JOIN Types Poster
A visual poster that shows exactly what each T-SQL JOIN type does, so you stop mixing up LEFT and RIGHT.
Get it free
MySQL JOIN Types Poster
The same JOIN poster for MySQL, where some ways of completing a join are slightly different.
Get it free
Ransomware Awareness Course
Prepare your SQL Server for a ransomware attack before it is not if, but when.
Get it free
Weekly Performance Tuning Tips
A short weekly email tip to make your SQL queries run faster and boost SQL Server performance.
Get it free
SQL Server Newsletter
Weekly tips, free downloads, whitepapers and special offers delivered to your inbox.
Get it free
Free Video Training
Free SQL Server video training on Steve Stedman’s YouTube channel.
Get it freeRelated Content:
In this course you will first gain an understanding of the differences between each of these types of joins and when they should be used. Then we’ll explore some common uses for joins, such as replacing a not in clause with join to get the same results with better performance. You will take home the right foundations to get at the data that you want.
You will learn to use CTE’s for recursive queries, as temporary views, and to use the result set multiple times in the same query. Learn how simplify query syntax using CTE’s.
One of the most overlooked features of SQL Server is the CTE which not only simplifies the query, but gives you the ability to do things that would otherwise be impossible (or at least very challenging) with SQL Server.
Need help?
Contact us today for your free 30 minute consult to find out how Stedman Solutions can help with your SQL Server needs.