Author: SteveStedman

Performance tuning in SQL Server is essential for efficient database management. The Performance Tuning Course offered by Stedman’s SQL School is specifically designed to equip database professionals with the knowledge and tools necessary for optimizing SQL Server performance. It focuses on enhancing system efficiency and reducing licensing costs through performance tuning. The course, led by Steve Stedman, a SQL Server …

SQL School: Master SQL Server Performance Tuning 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 …

Elevating SQL Server Performance with Managed Services Read more »

As a database administrator, I know how important it is to have a reliable and efficient monitoring tool that can provide insights into the performance and health of a database. That’s why I created the Database Health Monitor, a powerful and user-friendly solution that helps you manage your database environment and improve its overall performance. The Database Health Monitor is …

Database Health: Insight Into Database Performance Read more »

Finding Peace of Mind with SQL Server Managed Services As the owner or manager of a business that relies on SQL Server for critical data management and operations, the thought of your SQL Server encountering issues during the off-hours can be a significant source of stress. The fear of waking up to a server crash, data loss, or performance issues …

Sleep Better With Managed Services From Stedman Solutions, LLC. Read more »

If you are reading this article becuase you are trying to repair your corruptin database, please reach out ot us at Stedman Solutions we can take a quick look and help determine your options for reparing the database. Contact us for a free 30 minute consultation. It is impossible to completely prevent corruption from happening. There are several best practices …

SQL Server Corruption: Can I Prevent Corruption Read more »

SQL Server instance level settings allow you to control various aspects of the behavior of your SQL Server instance. One such setting is the ability to force encryption for all connections to the instance. This is a security feature that ensures that all communication between the client and the server is encrypted, which helps protect against eavesdropping and man-in-the-middle attacks. …

Securing SQL Server: Force Encryption Setting 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. CXPACKET SP_SERVER_DIAGNOSTICS_SLEEP ASYNC_NETWORK_IO PREEMPTIVE_OS_PIPEOPS LCK_M_SCH_S PREEMPTIVE_OS_GETPROCADDRESS XE_LIVE_TARGET_TVF MEMORY_ALLOCATION_EXT LCK_M_IX CXCONSUMER Our daily monitoring product scans your SQL Server hourly and …

Common Waits Reported by Daily Monitoring This Month Read more »

Ensuring Peace of Mind for Your Database Management In the world of data-driven decision-making, the reliability, performance, and security of your SQL Server databases are paramount. For many organizations, however, managing and optimizing these databases can be a challenging and time-consuming task, often requiring specialized skills that may not be available in-house. This is where Stedman Solutions comes in, offering …

Stedman Solutions SQL Server Managed Services Read more »

The Challenges of Relying Solely on an In-House DBA: Insights from Stedman Solutions In the fast-paced world of IT, the database is the backbone of any organization, storing critical data that drives decision-making and operational efficiency. However, managing a database is no small feat, and many companies rely on a dedicated Database Administrator (DBA) to handle this crucial role. While …

The Challenges of Relying Solely on an In-House DBA Read more »

DBCC SHRINKDATABASE is a DBCC command in Microsoft SQL Server that can be used to reduce the size of a database by moving pages of data from the end of the file to the front, and then releasing the unused space at the end of the file. It can be useful for reclaiming space in a database that has grown …

SQL Server DBCC Commands: DBCC SHRINKDATABASE Read more »