Author: Steve Stedman

Why an Active SQL Server Agent Job with No Schedule Can Be Misleading or Confusing An active SQL Server Agent job with no schedule can be misleading or confusing for several reasons: Expectation of Execution: An “active” job implies it is running or will run automatically, but without a schedule, it won’t execute unless manually triggered or called by another process. This can confuse users who expect automated execution. Misinterpretation of Status: The “enabled” status of the job might suggest …

Active Agent Jobs with No Schedule Read more →

Why Disabled Indexes in SQL Server Can Cause Issues Indexes in SQL Server are essential for query performance, but disabled indexes can lead to significant problems. This post explores the risks of disabled indexes, why they occur, and how tools like Database Health Monitor can help identify them. What Are Disabled Indexes? In SQL Server, indexes can be disabled using the ALTER INDEX … DISABLE command. When disabled, SQL Server no longer uses the index for queries or maintains it …

Disabled Indexes Read more →

Configuring Database Mail in SQL Server Database Mail is a powerful tool in SQL Server that enables you to send emails directly from your server. This functionality is essential for automation and monitoring, allowing for seamless integration of email notifications when certain criteria are met within your database activities. Whether it’s sending alerts for low disk space or notifying administrators of job completions, setting up and configuring Database Mail ensures you stay informed on your database’s activities without the need …

Configuring Database Mail in SQL Server Read more →

For more information on Database Health Monitor you can visit StedmanSolutions.com. You can download the free trial of Database Health Monitor at https://DatabaseHealth.com/download2. CTRL + Mousewheel Support Database Health Monitor has support for adjusting font sizes using the CTRL + Mousewheel to scroll up or down to resize fonts, this option is available in many of the edit/display fields. Database administrators and analysts continuously seek tools and features that enhance the user experience and streamline workflows. One such feature, often …

CTRL Mousewheel to Adjust Fonts in Database Health Montior Read more →

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. In the world of data-driven decision-making, the ability to efficiently analyze and utilize vast amounts of information has become a cornerstone of successful business operations. At the heart of this capability lies the critical function of database management systems. One of the unsung heroes within this sphere is the feature known as “Auto Create Statistics.” While it may not …

The Importance of Auto Create Statistics Read more →

Virtual Log Files (VLFs) in SQL Server are smaller, manageable segments of the physical transaction log file used to track database changes for recovery and consistency. When a transaction log grows, SQL Server divides it into VLFs to simplify log management, with each VLF handling a portion of the log records. The number and size of VLFs depend on the log file’s initial size and growth increments, and having too many or too few can impact performance—excessive VLFs cause fragmentation, …

Virtual Log File – Video Read more →

Protecting SQL Server from Ransomware: The Power of Immutable Backups In today’s digital landscape, data is a cornerstone of organizational success. For those of us who’ve managed SQL Server environments over the years, the journey of safeguarding data has been both dynamic and challenging. With ransomware attacks looming as a persistent threat—capable of encrypting vital data and disrupting operations—immutable backups stand out as a vital defense for SQL Server databases. Let’s explore why these backups are indispensable and how to …

Immutable Backups for Your SQL Databases Read more →

SQL Server Replication Course from Stedman Solutions Are you looking to master SQL Server replication but don’t know where to start? Or maybe you’ve been tasked with setting up replication in your SQL Server environment, and it feels like a daunting task. The SQL Server Replication Course from Stedman Solutions is here to help you bridge that gap. Designed by true SQL Server specialists, this course provides hands-on learning to give you the confidence and expertise you need to handle …

SQL Server Replication Course by Steve Read more →

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Understanding the Risks: User Tables in the Master Database and Disaster Recovery When it comes to managing SQL Server, the master database stands out as one of the most critical system databases. It holds essential system-level data, including server-wide configurations and the existence of other databases. Given its importance, it’s understandable why any conversation about disaster recovery will inevitably …

User Tables in the Master Database and Disaster Recovery Read more →