Exclusive SQL Performance Tuning Training
Steve and the team at Stedman Solutions, LLC have put together an email based performance tuning course where each week you can get tips and… Read More »Exclusive SQL Performance Tuning Training
SteveStedman
Unlocking SQL Server HierarchyID Performance: Is Your Tree Structure Dragging You Down?
If you're managing organizational charts, file systems, category trees, or any hierarchical data in SQL Server, you've probably run into the hierarchyid data type. It's… Read More »Unlocking SQL Server HierarchyID Performance: Is Your Tree Structure Dragging You Down?
Overview of our Classes at Stedman SQL School
Welcome to Stedman SQL School, where we are passionate about empowering individuals with the skills to master database management and SQL programming. Our institution is… Read More »Overview of our Classes at Stedman SQL School
Silent Merge Replication Failures: When "Green" Doesn't Mean "Synced"
You check your Replication Monitor. Everything's green. The latency looks good, the transaction count is normal, and there's not a single error message in sight.… Read More »Silent Merge Replication Failures: When "Green" Doesn't Mean "Synced"
Corruption Stories with Steve and Derrick
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… Read More »Corruption Stories with Steve and Derrick
SQL Server 2025 Max Degree of Parallelism: Why DOP Feedback Changes Everything (And What to Do About It)
Let me ask you something: how many hours have you spent trying to find the “perfect” MAXDOP setting for your SQL Server environment? If you’re… Read More »SQL Server 2025 Max Degree of Parallelism: Why DOP Feedback Changes Everything (And What to Do About It)
SQL Server 2025 Upgrade Checklist: 7 Breaking Changes DBAs Need to Know (Before It's Too Late)
SQL Server 2025 is here, and if you’re a DBA or IT manager planning an upgrade, you need to know this: Microsoft didn’t just add… Read More »SQL Server 2025 Upgrade Checklist: 7 Breaking Changes DBAs Need to Know (Before It's Too Late)
Shrinking Databases – Pros, Cons and Recommendations
Shrinking databases is a topic that often sparks debate among database administrators and developers. On one hand, reducing the size of a database can free… Read More »Shrinking Databases – Pros, Cons and Recommendations
February: The Month of Performance at Stedman Solutions!
February: The Month of Performance at Stedman Solutions! February is here, and at Stedman Solutions, LLC, we’re declaring it Performance Month! As a seasoned expert… Read More »February: The Month of Performance at Stedman Solutions!
Why Choosing Stedman Solutions is a Cost-Effective Alternative to Hiring a Full-Time DBA
Introduction In the digital age, effectively managing your SQL Server has never been more critical. You might think that employing a full-time Database Administrator (DBA)… Read More »Why Choosing Stedman Solutions is a Cost-Effective Alternative to Hiring a Full-Time DBA