Year: 2024

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

1. What is the SA account in SQL Server? The SA (System Administrator) account is the default administrative account in SQL Server, granting unrestricted access to the entire SQL Server instance. It has full permissions to perform any action on the server, making it the most powerful account. 2. Why is using the SA account a security risk? Using the SA account is a significant security risk because it is a well-known target for attackers. If an attacker gains access …

FAQ: Why You Shouldn’t Use the System Admin Account SA on Microsoft SQL Server Read more »

By Posted on Posted in Uncategorized

What is Remote Query Timeout? For the pupose of this article we will abbreviate Remote Query Timeout as RQT. RQT is a setting in SQL Server that specifies the maximum amount of time a remote query can run before timing out. It is defined in seconds and helps ensure that long-running queries don’t hold up resources indefinitely. Why is Remote Query Timeout important? This setting is crucial for maintaining performance and resource allocation in SQL Server. By limiting the duration …

Remote Query Timeout FAQ Read more »

By Posted on Posted in SQL Server Error

Introduction With the release of SQL Server 2019 CU 27, some users have encountered a bug that causes the error log to be flooded with the following warning message: source This issue results from an incorrect code change during the build process of CU 27. If you experience this issue and prefer not to uninstall the CU, there are several steps you can take to resolve it. Understanding the Issue The warning message indicates that an asynchronous API call is …

SQL Server 2019 CU 27 Bug: “WARNING Long asynchronous API Call” Error Log Flooding 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 »

By Posted on Posted in Uncategorized

Hello everyone, I’m Steve Stedman, and today, I’m excited to share with you a feature of the Database Health Monitor software that I’ve developed: The Blocking Query Monitor. Understanding and addressing performance bottlenecks in SQL Server is not always an easy task, and one of the biggest contributors to these bottlenecks is often blocking queries. That’s why I’ve built the Blocking Query Monitor. The Blocking Query Monitor is a powerful tool specifically designed to monitor, report, and help resolve blocking …

Blocking Query Monitor – Part of Database Health Read more »

By Posted on Posted in Uncategorized

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 »