Steve Stedman

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 CXPACKET LCK_M_U LCK_M_IS MEMORY_ALLOCATION_EXT LCK_M_X CXCONSUMER SP_SERVER_DIAGNOSTICS_SLEEP ASYNC_NETWORK_IO OLEDB Our daily monitoring product scans your SQL Server hourly and …

Common Waits Reported by Daily Monitoring This Month Read more »

In the era of big data, even a small hiccup like a system glitch, hardware failure, or a cyber-attack could lead to a disaster if you’re not prepared. This is particularly true for businesses that rely on SQL Server data and have limited in-house database expertise. Our SQL Server Backup and Recovery Course is tailored to help accidental DBAs and …

Navigating Emergency Backup and Restore Situations: A SQL Server Course for the Accidental DBA Read more »

In the wise words of Benjamin Franklin, “If You Fail to Plan, You Are Planning to Fail.” This timeless adage holds particular relevance when it comes to safeguarding your SQL Server databases. A failure to adequately prepare for data loss scenarios—be it due to hardware malfunctions, data corruption, or increasingly prevalent ransomware attacks—can have devastating consequences for your business. The …

The Importance of SQL Server Backup and Recovery: Learn from Experts Read more »

Do You Think Your SQL Server Backups are Adequate? Think Again. In the age of data-driven decisions and a rapidly evolving digital landscape, the importance of comprehensive and secure data backups cannot be overstated. If you’re nodding your head, thinking, “Oh yes, of course, I have SQL Server backups,” you may want to pause and reconsider. Are your backup strategies …

Unlock the Power of SQL Server Backup and Recovery: Secure Your Data Like a Pro Read more »

Why DBAs Should Take Our Backup and Recovery Course: A Comprehensive Guide to Fundamentals and Ransomware Protection with Cloud-Based Backups Take advantage of this 25% discount on my Backup and Recovery Course for SQL Server and learn how to implement a comprehensive backup and recovery strategy for your organization. Head over to http://SteveStedman.com/backup to learn more and enroll in the …

Why DBAs Should Take Our Backup and Recovery Course Read more »

In the last year I have seen far too much ransomware. I have seen some people lose their databases with no way of getting them back, and I have seen others who have been able to get everything. Some have paid the ransom, and some have not. Even some who have paid the ransom did not got their data back. …

Fighting back against Ransomware Read more »

Today Microsoft released a new update for SQL Server. SQL Server 2022 CU8 for 2022 (16.0.4075.1 – September 2023) 2023-09-14 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: NoneCU8 for 2022 (16.0.4075.1 – September 2023)   …

New SQL Update from Microsoft Read more »

In today’s digital landscape, an effective disaster recovery plan focused on data backup and restore is non-negotiable. Imagine the impact of losing crucial SQL Server data due to a glitch, hardware failure, or cyber-attack. For businesses where data is at the core of operations, the stakes are sky-high. Stedman’s SQL Server Backup and Recovery Course is designed to give you …

Equip Yourself for Disaster Recovery with Our SQL Server Backup and Restore Course Read more »

In our digital world, data crises are not a matter of if, but when. Whether it’s accidental data deletion, cyber-attacks, or catastrophic hardware failures, these crises pose real threats to your organization. The key to surviving these dreaded moments? Mastering the art of SQL Server backup and restore, particularly in crisis situations. When it comes to learning this essential skill, …

Master Crisis Management with SQL Server Backup and Restore Skills Read more »