Year: 2025

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 »

Stay Ahead: The Imperative of Keeping SQL Server Updated In the rapidly evolving world of technology, maintaining the currency of your software is not merely a matter of accessing the newest bells and whistles—it’s a foundational element of safeguarding your organization’s data integrity, security, and operational efficiency. This principle is nowhere more critical than in the realm of SQL Server management, a pivotal aspect of the data management strategy for countless enterprises. Through years of hands-on experience and numerous client …

Stay Ahead: Keeping SQL Server Updated Read more »

Podcast: Tackling Schema Drift with Schema Drift from Stedman Solutions Alright, folks, let’s set the stage. Schema Drift is what happens when the structure of your databases—like tables, columns, indexes—starts to differ between environments that should be identical. Maybe a developer tweaks a table in dev but forgets to push it to production, or a hotfix in prod doesn’t make it back to test. Before you know it, your app’s querying a column that doesn’t exist, and chaos ensues. I’ve …

Comparing Databases with SchemaDrift Read more »

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. It is not recommended to place user or DBA type tables into the Master Database. 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 …

SQL Server User Tables in the Master Database Read more »

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Security Risks of SQL Server Agent Jobs at Startup Configuring SQL Server Agent jobs to execute automatically at startup introduces a range of security vulnerabilities and operational challenges that can compromise the integrity, availability, and performance of a SQL Server environment. While certain scenarios—such as replication setups or critical system maintenance tasks—may justify the use of startup jobs, it’s …

SQL Server Startup Jobs: Security Risks Read more »

SchemaDrift from Stedman Solutions is a specialized tool designed to track and monitor changes in your SQL Server database schemas over time. Whether it’s a table being altered, a stored procedure being modified, or an index being added or removed—SchemaDrift captures those changes and provides a clear, chronological log of what changed, when it changed, and who changed it (if available). This is critical for maintaining database integrity, auditing, troubleshooting, and ensuring your development, test, and production environments stay in …

History of SchemaDrift Read more »