Steve Stedman

The importance of robust data backup and recovery systems cannot be overstated in today’s digital age. Imagine losing years of valuable SQL Server data due to a minor glitch, hardware failure, or worse, a cyber-attack. The nightmare becomes even graver for businesses where data forms the cornerstone of their operations. If you’re concerned about SQL Server data backup and recovery, …

Secure Your SQL Server Data with Our Comprehensive Backup and Recovery Course Read more »

Out of all of the customers we have running our daily monitoring here are the versions of SQL Server that are being run. All the data is sanitized, so there is no private client information to expose here. What is this service? With this service we detect and alert you of any issues that arise on your SQL Server. Then …

Daily Server Monitoring – SQL Versions for September Read more »

In the fast-paced digital world we live in, data is everything. Whether you’re a seasoned DBA or a junior developer, understanding how to properly backup and restore SQL Server databases is essential for protecting this invaluable asset. To those searching for the most comprehensive and easy-to-understand training, look no further. Stedman’s SQL School has created an outstanding course on SQL …

Why SQL Server Backup and Recovery Skills are a Must-Have and How to Master Them Read more »

Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database. When a client application requests data from the database, the request is placed in a queue and the client application must wait for its turn to access the data. The time that the query spends …

SQL Server Wait Type: RESERVED_MEMORY_ALLOCATION_EXT Read more »

Microsoft SQL Server’s database corruption can lead to severe operational complications, making crucial data inaccessible and potentially jeopardizing business continuity. Comprehending this problem requires a firm grasp of corruption indicators, its root causes, and effective strategies for prevention and repair. The frequency with which you should run the DBCC CHECKDB command on your SQL Server database depends on several factors, …

SQL Server Corruption: How Often Should I Run CheckDB Read more »

The Perils of Neglecting Regular SQL Server Database Backups  Wed, 30 Aug 2023 Discover the risks of NOT backing up your SQL Server database and learn how to avoid the unwanted consequences. Even the most sophisticated system can fail, and when it does, the consequences can be severe. This is why regular databas Read more… Common Waits Reported by Daily …

August Blog Post Wrap-up 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 ASYNC_NETWORK_IO CXPACKET CXCONSUMER LCK_M_IS MEMORY_ALLOCATION_EXT OLEDB XE_LIVE_TARGET_TVF PREEMPTIVE_OS_GETPROCADDRESS TRACEWRITE Our daily monitoring product scans your SQL Server hourly and …

Common Waits Reported by Daily Monitoring This Month Read more »

August Promotion SQL Daily Checkup 6 months free with any new or renewing mentoring client. Sign up for a 4 or 8 hour mentoring package in August and receive 6 months of our daily checkup service for free. If you already are using our SQL Daily Checkup, we will extend your subscription by 6 months. Offer expires August 31. Greetings, …

Special Offer: Get a Complimentary SQL Daily Checkup with Stedman Solutions’ Mentoring Service in August! Read more »

August Promotion SQL Daily Checkup 6 months free with any new or renewing mentoring client. Sign up for a 4 or 8 hour mentoring package in August and receive 6 months of our daily checkup service for free. If you already are using our SQL Daily Checkup, we will extend your subscription by 6 months. Offer expires August 31. Hey …

Exciting Offer: Get a FREE SQL Daily Checkup with Stedman Solutions’ Mentoring Service in August! Read more »