Author: Steve Stedman

By Posted on Posted in SQL Server Classes

In the wise words of Benjamin Franklin, “If You Fail to Plan, You Are Planning to Fail.” This timeless adage holds particular relevance when it comes to safeguarding your SQL Server databases. A failure to adequately prepare for data loss scenarios—be it due to hardware malfunctions, data corruption, or increasingly prevalent ransomware attacks—can have devastating consequences for your business. The Common Problem: Lack of Preparedness Despite the rising risks, it’s shocking how often we encounter businesses that are inadequately prepared …

SQL Server Backup and Recovery Course Read more »

By Posted on Posted in SQL Server Classes

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 on Investment: By mastering backup and recovery skills, you reduce the risk of costly downtime, data loss, and business disruptions, ensuring that your investment in this training pays for itself many times over. Access to Exclusive Tools and Resources: Gain …

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

By Posted on Posted in Uncategorized

Database Health Monitor Database Health Monitor is a comprehensive tool designed to help SQL Server administrators keep their databases running smoothly. Developed to provide deep insights into the health and performance of SQL Server environments, it’s particularly valuable for those who want to prevent problems before they occur. Key Features of Database Health Monitor: Performance Monitoring:Continuously tracks key performance metrics like CPU usage, memory utilization, and query execution times. It helps identify slow-running queries, bottlenecks, and inefficient resource usage. Index …

Database Health Monitor Overview Read more »

By Posted on Posted in Uncategorized

If You Like Database Health Monitor but Need More Help, Try Stedman Solutions Managed Services If you’ve been using Database Health Monitor for a while, you already know the power it brings to SQL Server monitoring. With its comprehensive reports, performance metrics, and alerting features, it’s an invaluable tool for any DBA or IT manager. But what happens when you need more than just monitoring? What if you encounter a complex performance issue, a Corruption problem, or simply need expert …

Need More Help, Try Stedman Solutions Managed Services Read more »

By Posted on Posted in Uncategorized

In the world of database management, maintaining optimal performance is an ongoing challenge. One crucial aspect that often gets overlooked is the management of indexes. While indexes can significantly enhance query performance, having too many of them can lead to issues when it comes to inserts, updates, and deletes. In this blog post, we’ll explore the delicate balance of index management and discuss strategies to identify and remove unnecessary indexes without compromising system stability. The Dilemma of Too Many Indexes …

Dangers of Removing Indexes Read more »

By Posted on Posted in Uncategorized

Free Ransomware Awareness Class – Essential Protection for Your Business | Stedman Solutions Watch this video by Steve Stedman to find out more. For additional informative videos, visit my YouTube channel at https://www.youtube.com/@SteveStedman. There, you’ll find a wide range of content covering various topics, all designed to provide valuable insights and help you stay informed. What You’ll Learn: The basics of Ransomware: What it is and how it works. Real-world examples of Ransomware attacks and their consequences. Key strategies for …

Free Ransomware Awareness Class Read more »

By Posted on Posted in Uncategorized

Aggregating Data in Your SQL Server Are you ready to take your SQL skills to the next level? Our Aggregating Data in Your SQL Server course offers a comprehensive guide to mastering aggregation, grouping, and windowing functions in SQL Server queries. In This Course This detailed course covers everything from basic aggregation to advanced windowing functions using the OVER clause. Here’s what you will learn: Basic Aggregation: Understand how to use aggregate functions like SUM, AVG, COUNT, and more. Aggregation …

Data Aggregation with SQL Server Read more »

By Posted on Posted in Uncategorized

Reasons for Queries with Multiple Execution Plans and How to Find Them SQL Server Performance Tuning often involves identifying and optimizing problematic queries. One common issue that can impact performance is when a single query generates multiple execution plans. Understanding why this happens and how to detect these queries can significantly improve your database performance. Let’s delve into the reasons behind multiple execution plans, including the impact of non-parameterized queries, and the methods to identify them. Why Do Queries Generate …

Multiple Plans and How to Find Them Read more »

By Posted on Posted in Uncategorized

Welcome to our Backup and Recovery Course! Watch this video by Steve Stedman to find out more. In today’s digital age, data is the lifeline of any business. Ensuring its safety and availability is paramount. Our comprehensive Backup and Recovery Course is designed to equip you with the essential skills and knowledge to safeguard your data effectively. For additional informative videos, visit my YouTube channel at https://www.youtube.com/@SteveStedman. There, you’ll find a wide range of content covering various topics, all designed …

Backup and Recovery Course Read more »

By Posted on Posted in Uncategorized

Welcome to Stedman’s SQL School! In this video, we provide an in-depth overview of all the classes we offer to help you master SQL Server. Whether you are a beginner or an experienced professional, our courses cover a wide range of topics tailored to enhance your SQL skills and knowledge. Watch Steve Stedman’s video to learn more about this exciting topic. You’ll gain valuable insights and detailed information directly from an expert in the field. For additional informative videos, visit …

Overview of Classes at Stedman SQL School Read more »