by Heath McKerrow | Aug 20, 2025 | Azure, Blog
SUMMARY: To achieve significant cost savings in Azure SQL, database administrators can optimize large-scale data deletion tasks by disabling nonclustered indexes before the operation and rebuilding them afterward. This “disable and rebuild” strategy can...
by Heath McKerrow | Jul 29, 2025 | Azure, Blog
SUMMARY: Azure SQL Automatic Tuning successfully identified and reverted a newly created nonclustered index after investigation using the SQL Server Query Store revealed that the massive 108.15% DTU regression was caused by the index’s imposed maintenance overhead on...
by Heath McKerrow | Jul 10, 2025 | Blog, SQL Server
SUMMARY: Database administrators must explicitly define port 636 within the LDAP:// prefix to correctly enforce Secure LDAP (LDAPS) communication for SQL Server ADSI-linked servers, thereby eliminating insecure cleartext credential transmission and resolving the...
