by Heath McKerrow | Aug 20, 2025 | Azure, Blog
Table of contentsSummaryIs Your Database Maintenance Driving Up Your Azure Bill?Setting the Stage: The Test EnvironmentSimulating a Real-World HeapThe Deletion Method: A Batched ApproachThe Test Scenarios: A Head-to-Head ComparisonThe Indexes in PlayThe Magic Script:...
by Heath McKerrow | Jul 29, 2025 | Azure, Blog
The Initial Anomaly: A 108% Performance Regression Table of contentsThe Initial Anomaly: A 108% Performance RegressionThe Investigation Begins: Finding the “Affected Query”The Breakthrough: Unmasking the Culprit with Query StoreThe “Aha!”...
by Heath McKerrow | Jul 10, 2025 | Blog, SQL Server
Table of contentsThe Challenge: Remediating LDAP Simple Bind in SQL ServerThe Initial Query: A Standard ADSI OPENQUERYThe LDAPS:// Pitfall and the Dreaded Msg 7321The Correct Approach: Explicitly Defining the Secure PortBeyond Syntax: A 3-Step Security Validation...
