For the month of October you will receive a free year of our SQL Server Daily Monitoring with the purchase of a SQL Server Assessment. Hello, I’m Steve Stedman, the founder and owner of Stedman Solutions, LLC. If you’re concerned about the stability of your database or if it has been running without proper administrator oversight, we’re here to help. …
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 »
CLR (Common Language Runtime) is a feature of SQL Server that allows you to create and run managed code within the database engine. Enabling CLR on SQL Server allows you to create stored procedures, triggers, and functions using languages such as C# and VB.NET. While CLR can be a useful feature, it can also be a security risk if not …
Over the past eight years, I’ve specialized in corruption repair for SQL Server databases. Throughout this time, a recurring challenge has been conveying the unfortunate news to clients that their data is irretrievable. An in-depth experience has revealed that approximately 10% of those with a corrupt database that I encounter face this devastating reality. Key Indicators of Irretrievable Data During …
The Critical Importance of Backups in SQL Server Database Management Read more »
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 …
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 …
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 …
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 »
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 …
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 …