Author: Steve Stedman

SQL Server Assessment: The Importance of Monitoring TempDB Growth As a seasoned expert in SQL Server since 1990, specializing in Performance Tuning, I’ve seen firsthand how unchecked TempDB growth can wreak havoc on SQL Server Performance. Monitoring TempDB growth isn’t just a best practice—it’s essential. That’s why it’s one of the 150+ standard checks we perform at Stedman Solutions during our comprehensive SQL Server assessments. Why Monitoring TempDB Growth Matters TempDB is a system database that SQL Server relies on …

Performance Assessment: Monitoring TempDB Growth Read more »

Here is a short video with an overview of SchemaDrift and how to get started comparing SQL Server Databases. The latest update of Database Health Monitor includes SchemaDrift for comparing databases. Steve Stedman here to talk about SchemaDrift and how we can use SchemaDrift to go and compare database schemas and find differences in your database. SchemaDrift is a program created by Stedman Solutions. This is something we’ve had internally in beta for a couple of years, and we’ve been …

Introduction to SchemaDrift Read more »

Ensuring Data Security with Stedman Solutions SQL Server Managed Services: Solid Backups and Restores In today’s data-driven world, the integrity and availability of data are paramount. For businesses relying on SQL Server for their critical data storage and management, ensuring solid backups and reliable restores is not just an option, it’s a necessity. This is where Stedman Solutions’ SQL Server Managed Services shine, offering comprehensive coverage to protect your data with robust backup and restore strategies. The Pillars of Data …

Solid Backups and Restores Read more »

The Power of Proactive Monitoring in a World of Constant Change As the world continually evolves, the need for robust and proactive solutions in the realm of IT managed services becomes ever more critical. In an environment where a single change can have cascading effects, businesses cannot afford to be reactive. This is where Stedman Solutions steps in with its cutting-edge managed services offering, featuring the daily checkup monitor – a tool designed to catch changes as they occur, ensuring …

Proactive Monitoring in a World of Constant Change Read more »

In the world of database management, maintaining optimal performance is an ongoing challenge. One crucial aspect that often gets overlooked is the management of indexes. While indexes can significantly enhance query performance, having too many of them can lead to issues when it comes to inserts, updates, and deletes. In this blog post, we’ll explore the delicate balance of index management and discuss strategies to identify and remove unnecessary indexes without compromising system stability. The Dilemma of Too Many Indexes …

Dangers of Removing Indexes Read more »