Author: Steve Stedman

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 »

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 »

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 »

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 »

Mastering SQL Server Replication: A Comprehensive Class by Stedman Solutions Are you ready to take your SQL Server skills to the next level? Join us in this detailed video where we dive into our comprehensive SQL Server Replication class. Whether you’re a database administrator, data architect, or IT professional, this class is designed to provide an in-depth understanding of SQL Server Replication techniques to ensure data consistency and availability across different servers or locations. Watch Steve Stedman’s video to learn …

Mastering SQL Server Replication Read more »

Discover Stedman Solutions: Your Go-To for SQL Server Management In today’s data-driven world, managing your SQL Server environment efficiently and securely is crucial for any business. If you’ve never heard of Stedman Solutions, LLC before, this blog post will introduce you to what we do and explain why we are the best choice for your SQL Server needs. Customer Challenges and Why Stedman Solutions Managing SQL Servers comes with several challenges, including: Staffing Challenges: IT managers often lack DBA knowledge, …

Discover Stedman Solutions Read more »

SQL Server Corruption Class – Learn How to Prepare and React Course Link In this video, we introduce our comprehensive SQL Server Corruption class designed to help you prepare your SQL Server environment to reduce the impact of corruption and react effectively if corruption strikes. What is Database Corruption? Corruption in a SQL database occurs when the database becomes damaged or corrupted, making it inaccessible. Causes can range from hardware failures and software bugs to human error. This can lead …

SQL Server Corruption Class – Learn How to Prepare and React Read more »