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 »

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 »

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 »

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 »

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 »

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 »

Why is low disk space a concern for SQL Server? Low disk space can cause several issues in SQL Server, including: What immediate steps can I take to free up disk space? How can I prevent low disk space issues in the future? What tools can help monitor and manage disk space? Stedman Solutions offers the Database Health Monitor, a comprehensive tool for monitoring SQL Server performance, including disk space usage. Learn more at DatabaseHealth.com. How can Stedman Solutions help …

FAQ: Low Disk Space in SQL Server Read more »

What are Database Snapshots? A Database Snapshot is a read-only, static view of a SQL Server database (the source database) at a particular point in time. It allows you to quickly create a version of your database that you can refer back to, ensuring that you have a consistent state of your data for reporting, auditing, or recovery purposes. Key Characteristics of Database Snapshots: How Database Snapshots Work: When a database snapshot is created, SQL Server starts by allocating a …

Understanding SQL Server Database Snapshots Read more »

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 »