Have you seen the Stedman SQL School – The Everything SQL Server Bundle. Curated with both budding enthusiasts and seasoned professionals in mind, this comprehensive… Read More »Introducing the Everything SQL Server Bundle
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.… Read More »Mastering the TSQL Output Clause: Exclusive Offer
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… Read More »Grab My Favorite SQL Joins Course at a Special Discount!
Hey there! Guess what? It’s that time of the year again – good ol’ November, when I go a bit crazy and slash the prices… Read More »November’s the Time for Crazy SQL Deals!
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… Read More »New SQL Update from Microsoft
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… Read More »SQL Server Corruption: Stories About Causes of Corruption
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… Read More »SQL Counters
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… Read More »The Five Most Popular Features of Database Health Monitor
The other day I was asked how to use SQL with an IF Statement, so here is my blog post to cover that question. Using… Read More »SQL With IF Statement
Understanding the Difference Between LEFT OUTER JOIN and RIGHT OUTER JOIN in SQL Server When working with SQL Server, one of the fundamental concepts is… Read More »LEFT OUTER JOIN and RIGHT OUTER JOIN