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, UPDATE, or DELETE statement. It is defined using the WITH keyword, and can be thought …
Notes from SQL Server Classes
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, UPDATE, or DELETE statement. It is defined using the WITH keyword, and can be thought …
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 rows within a query. These functions operate on a set of rows, called a window, …
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 from the Products table. The results of the query will be a single row containing …
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 a number of reasons, such as hardware failure, software bugs, or even human error. When …
New Course – Preparing for Corruption in SQL Server Read more »
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 is 50% off the SQL Server JOIN Types class. The JOIN Types class is our …
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 I had seen so many small (and large) business being impacted by ransomware. If I …
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 have first 90% off the backup and recovery class until 8:00am pacific time. If you …
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 strings attached is the aggregation course to say thank you for your purchase. If you …
Free Aggregating Course for anyone who purchased the backup and recovery course Read more »
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 so many of our small business customers. This is more than just a course, enrollment …
Small Business Saturday Deal 50% off Track Blocking Queries with Email Alerts Read more »
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 2 hours of coaching is a great way to get a grasp on the monitoring …
Black Friday Promotion 25% Off Track Blocking Queries with Coaching Read more »