Steve Stedman

At Stedman Solutions we have done many corruption repairs since 2015. When I talk about corruption, most of this information comes from real world scenarios that actually happened at different businesses that we were part of recovering… or not part of recovering if things were completely gone. In a Microsoft SQL Server database, several components can become corrupt, including: * …

SQL Server Corruption: What Can Get Corrupted Read more »

DBCC SHRINKFILE is a database console command (DBCC) in Microsoft SQL Server that can be used to reduce the size of a data or log file in a database. Reducing the size of a file can be useful for reclaiming disk space or for reducing the size of a database to make it easier to move or backup. To use …

SQL Server DBCC Commands: DBCC SHRINKFILE Read more »

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. At Stedman Solutions, we offer comprehensive database health checks to ensure the smooth functioning of your SQL Server. Whether your database has been running well …

SQL Server Health Checks Read more »

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. This 5 min video will explain more about the SQL Server Health Assessment or SQL Server Performance Assessment. https://youtu.be/oRWEZrOgdkQ This once a year deal will is good only available in for those who sign up …

October Promotion – Receive a full year of Daily SQL Monitoring FREE with purchase Read more »

Secure Your SQL Server Data with Our Comprehensive Backup and Recovery Course Fri, 29 Sep 2023 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 grave Read more… The Critical …

September Blog Post Wrap-up Read more »

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 »

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 …

SQL Server Backup and Recovery Guide Read more »

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 »