Steve Stedman

Celebrating World Backup Day with Stedman’s SQL School: Unlock the Secrets of Efficient Backup and Recovery As we mark World Backup Day on March 31st, it’s a timely reminder of the critical importance of data backups in our increasingly digital world. In the realm of database management, particularly with SQL Server, the significance of having a reliable backup and recovery …

Celebrating World Backup Day with Stedman’s SQL School Read more »

In SQL Server, the DBCC CHECKDB command is a critical tool for ensuring the integrity of your databases. It performs checks on the logical and physical integrity of all the objects in the specified database. Using DBCC CHECKDB with different options can tailor the scope and performance impact of these integrity checks. DBCC CHECKDB with No Options Running DBCC CHECKDB …

DBCC CHECKDB Options Explained Read more »

Embrace Efficiency and Growth: The Integrated Power of Managed Services In today’s fast-evolving business landscape, organizations are constantly seeking ways to optimize their operations, scale efficiently, and ensure the robust management of their critical IT infrastructure. Stedman Solutions offers a suite of Managed Services designed to address these core needs, emphasizing the essential role of expert database administration in achieving …

Embrace Efficiency and Growth: The Integrated Power of Managed Services Read more »

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 »