Shrinking a database can seem like a helpful way to save space and resources, particularly if a database has grown substantially over time. However, SQL Server’s default maintenance plans that include database shrinking can lead to several performance issues. Here’s …
Database Health Quickscan – Default maintenance plans to shrink database – Ouch Read more »
Welcome to July – a month that signifies a shift in focus to the unseen heroes of our digital infrastructure – our databases. As the founder of Database Health and Stedman Solutions, it is with great pleasure that I announce …
One of the fundamental aspects of working with SQL Server is understanding how to get the number of rows affected by a query. Whether you’re working with SELECT, INSERT, UPDATE, or DELETE statements, knowing the row count can provide critical …
Exploring Example SQL Databases in SQL Server SQL Server is a robust relational database management system that offers a variety of features for data management, analysis, and reporting. One of the great resources for learning and testing SQL Server capabilities …
July is here and that means it’s time for us to pivot our collective gaze to the pulse of our digital lifeblood – our databases! As the founder of Database Health and Stedman Solutions, I am excited to declare this …
Sneak preview – July is Database Health Monitor Month Read more »
Over the years developing Database Health Monitor I have added a number of keyboard shortcuts to make life easier when working in the application. Some of these are listed here to share since they are not all completely obvious. Backspace …
Parameter Sniffing and Conditional Logic in SQL Server Stored Procedures: A Performance Pitfall Parameter sniffing is a well-known feature in SQL Server that can significantly impact query performance. While it often leads to optimized query execution, it can sometimes cause …
Parameter Sniffing and Conditional Logic in SQL Server Stored Procedures Read more »
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 …
Boost SQL Server Performance with Stedman Solutions Monitoring Tools In the world of database management, maintaining optimal SQL Server performance is paramount. For businesses relying on SQL Server, ensuring high performance, availability, and reliability can be challenging. This is where …
Boost SQL Server Performance with Stedman Solutions Monitoring Tools Read more »
Video on Transactional Replication Watch it directly on YouTube. https://youtu.be/69H3KAvit7I Transactional replication is a robust and essential feature for organizations that need to maintain accurate and consistent data across various locations. While it comes with its challenges, the benefits of …