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 of as a temporary view or inline table-valued function. One of the primary advantages of using a common table expression …
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, and can be used to perform a wide range of operations, including ranking, aggregation, and ranking. One of the key …
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 the minimum and maximum values for the Price column. Here is how the query works: Want to learn more about …
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 a database is corrupted, the data it contains may be lost or inaccessible, which can be a major problem for …
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 best selling class and will teach you all the ways to connect tables using different types of JOINs. In this …
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 can give this course away and prevent just one ransomware course, it has bene worth it. In the last couple …
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 are late and miss that deal you can still get the course with an 80% discount until 11:00am pacific time, …
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 registered for the backup and recovery course in November, you just need to watch your email and in the next …
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 in the course also gets you access to our track blocking queries script, and training on how to use it. …
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 that you need to catch the queries that are clogging up your SQL server the most. This is more than …
Black Friday Promotion 25% Off Track Blocking Queries with Coaching Read more »