In addition to its customizable dashboard, intelligent alerting system, and powerful reporting capabilities, the Database Health Monitor also provides valuable insights into wait statistics and blocking queries. Wait statistics are a crucial component of database performance monitoring, as they provide …
Database Health: Wait Statistics and Blocking Queries Read more »
Join Steve Stedman for an exclusive online presentation on SQL Server replication techniques on April 24th at 10:30 AM Pacific Time. This special session will delve into the fundamentals of Transactional Replication, Merge Replication, and Snapshot Replication, providing attendees with …
Exclusive SQL Server Replication Training Session Read more »
Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in SQL Server. Whether you’re a seasoned SQL …
Hey there, fellow SQL enthusiasts! I’m Steve Stedman, and I’m excited to share my SQL Server course on the TSQL Output Clause. If you’re like me and passionate about mastering SQL Server, then you’re in for a treat! This course …
SQL School: Master the TSQL Output Clause with My SQL Server Course Read more »
In the last year I have seen far too much ransomware. I have seen some people lose their databases with no way of getting them back, and I have seen others who have been able to get everything. Some have …
Grab a blanket and get comfortable. It’s story time with Steve Stedman and Derrick Bovenkamp! In this 10 min video they will share with you database corruption stories. From these stories hopefully you’ll learn what not to do. Things to …
Welcome to April at Stedman Solutions, LLC! This month, we’re excited to announce that April is JOINS month, where all our promotions and activities will revolve around the fundamental concept of JOINs in SQL Server. Whether you’re a seasoned SQL …
Demystifying SQL Server Join Types: A Guide to Mastery Read more »
Understanding Merge Replication in SQL Server In the world of data management, ensuring that information is up-to-date and accessible across different locations is crucial for businesses to function efficiently. This is where the concept of merge replication comes into play, …
At Stedman Solutions we have done many corruption repairs since 2015. When I talk about corruption, most of this information comes from real world scenarios that actually happened at different businesses that we were part of recovering… or not part …
Today Microsoft released a new update for SQL Server. SQL Server 2019 CU26 for 2019 (15.0.4365.2 – April 2024) CU25 + GDR (15.0.4360.2 – April 2024) 2024-04-11 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM …