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 »

Hey everyone! I’m thrilled to share something special. For those looking to truly master SQL Server’s aggregation and window functions, I’ve stumbled upon an amazing course that’s being offered at an insane discount. Right now, the course is available for just $3 (yes, you read that right!) until November 15th. The course covers everything from the basics of data aggregation, …

Aggregation: A Special Course Offer Read more »

Hey there, SQL developers and DBA’s I’ve always been captivated by Common Table Expressions (CTEs) in SQL Server. There’s something about streamlining complex queries and making them more readable that I find incredibly satisfying. Over the past 9 years, I’ve explored deep into CTEs—presenting at conferences, writing a book, and even hosting a few online sessions. And now, I’m thrilled …

Discovering the Magic of CTEs in SQL Server Read more »

Posted on: 11/5/2023 at SteveStedman.com Hey folks! Time’s flying and there are only a few days left to grab the special discounts on my SQL Server classes for November. If you’ve been contemplating, now’s your chance before these offers wrap up. 1. SQL Joins Type Class at a Whopping 40% Off Usually priced at $29.99 USD, the JOINS Type class …

Week 1 Class Discounts: Almost Gone! Read more »

Have you seen the Stedman SQL School – The Everything SQL Server Bundle. Curated with both budding enthusiasts and seasoned professionals in mind, this comprehensive package is set to revolutionize your SQL Server learning journey. What’s Inside the Bundle? Whether you’re preparing for a crucial interview, fortifying your system against potential pitfalls, or honing your technical acumen, this bundle has …

Introducing the Everything SQL Server Bundle Read more »

Welcome, today I am thrilled to present a unique opportunity to deep dive into one of SQL Server’s most underappreciated features: the TSQL Output Clause. For a limited time, and for just $2 with the coupon code OUTPUT2, you can explore its immense potential. Why Every DBA and Database Developer Should Understand the Output Clause: The SQL Server output clause …

Mastering the TSQL Output Clause: Exclusive Offer Read more »

Hey dear readers! I’ve always raved about the SQL Joins mastery class. It’s one of those resources I genuinely love. The regular price stands at $29.99 USD which, to be honest, is already a steal. But guess what? With the magic code JOINSNOV, you can snag it at 40% off, bringing it down to just $17.99 USD. Here’s What’s Inside: …

Grab My Favorite SQL Joins Course at a Special Discount! Read more »

Today Microsoft released a new update for SQL Server. SQL Server 2019 CU29 for 2019 (15.0.4405.4 – October 2024) CU28 + GDR (15.0.4395.2 – October 2024) 2024-10-31 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM Download links: SP3 (10.50.6000.34 – September 2014) SP2 (10.50.4000.0 – July 2012)None   SQL Server 2022 RTM Download links: NoneCU15 …

New SQL Update from Microsoft Read more »

The integrity of a Microsoft SQL Server database can be severely undermined by corruption, leading to data inaccessibility and potential operational disasters. Steve Stedman’s comprehensive approach to identifying and rectifying such corruption is often considered an essential tool in the SQL Server administrator’s kit, underlining its significance in maintaining database health. These stories come from a recording of a presentation …

SQL Server Corruption: Stories About Causes of Corruption Read more »