Steve Stedman

At DatabaseHealth.com, we understand that monitoring the performance of your SQL Server is critical to ensuring that your databases are running smoothly. Poor performance can impact productivity, lead to lost revenue, and ultimately harm your business. In this article, I’ll discuss how Database Health Monitor can help you optimize the performance of your SQL Server. Identify Performance Issues Database Health …

Improve Performance of your SQL Server with Database Health Monitor Read more »

The SQL ROUNDUP Options Rounding numbers is a common task in SQL Server, and understanding how to round up specifically can be crucial for various applications, such as financial calculations or setting minimum thresholds. In this blog post, we’ll explore different methods to round up numbers in T-SQL. The CEILING Function The simplest and most direct way to round up …

Rounding Up in TSQL Read more »

NOLOCK Hint in SQL Queries: Myths, Misconceptions, and Best Practices In the world of SQL Server, the NOLOCK hint often generates spirited debates among database professionals. This hint is frequently used but equally misunderstood. In this blog post, we’ll explore what the NOLOCK hint does, dispel some common myths and misconceptions, and provide best practices for its use. Understanding the …

NOLOCK Hint in SQL Queries Read more »

As a database professional, I know first-hand the challenges that come with monitoring and maintaining a database. It can be time-consuming, complex, and, if not done properly, it can lead to costly downtime and lost business opportunities. That’s why I created Database Health Monitor – a powerful tool designed to make database monitoring and optimization easier and more effective. With …

Database Health Monitor Read more »

DBCC CHECKCONSTRAINTS is a database console command (DBCC) in Microsoft SQL Server that can be used to display information about the CHECKCONSTRAINTS on a table or view in a database. CHECKCONSTRAINTS are used to enforce data integrity in a database by limiting the data that can be inserted or updated in a table. To use DBCC CHECKCONSTRAINTS, you must specify …

SQL Server DBCC Commands: DBCC CHECKCONSTRAINTS Read more »

Welcome to our Backup and Recovery Course! In today’s digital age, data is the lifeline of any business. Ensuring its safety and availability is paramount. Our comprehensive Backup and Recovery Course is designed to equip you with the essential skills and knowledge to safeguard your data effectively. What You’ll Learn: Understanding the importance of data backup and recovery. Different types …

Backup and Recovery Course Read more »

With over 12 years of development into Database Health Monitor, there are many features there for many difference scenarios from performance to security, to overall server health. I created the Database Health Monitor course to help people get the most value out of using the product, and with the purchase of that course you also get licensing for up to …

Database Health Monitor with Coaching Read more »

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. …

Removing Leading Zeros in SQL Server Read more »

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 …

New SQL Update from Microsoft Read more »