Over the course of my SQL Server journey, I’ve grown to appreciate just how vital data Aggregation is for gaining insights from your data. That’s why I’ve developed a course on Teachable called “Aggregating Data in Your SQL Queries,” aimed at helping you master this essential skill. https://stedman.us/aggregation I’d love to share some of the exciting benefits this course offers …
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. …
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. Special October Offer: Get 1 Year of Free SQL Server Monitoring with a Server Assessment! For the entire month of October, Stedman Solutions is offering an unbeatable deal! From October 1st to October 31st, when …
October Promotion – Receive a full year of Daily SQL Monitoring FREE with purchase Read more »
One of the key aspects of effective database monitoring is quick, visual insight into what’s happening with your SQL Server. The Database Health Monitor tool has always aimed to make database management easier and more intuitive, and a big part of that is in how information is displayed. A central feature of the tool is the color-coding used in its …
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 »
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 …
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 …