The SQL Server Managed Services offered by Stedman Solutions, LLC is an alternative to hiring a full time DBA, or to help your existing DBA that may be overloaded. Watch this video by Steve Stedman to find out more. Find out more about our SQL Server Managed Services from Stedman Solutions. Schedule a time to discuss how Stedman Solutions can …
Managed Services: an alternative to hiring a DBA Read more »
When writing SQL queries, it’s easy to focus on getting the right results without thinking too much about performance. One common mistake that can lead to significant slowdowns is using functions in the JOIN ON clause of a SELECT statement. While SQL Server supports a wide range of built-in functions, using them incorrectly—especially in the join conditions—can severely impact performance. …
How Functions in the JOIN ON Clause Can Slow Down Your SQL Queries Read more »
Monitoring backups is an essential part of database administration, as it ensures that you have reliable and up-to-date backups in case of data loss or corruption. The Database Health Monitor for SQL Server provides insights into backup status, enabling you to identify potential issues and take corrective action to ensure that your backups are running smoothly. The Database Health Monitor …
Database Health: Monitoring Backups with Database Health Monitor Read more »
Over the years I have documented many of the concepts around corruption repair. Want to find out more, check out the corruption category at by blog. Transcribed from a presentation on Database Corruption by Steve Stedman and Derrick Bovenkamp. Steve : Now, one of the things that when we talk about drive failures and that there is a big difference …
SQL Server Corruption: Corruption vs Drive Failure Read more »
In the dynamic world of databases, ensuring optimal performance and robustness is crucial. Yet, many businesses often sideline database assessments, unaware of the untapped potential they can unlock. At Stedman Solutions, we emphasize the importance of our SQL Server Health Assessment. Why? Because the overall health of your SQL Server can drastically impact your business operations, especially when it comes …
Why Every Business Needs Stedman Solutions’ SQL Server Health Assessment Read more »
Understanding SQL Server Wait Types that Cause More Blocking In SQL Server, wait types can tell you a lot about what’s slowing down your system, but some wait types can actually contribute to or even cause blocking. Blocking occurs when one process holds a lock on a resource that another process needs, and that second process must wait until the …
With over 30 years of hands-on SQL Server experience, I have personally curated my favorite performance tuning tips and techniques into this exclusive training series. Having worked with SQL Server since its early days, I’ve seen it all—the good, the bad, and the slow. Now, I’m excited to share some of the most effective solutions I’ve developed over the years …
Why Database Health Monitor is the Best Tool for Monitoring SQL Server Performance In the world of SQL Server management, performance monitoring isn’t just a best practice—it’s a necessity. The right tools can be the difference between a smooth-running system and one plagued by bottlenecks, slowdowns, or even crashes. Enter Database Health Monitor: a tool designed specifically with SQL Server …
Today Microsoft released a new update for SQL Server. SQL Server 2016 CU17 + GDR for SP2 (13.0.5893.48 – June 2022) CU17 for 2016 SP2 (13.0.5888.11 – March 2021) CU15 + GDR for SP1 (13.0.4604.0 – July 2019) CU15 for SP1 (13.0.4574.0 – May 2019) CU9 for RTM (13.0.2216.0 – November 2017) 2024-10-08 Here are the latest updates for each …
For the month of October you will receive a free year of our SQL Server Daily Monitoring with the purchase of a SQL Server Assessment. The month of October is about more than just spooky decorations and pumpkin spice lattes—it’s about making sure your SQL Server environment is running at its peak! This October, Stedman Solutions is offering a deal …