Common Table Expressions
A common table expression, also known as a CTE, is a temporary named result set in SQL that can be used within a SELECT, INSERT,… Read More »Common Table Expressions
Classes
Notes from SQL Server Classes
SQL Server Windowing Functions
SQL Server windowing functions are a powerful and versatile set of tools that allow you to perform complex calculations and operations on a set of… Read More »SQL Server Windowing Functions
Min and Max Aggregate Functions in TSQL
Here is a sample query using the MIN and MAX functions in T-SQL: This query selects the minimum and maximum values for the Price column… Read More »Min and Max Aggregate Functions in TSQL
New Course – Preparing for Corruption in SQL Server
Corruption in a SQL database is when the database becomes damaged or corrupted, making it unable to be used or accessed. This can happen for… Read More »New Course – Preparing for Corruption in SQL Server
50% off TSQL JOIN Types class
As the last day of November, today is the last day that I will be promoting specials for our SQL Server training courses. Today’s promotion… Read More »50% off TSQL JOIN Types class
Free Ransomware Course – Everyday Value
Around a year ago I put together this free Ransomware Awareness course. It is one of those things that I felt so strong about because… Read More »Free Ransomware Course – Everyday Value
Stedman SQL School – Cyber Monday Deal
Today’s amazing deal is the backup and recovery course. Being Cyber Monday, we have to get a bit crazy, and for crazy deals today we… Read More »Stedman SQL School – Cyber Monday Deal
Free Aggregating Course for anyone who purchased the backup and recovery course
For those who purchased the backup and recovery course during the first 28 days of November I have a deal for you. Absolutely free, not… Read More »Free Aggregating Course for anyone who purchased the backup and recovery course
Small Business Saturday Deal 50% off Track Blocking Queries with Email Alerts
The reason that I have chosen this deal for Small Business Saturday is that this blocking query script has made such a big difference for… Read More »Small Business Saturday Deal 50% off Track Blocking Queries with Email Alerts
Black Friday Promotion 25% Off Track Blocking Queries with Coaching
This promo is more than just a class, it also includes 2 hours of coaching by Steve Stedman. The track blocking queries script combined with… Read More »Black Friday Promotion 25% Off Track Blocking Queries with Coaching