Heath McKerrow, Author at Virtual-DBA Remote DBA Services & Support - Certified Database Experts Remote Database Administration Wed, 22 Oct 2025 17:04:35 +0000 en-US hourly 1 https://wordpress.org/?v=6.9.4 https://virtual-dba.com/wp-content/uploads/cropped-VirtualDBA-favicon-32x32.png Heath McKerrow, Author at Virtual-DBA Remote DBA Services & Support - Certified Database Experts 32 32 Slash Your Azure SQL Costs: The Smart Way to Delete Large Datasets https://virtual-dba.com/blog/slash-your-azure-sql-costs-the-smart-way-to-delete-large-datasets/ Wed, 20 Aug 2025 17:42:33 +0000 https://virtual-dba.com/?p=243266 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. Adopting this maintenance technique is a decisive strategy for any organization looking to optimize database operations and control cloud spending in Azure. Is Your Database Maintenance Driving […]

The post Slash Your Azure SQL Costs: The Smart Way to Delete Large Datasets appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> An Azure SQL Detective Story: Why Automatic Tuning Reverted an Index After a 108% Performance Regression https://virtual-dba.com/blog/azure-sql-why-automatic-tuning-reverted-index-after-performance-regression/ Tue, 29 Jul 2025 19:45:59 +0000 https://virtual-dba.com/?p=243188 When Azure SQL's Automatic Tuning feature creates and then immediately reverts an index, it's a sign that something is wrong. But what happens when the performance regression is a staggering 108%? We dive deep into a real-world troubleshooting scenario to uncover a surprising culprit and a critical database tuning lesson.

The post An Azure SQL Detective Story: Why Automatic Tuning Reverted an Index After a 108% Performance Regression appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> Secure SQL Server LDAPS Linked Server Queries and Eliminate Msg 7321 Error https://virtual-dba.com/blog/secure-sql-server-ldaps-linked-server-queries-and-eliminate-msg-7321-error/ Thu, 10 Jul 2025 13:39:00 +0000 https://virtual-dba.com/?p=243114 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 common Msg 7321 error caused by using the technically correct but unsupported LDAPS:// syntax. Proper implementation requires not only the correct connection […]

The post Secure SQL Server LDAPS Linked Server Queries and Eliminate Msg 7321 Error appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]>