Notes from SQL Server Classes
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, …
It is that time of the year again, November, the month where we have the lowest prices on our SQL Server courses, and where we have weekly promotions, finally wrapping up with our Thanksgiving, Black Friday and Cyber Monday Sales at the end of the month. As Stedman Solutions we treat the whole month of November as a sale month …
Just 6 days from now our November promotion at Stedman SQL School begins. For the entire month of November, we will be offering some of the biggest discounts on our SQL courses ever. My goal is to offer prices so low that we get more people learning SQL skills via our SQL School. Some of the deals that we will …
The countdown begins to November savings at Stedman SQL School Read more »
Today I am pleased to announce that we have a new course available at Stedman SQL School. This is our second class in the SQL Short series, which is a set of short but focused courses to help improve your SQL query skill in specific areas. The Aggregating Data in Your SQL Server course is a detailed course on how …
I have just completed a course in our SQL Queries series called TSQL Output Clause. This is a short course, priced at a value for just $5.00. Course Title Using the TSQL Output Clause Course Details The SQL Server output clause is a great way to get data back from an insert, update or delete statement, and it cause be …
Current SQL Server course coupon codes and on going deals you can only get from Stedman Solutions! 25% Off in July! Coupon Code: DATABASEHEALTH Learn how to monitor your wait statistics, you blocking queries, and to find out the best ways to improve performance with what you learn. With this course you will also receive 20 Database Health Monitor server …
SQL Server Blocking queries are one of those things that can really bog down your database. You might have plenty of memory, and way more CPU than you need, but a single blocking query may bring your server to a halt. Over the last several years at Stedman Solutions we have done lots of performance tuning assessments, and when we …
Current SQL Server course coupon codes and on going deals you can only get from Stedman Solutions! 25% Off in July! Coupon Code: DATABASEHEALTH Learn how to monitor your wait statistics, you blocking queries, and to find out the best ways to improve performance with what you learn. With this course you will also receive 20 Database Health Monitor server …
25% Off Database Health Monitor Course in July! Coupon Code: DATABASEHEALTH Learn how to monitor your wait statistics, you blocking queries, and to find out the best ways to improve performance with what you learn. With this course you will also receive 20 Database Health Monitor server connection points (20 server connections) that are good for 1 year. Unlock the …
Transcription of Video: Let’s take a look at another recursive CTE. That’s not looking at tables, but it’s just looking at math. And here, we could create a recursive function that’s called sum of parts, and select from the sum of parts. Basically, we’re creating a function that selects from itself. And what it does is it says give me …