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 »

Hello to all SQL Server programmers and DBAs, I am Steve Stedman, over the years, I’ve come to recognize the value and power of SQL Server’s Common Table Expressions (CTEs). To share my knowledge and assist others in mastering this tool, I’ve have crated a course named “Unleash the Power of Common Table Expressions in SQL Server” available at my …

SQL School: Unlocking The Power of Common Table Expressions With My Class Read more »

Today Microsoft released a new update for SQL Server. SQL Server 2022 CU6 for 2022 (16.0.4055.4 – July 2023) 2023-07-13 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM Download links: SP3 (10.50.6000.34 – September 2014) SP2 (10.50.4000.0 – July 2012)None   SQL Server 2022 RTM Download links: NoneCU6 for 2022 (16.0.4055.4 – July 2023)   …

New SQL Update from Microsoft 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 FREESESSIONCACHE is a database console command (DBCC) in Microsoft SQL Server that can be used to clear the session cache, which is a region of memory used by the database engine to store objects such as temporary tables and table variables that are specific to a user session. Clearing the session cache can be useful for troubleshooting performance issues …

SQL Server DBCC Commands: DBCC FREESESSIONCACHE 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 »

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 »

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 »

As the founder and owner of Stedman Solutions, LLC, I know how important it is to address the challenges you face when it comes to your DBA or developer’s absence or the overwhelming workload on your in-house resources. That’s why our team at Stedman Solutions is here to provide you with reliable solutions. Find out more about our SQL Server …

Staff Augmentation – We can help Read more »