Upcoming Livestream EventJoin Steve Stedman as he discusses how to prepare for your DBA’s vacation effectively. This webcast will cover strategies for ensuring system stability when your single DBA is away, offering insights from both the DBA and employer perspectives. From the DBA’s viewpoint: “Despite thorough preparation, I often receive calls for regular maintenance issues while on vacation, disrupting my plans and …
Achieve Peace of Mind with SQL Server Managed Services from Stedman Solutions In today’s fast-paced business world, managing SQL Server environments can be a significant challenge. For IT managers and business owners, the peace of mind that comes from knowing your SQL Server infrastructure is secure, optimized, and running smoothly is invaluable. At Stedman Solutions, we understand these concerns and …
Peace of Mind with SQL Server Managed Services from Stedman Solutions Read more »
Each month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there is no private client information to expose here. For this month, here are the details. PREEMPTIVE_OS_PIPEOPS SP_SERVER_DIAGNOSTICS_SLEEP CXPACKET MEMORY_ALLOCATION_EXT ASYNC_NETWORK_IO LCK_M_S LCK_M_IX LCK_M_SCH_S LCK_M_IS CXCONSUMER Our daily monitoring product scans your SQL Server hourly and …
Common Waits Reported by Daily Monitoring This Month Read more »
The Evolving Role of Database Administrators: From Junior to Senior In the world of database administration, the journey from a Junior Database Administrator (DBA) to a Senior DBA is marked not just by years of experience but by a depth of understanding and a trail of resolved challenges. This path is crucial not only for personal career growth but also …
Introduction: In my years of working with SQL Server, I’ve encountered a variety of common mistakes that can impact performance and database health. In this blog post, I’ll share these pitfalls and provide tips on how to avoid them. Remember, understanding these mistakes is the first step in enhancing your SQL Server’s Performance. Ignoring Database NormalizationNormalization is crucial for reducing …
Common SQL Server Mistakes and How To Avoid Them Read more »
Elevating SQL Server Performance with Managed Services from Stedman Solutions In the realm of database management, SQL Server stands out for its robustness, scalability, and wide range of features catering to various business needs. However, like any sophisticated technology, it requires expert handling to fully harness its potential and ensure peak performance. That’s where managed services from Stedman Solutions, LLC …
Here is a video that I created on Indexing for Performance, some of the techniques that I use when doing performance tuning: Steve StedmanFounder/Owner — Stedman Solutions, LLC.SQL Server DBA Services Looking to schedule a meeting with me? Here is my availability: https://Stedman.us/schedule
We are thrilled to extend a special invitation to you for an exclusive, free informational 30-minute session on SQL Server maintenance for IT Managers and Leaders! This event will take place on Wednesday May 22, 2024 at 10:30 am Pacific Time. We will be covering: And just how Stedman Solutions LLC can assist you today. This is an exclusive event, only allowing …
Introduction to SQL Server maintenance for IT Managers and Leaders Read more »
Today Microsoft released a new update for SQL Server. SQL Server 2022 CU13 for 2022 (16.0.4125.3 – May 2024) CU12 + GDR (16.0.4120.1 – April 2024) 2024-05-16 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM Download links: SP3 (10.50.6000.34 – September 2014) SP2 (10.50.4000.0 – July 2012)None SQL Server 2022 RTM Download links: NoneCU13 …
Monitoring backups is an essential part of database administration, as it ensures that you have reliable and up-to-date backups in case of data loss or corruption. The Database Health Monitor for SQL Server provides insights into backup status, enabling you to identify potential issues and take corrective action to ensure that your backups are running smoothly. The Database Health Monitor …
Database Health: Monitoring Backups with Database Health Monitor Read more »