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. This is script that runs as a SQL Server agent job and over time catches blocking and logs it to a table. With this it gives you the ability to go back …
60% off Track Blocking Queries with Email Alerts Read more »
Join us Wednesday November 16th from 4-5pm PST for our first month of Database Health training! If you wish to: Quickly understand the health of your database. To learn how to get the perfect report for your needs. To learn short cuts within Database Health Monitor to save time. Locate bottlenecks in your SQL Server. Find tables that are using …
There are only a couple days left on this weeks SQL Server class discounts. These both expire in the next couple days and will be replaced with different promotions for next week. First the Common Table Expressions class deal Here is the direct link to the class using the coupon code, valid through November 15. https://stedmans-sql-school.teachable.com/p/unleash-common-table-expression-in-sql-server?coupon_code=CTENOV Coupon Code CTENOV Then …
The Aggregating Your Data in SQL Server course is our newest course. This promotion marks the price down to just $3 from now until November 15th. You will learn about basic aggregation as well as aggregation with windowing using the over clause. You will gain a good understanding of how the group by works in a standard query and how …
Aggregating your data in SQL Server course for just $3. Read more »
Out of all of the customers we have running our daily monitoring here are the versions of SQL Server that are being run. All the data is sanitized, so there is no private client information to expose here. What is this service? With this service we detect and alert you of any issues that arise on your SQL Server. Then …
Daily Server Monitoring – SQL Versions for November Read more »
Learning Common Table Expressions is one of my favorite classes, with over 8 years of prep time for this course, including presentations at live conferences, writing a book on CTE’s and number online presentations. This course will cover most everything you would ever want to know about common table expressions. Have you ever wanted to create a recursive query but …
40% off Learning Common Table Expressions in SQL Server Read more »
There are only a couple days left on first SQL Server class discounts for November. These both expire in the next couple days and will be replaced with different promotions for next week. 40% off SQL Joins Type Class The JOINS Type class is one of our best selling classes. The standard price is $29.99 USD which is a great …
For just 2$ you can get my TSQL Output Clause class with coupon code OUTPUT2. The SQL Server output clause is a great way to get data back from an insert, update or delete statement, and it cause be used for auditing, or tracking of changes. It is also a great way to capture changes for a type of undo …
Only a couple weeks until our very first Database Health Monitor Training + Q&A. Space is limited to 100 participants each month so claim your spot soon! What will this training cover? Each month a different feature of Database Health Monitor will be highlighted. We will cover ways and short cuts to navigate through the system and how to monitor …
The JOINS Type class is one of our best selling classes. The standard price is $29.99 USD which is a great price even with no discount. But with the coupon code JOINSNOV, you will get 40% off, you can get the course for just $17.99 USD. An even better value. In this course, we will cover basic select, inner join, …