Recovering from a complete datacenter outage is a critical aspect of backup and recovery for SQL Server. A complete datacenter outage can be caused by natural disasters, power outages, or other unforeseen events. When a datacenter outage occurs, it can result in significant data loss and system downtime, which can be costly for your organization. To recover from a complete …

Datacenter failure, can you get your backups? Read more »

When it comes to managing SQL Server, monitoring and optimizing performance is a critical part of ensuring that your database environment is running smoothly. The Database Health Monitor for SQL Server is an invaluable tool for monitoring performance and identifying potential issues before they become significant problems. One of the most critical aspects of SQL Server performance monitoring is understanding …

Database Health: Managing SQL Server with Database Health Monitor Read more »

Don’t forget September is our Backup and Restore course promotion month. Watch this sneak peek we put together for you! So don’t wait – take advantage of this amazing offer today! Head over to http://SteveStedman.com/backup to learn more and enroll in the course. Just use the code SEPT25BACKUP at checkout to get your 25% discount.

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 »

Steve and the team at Stedman Solutions, LLC have put together an email based performance tuning course where each week you can get tips and tricks to get more performance out of your SQL Server. Become part of this exclusive group of subscribers learning to put the horse power back into their SQL Server. What You Get: Free weekly emails …

Exclusive SQL Performance Tuning Training 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 »