Author: SteveStedman

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 …

Junior to Senior Database Administrators Read more »

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 …

SQL Server Performance with Managed Services Read more »

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

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 …

New SQL Update from Microsoft Read more »

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 »

Database corruption in Microsoft SQL Server can result in critical data loss, disrupting business workflows. The meticulous process of identifying and repairing such corruption often involves implementing methodologies such as those devised by Steve Stedman, a recognized authority in the SQL Server community known for his expertise in corruption repair. These stories come from a recording of a presentation by …

SQL Server Corruption: Stories About Causes of Corruption Read more »

Transparent Data Encryption (TDE) is a feature of Microsoft SQL Server that enables the encryption of a databases data and log files, as well as the encryption of backups, to protect sensitive data from unauthorized access. TDE encrypts the data at the page level, meaning that the data is encrypted as it is written to the disk and decrypted when …

Securing SQL Server: Transparent Data Encryption Read more »