Author: Steve Stedman

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 →

Identifying TempDB Bottlenecks with Database Health Monitor Reports SQL Server’s TempDB is a crucial system database that supports temporary storage needs for the SQL Server instance, including temporary tables, table variables, and work files necessary for sorting and query processing. However, TempDB can become a performance bottleneck if not properly managed, especially in high transaction environments. Fortunately, tools like the Database Health Monitor offer insightful reports, such as TempDB IO by Hour, TempDB Usage by Hour, and TempDB High Usage, …

Identifying TempDB Bottlenecks Read more →

Enhancing SQL Server Health with Database Health Monitor Alerting Overview Monitoring your SQL Server environment is essential for ensuring its optimal health and performance. The SQL Server Email Alerting feature in Database Health Monitor is a robust solution designed to keep you informed. By incorporating email notifications into your monitoring setup, this tool empowers you to address issues such as performance slowdowns, security threats, or other critical incidents proactively, before they escalate. With prompt alerts delivered directly to your inbox, …

Enhancing SQL Server Alerting Read more →

Some people say I am obsessed with Join Types, they may be right, you can decide. Todays featured join product is the Joins Shower Curtain. Joins Shower Curtain Start you day out right with a shower and learn some SQL Join Types while you are there. Shower Curtain Impress your friends, and improve your knowledge about joins with this shower curtain. Other Join Products Don’t miss out, get yours today! Coffee Mug Notebook Shower Curtain T-Shirts Drawstring Bag Hats Join …

Learn SQL Joins In The Shower Read more →