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 »

SQL Counters: Understanding sys.dm_os_performance_counters in SQL Server Monitoring SQL Server Performance is crucial for ensuring optimal operation. One essential tool for this is the Dynamic Management View (DMV) sys.dm_os_performance_counters. This DMV provides real-time performance data on various SQL Server components, such as memory, transactions, and locks. In this post, we’ll explore the key columns and how to use this DMV …

SQL Counters Read more »

The Five Most Popular Features of Database Health Monitor Deadlock Analysis: Automatically captures and analyzes deadlocks, providing clear insights to resolve these conflicts and prevent them from recurring. Wait Stats Monitoring: Quickly identifies performance bottlenecks by analyzing SQL Server Wait Statistics, helping you resolve issues before they impact users. Index Fragmentation Analysis: Detects Fragmented Indexes that can slow down your …

The Five Most Popular Features of Database Health Monitor Read more »