Today marks the release of SQL Sever 2022 by Microsoft. Coming in just about 45 days from the end of 2022. There are many new features in this release to better connect your on prem SQL Server with Azure. More details to come over the next few months as I explore all the features of SQL Server 2022. Here is …
Join us today for our first month of Database Health training! This tool has a lot to offer and this is a great way to master it! 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. …
The Getting Started with SQL Server course is great for people who have never used SQL Serve before and need a jump start to get SQL Server and the tools needed to run queries installed. This is the most basic SQL Server course intended for the beginner. Here is the direct link to the class using the coupon code, valid …
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 …