Latest SQL Server Blog Posts
- August Promotion Mentoring includes Free Daily Monitoring
For the month of August we are running a promotion. When you purchase a 4 or 8 hour mentoring block with Stedman Solutions, you will receive 6 months of our Daily Monitoring product for free. The monitoring is over a $600 value. As an IT professional working on SQL projects, you may occasionally find yourself… Read More »August Promotion Mentoring includes Free Daily Monitoring - SQL Code Smells: Non-Parameterized Queries
Your SQL Server is running hot. CPU is elevated, the plan cache is bloated, and queries that should be instant are taking seconds. You look at the query text and everything seems reasonable. The problem is not what the queries are doing. It is how they are being sent. Non-parameterized queries are one of the… Read More »SQL Code Smells: Non-Parameterized Queries - 5 Things Every Junior DBA Should Know Stedman SQL Podcast Sn 3 Ep 12
Stedman SQL Podcast Sn 3 Ep 13 5 Things Every Junior DBA Should Know In this episode, Mitchell Glasscock and George Stedman discuss the situations they have been faced with starting as Junior DBA’s and gaining knowledge and tips over the years. They explain the top 5 tips and tricks to make sure you don’t… Read More »5 Things Every Junior DBA Should Know Stedman SQL Podcast Sn 3 Ep 12 - Table Use Report in Database Health
July is Database Health Monitor Month! July has arrived, and it’s time to turn our attention to the heartbeat of our digital world – our databases! As the founder of Database Health and Stedman Solutions, I’m thrilled to proclaim this month as Database Health Monitor Month! This is our annual chance to celebrate the unsung… Read More »Table Use Report in Database Health - The Feature That Prevents 2 AM Calls: How Database Health Monitor Forecasts Disk Capacity Problems Weeks in Advance
Disk space exhaustion is one of the most preventable SQL Server emergencies in existence. Unlike hardware failures or unexpected query plan changes, disk space issues develop on a predictable trajectory. Databases grow. Log files accumulate. The available space decreases at a rate that is measurable, trackable, and extrapolatable into the future. There is no reason… Read More »The Feature That Prevents 2 AM Calls: How Database Health Monitor Forecasts Disk Capacity Problems Weeks in Advance