Author: SteveStedman

The integrity of a Microsoft SQL Server database can be severely undermined by corruption, leading to data inaccessibility and potential operational disasters. My comprehensive approach to identifying and rectifying such corruption is often considered an essential tool in the SQL Server administrator’s kit, underlining its significance in maintaining database health. Transcribed from a presentation on Database Corruption by Steve Stedman …

SQL Server Corruption: More about Detecting Corruption Read more »

Mastering SQL Aggregation: Elevate Your Querying Skills If you’ve ever found yourself struggling to make sense of large datasets in SQL Server, you’re not alone. Whether you’re a beginner or an experienced DBA, understanding how to aggregate data efficiently is crucial for optimizing your queries and extracting meaningful insights. That’s why I’m excited to introduce my comprehensive course: Aggregating Data …

SQL Aggregation 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. Here are some reasons to check out this class. Immediate Return …

Why DBAs Should Take Our Backup and Recovery Course Read more »

In the last year I have seen far too much ransomware. I have seen some people lose their databases with no way of getting them back, and I have seen others who have been able to get everything. Some have paid the ransom, and some have not. Even some who have paid the ransom did not got their data back. …

Fighting back against Ransomware Read more »

Keeping your SQL Server up-to-date with the latest patches and updates is an important part of maintaining the security and stability of your system. Here are a few reasons why it is important to keep your SQL Server up-to-date: * Security vulnerabilities: Software is often developed with certain vulnerabilities that can be exploited by hackers. These vulnerabilities are often discovered …

Securing SQL Server: Patching your SQL Server Read more »

In today’s digital landscape, an effective disaster recovery plan focused on data backup and restore is non-negotiable. Imagine the impact of losing crucial SQL Server data due to a glitch, hardware failure, or cyber-attack. For businesses where data is at the core of operations, the stakes are sky-high. Stedman’s SQL Server Backup and Recovery Course is designed to give you …

Equip Yourself for Disaster Recovery with Our SQL Server Backup and Restore Course Read more »

In our digital world, data crises are not a matter of if, but when. Whether it’s accidental data deletion, cyber-attacks, or catastrophic hardware failures, these crises pose real threats to your organization. The key to surviving these dreaded moments? Mastering the art of SQL Server backup and restore, particularly in crisis situations. When it comes to learning this essential skill, …

Master Crisis Management with SQL Server Backup and Restore Skills 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 »

Master SQL Server Performance with Our Comprehensive Tuning Course Is your SQL Server not performing at its best? Are you looking to maximize efficiency, reduce costs, and enhance system stability? Look no further. Stedman Solutions is excited to offer a SQL Server Performance Tuning course designed to equip database professionals with the skills and insights they need to transform their …

Comprehensive SQL Server Performance Tuning Course Read more »

Today Microsoft released a new update for SQL Server. SQL Server 2016 CU17 + GDR for SP2 (13.0.5893.48 – June 2022) CU17 for 2016 SP2 (13.0.5888.11 – March 2021) CU15 + GDR for SP1 (13.0.4604.0 – July 2019) CU15 for SP1 (13.0.4574.0 – May 2019) CU9 for RTM (13.0.2216.0 – November 2017) 2024-09-10 Here are the latest updates for each …

New SQL Update from Microsoft Read more »