Is Your SQL Server Backup and Recovery Strategy Really Up to the Task? Disaster can strike at any moment—a Ransomware attack, a hardware failure, or even a flood in your server room. When it happens, the only thing that stands between you and total data loss is your SQL Server backup and recovery plan. Are you confident in your ability …
If you’re deep into the world of databases like I am, you know just how crucial it is to have our SQL Server data in safe hands. We’ve all faced our share of challenges: from accidental data deletions to terrifying ransomware attacks, uncooperative disks, and those major datacenter blackouts. In this piece, I’ll be breaking down some of the items …
Join us for our third Podcast episode! Next week, Oct. 2, 2024 at 10:30 am PST, discover how Stedman Solutions can give you some piece of mind when it comes to your data. Join us next week for an exclusive episode of the Stedman SQL Podcast, where we’ll tackle a question every business should be asking: How Important is Your …
Are You Prepared for SQL Server Corruption? Hello, I’m Steve Stedman, and I’m here to talk about one of the most critical aspects of SQL Server management: preparing for database corruption. Over the years, I’ve encountered numerous cases of corruption, each one highlighting just how devastating it can be for businesses. From significant data loss to crippling downtime, corruption can …
Today Microsoft released a new update for SQL Server. SQL Server 2022 CU15 for 2022 (16.0.4145.4 – September 2024) CU14 + GDR (16.0.4140.3 – September 2024) 2024-09-25 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: NoneCU15 …
Hello everyone, today, I want to talk about something near and dear to my heart: SQL Server backups. Trust me when I say that having a reliable backup is the guardian angel you never knew you needed until disaster strikes. Here’s why. The Reality of Emergency SQL Server Responses At Stedman Solutions, a portion of our work involves emergency response …
Why Your SQL Server Backups Are More Crucial Than You Think: Lessons from the Frontlines Read more »
Our SQL Server Backup and Recovery Course 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 …
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 …
Remember the most important thing in our Backup and Restore course is learning how to restore a SQL Server database and to get your data back. Our Backup and Restore Course is designed to give you a comprehensive understanding of SQL Server backup strategies, restoration processes, and best practices. Whether you’re a beginner or an experienced DBA, this course covers …
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 MEMORY_ALLOCATION_EXT SP_SERVER_DIAGNOSTICS_SLEEP CXSYNC_PORT CXPACKET ASYNC_NETWORK_IO LCK_M_SCH_S LCK_M_IX LCK_M_S LCK_M_IS Our daily monitoring product scans your SQL Server hourly and …
Common Waits Reported by Daily Monitoring This Month Read more »