sys.dm_exec_query_profiles: What the Row Counts Hide
What sys.dm_exec_query_profiles counts, what it misses, and the traps in reading it by hand, before you trust a query progress number.
2026
Veterans Day Offer: Free Database Health Monitor Onboarding for Veterans
This Veterans Day, we are proud to recognize and honor the brave men and women who have served our country, including the dedicated Veterans who… Read More »Veterans Day Offer: Free Database Health Monitor Onboarding for Veterans
ORM SQL Server Performance: Which Framework Is It?
ORM SQL Server performance problems hide behind one program name. Learn how to spot the framework, its Unicode parameters and its transactions, and fix them.
SQL Server Database Corruption: Prevention, Detection and Recovery Course
SQL Server Database Corruption can strike any organization without warning. Learn proven prevention, detection, and recovery strategies to protect your data. Database corruption can lead… Read More »SQL Server Database Corruption: Prevention, Detection and Recovery Course
Version 4.1869: Get Answers From Your SQL Server History Before the Auditor Asks
What Database Health Monitor 4.1869 means for the people accountable for SQL Server: monthly summaries, capacity dates, accountability reports and PDF output.
SQL Server Training Discounts: CTE Class, Aggregation for $3 and 50% Off Performance Tuning
Greetings, dedicated learners and passionate SQL Server enthusiasts! Time is of the essence as we near the conclusion of another productive week of training at… Read More »SQL Server Training Discounts: CTE Class, Aggregation for $3 and 50% Off Performance Tuning
SQL Server Performance Tuning Course – 50% Off for $149.99
Are you prepared to dramatically enhance your SQL Server’s performance and achieve faster query response times? If so, you’re in the right place! We’re excited… Read More »SQL Server Performance Tuning Course – 50% Off for $149.99
Logical Reads Per Row: Which Query Reads Too Much?
Total reads rank the loud query, not the wasteful one. See how logical reads per row separates honest scans from lookups with a missing index.
SQL Aggregation and Window Functions Course for $3 (Limited Time)
Attention all SQL enthusiasts, data analysts, and database professionals seeking to elevate their skills! Our highly anticipated SQL Aggregation and Window Functions course in SQL… Read More »SQL Aggregation and Window Functions Course for $3 (Limited Time)
WRITELOG Wait: Slow Storage or One-Row Commits?
A WRITELOG wait has two opposite fixes: faster storage or batched commits. Here is how to tell which one your SQL Server needs before you… Read More »WRITELOG Wait: Slow Storage or One-Row Commits?