Author: Steve Stedman

Strategically Managing SQL Server Growth: Balancing Expansion and Costs As businesses flourish and evolve, the underlying data infrastructure must adapt accordingly. SQL Server, serving as a cornerstone for numerous organizations’ IT ecosystems, is no stranger to this evolution. While growth signifies success, it concurrently introduces increased complexity and, inherently, elevated costs. Through my extensive journey with SQL Server spanning decades, I have observed a common hurdle organizations encounter: managing the financial burden that accompanies the expansion of their SQL Server …

Managing SQL Server Growth Read more »

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Why a Misconfigured Resource Governor on SQL Server Can Have Bad Performance Impacts A misconfigured resource governor in SQL Server can have significant adverse impacts on performance for several reasons: Inefficient Resource Distribution: The resource governor is designed to manage SQL Server workloads by distributing server resources among different groups based on their needs. If it’s misconfigured, critical processes …

Resource Governor Configuration Read more »

Three Fantastic Ways to Master SQL Server Join Types Hey there, SQL enthusiasts and database professionals! It’s Steve Stedman from Stedman Solutions, LLC. Today, I’m excited to share with you three incredible ways to enhance your understanding of SQL Server join types. Whether you’re a beginner or looking to polish your skills, we’ve got something just for you! 1. Grab Your Free Join Types Poster First up, we’re offering a FREE downloadable poster that visually breaks down SQL join types. …

Three Fantastic Ways to Master SQL Server Join Types 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 might necessitate startup jobs. Security Risks: Elevated Permissions: Jobs running at startup might require higher permissions than regular operations, potentially …

SQL Server: Startup Jobs Security Risks Read more »

Understanding the Causes of SQL Server Performance Issues As a seasoned SQL Server expert and the owner of Stedman Solutions, LLC, I’ve encountered a myriad of reasons why a SQL Server database might be running slower than expected. In my experience, identifying and addressing the root cause of performance issues is crucial for maintaining an efficient and reliable database system. Here, I’ll share some common reasons for SQL Server sluggishness, drawing from my extensive background and the insights gained from …

Why is my SQL Server slow? Read more »