When working with data in SQL Server, there may be times when you need to remove leading zeros from a string. This task can be particularly common when dealing with numerical data stored as strings, such as ZIP codes, product codes, or other formatted numbers. In this blog post, we’ll explore several methods to remove leading zeros in 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-07-10 Here are the latest updates for each …
Here is a 25% off coupon code for the Database Health Monitor Course wich includes licenses for 20 SQL Server connections. The code is only good this month: Code: July25 Here are the details on a couple of reports that I uses regularly in Database Health Monitor. The databases by size report is a quick and easy way to see …
Database Health Monitor – Database Size and Database IO reports Read more »
Understanding SQL Server Compatibility Levels In the world of SQL Server, compatibility levels play a crucial role in ensuring that your database applications run smoothly even after upgrading to a newer version of SQL Server. By understanding and managing these compatibility levels, you can avoid potential issues and leverage new features while maintaining stability and performance. What is a Compatibility …
When it comes to managing databases, every second counts. The health of your database can mean the difference between a smoothly running operation and countless hours spent troubleshooting performance issues. The ability to closely monitor, diagnose, and optimize your databases is crucial in maintaining an efficient, productive environment. And that’s exactly where Database Health Monitor by Stedman Solutions comes in. …
Unlocking Database Performance: Database Health Monitor by Stedman Solutions Read more »
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 …
Monitoring is another important preventative measure that can help ensure the ongoing health and performance of a SQL Server. Administrators should monitor various performance metrics such as CPU usage, memory usage, disk usage, and network traffic to identify performance bottlenecks and potential issues. Monitoring can also help detect and resolve issues related to query performance, execution plans, and blocking sessions. …
It would not be right to have Database Health Monitor month and not mention our offering of branded gear which includes socks. Yes I did say socks. These are seriously the best socks to wear on the golf course, or to your next sporting event. Get your Socks today We also have socks to remind you how to do joins, …
In the realm of SQL Server, the NOLOCK hint is a frequently discussed and often misunderstood topic. Many developers and database administrators resort to using NOLOCK in their queries to improve performance, without fully understanding its implications. This live stream, hosted by Steve Stedman, aims to demystify NOLOCK, addressing common myths and misconceptions, while providing clear guidance on when and …
Hey there! Steve Stedman here, founder of Database Health Monitor, and I’ve got something exciting to share with you. If you’re tired of dealing with slow database performance and unexpected downtime, then you’re in the right place. Let me introduce you to our game-changing class that will transform the way you manage and monitor your databases. Here is the deal:Use …