August Promotion SQL Daily Checkup 6 months free with any new or renewing mentoring client. Sign up for a 4 or 8 hour mentoring package in August and receive 6 months of our daily checkup service for free. If you already are using our SQL Daily Checkup, we will extend your subscription by 6 months. Offer expires August 31. Hey …

Need some help? Introducing SQL Server Mentoring: Your Shortcut to Expert Guidance Read more »

Greetings, fellow SQL enthusiasts! Steve Stedman here, thrilled to introduce you to an invaluable resource that will revolutionize your SQL Server experience. At Stedman Solutions, we understand that sometimes a little guidance can go a long way, without the need for a long-term commitment. That’s why we’ve developed our SQL Server Mentoring service—a game-changing option designed to provide you with …

Unlock Your SQL Server Potential with Stedman Solutions’ Mentoring Service Read more »

Understanding SQL Server CPU Utilization When working with SQL Server, you might encounter situations where it seems not to utilize all available cores or is capped at a maximum of 50% CPU load. There are several reasons why this might happen. Here’s an in-depth look into common scenarios and settings that can lead to such behavior: This is just one …

Not Using All Cores Read more »

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding the Risks: User Tables in the Master Database and Disaster Recovery When it comes to managing SQL Server, the master database stands out as one of the most critical system databases. It holds essential system-level data, including server-wide …

User Tables in the Master Database and Disaster Recovery Read more »

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding and Mitigating Slow SQL Server Error Log Access Are you experiencing sluggishness when accessing your SQL Server error log? As a database professional and the owner of Stedman Solutions, LLC, I’ve encountered this issue multiple times and understand …

Understanding Slow SQL Server Error Log Access Read more »

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding the Impact of SQL Server AutoClose Setting on Performance The SQL Server AutoClose database setting, when enabled, can significantly impact the performance of your database. Below are key reasons why: 1. Resource Overhead When the AutoClose setting is …

SQL Server AutoClose Impact on Performance 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 …

Proactive Monitoring in a World of Constant Change Read more »

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Security Risks of SQL Server Agent Jobs at Startup Having SQL Server Agent jobs run at startup poses several security and operational risks. It’s important to understand the context and the specific requirements of certain components, like replication, which …

SQL Server: Startup Jobs Security Risks Read more »

High Virtual Log File count is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding and Resolving High Virtual Log File (VLF) Count in SQL Server Introduction In the world of SQL Server performance tuning, one often overlooked yet critical aspect is the management of Virtual Log Files (VLFs) …

Understanding and Resolving High Virtual Log File (VLF) Count Read more »