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:...
Table of contentsThe High Cost of Over-Provisioning Azure DatabasesHow XTIVIA's DBAs Optimize Azure DatabasesThe XTIVIA Advantage: Cost Savings and Performance Gains on AzureWorking with Azure Managed Database ServicesConclusion Microsoft Azure provides a...
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.
In today's cloud-driven world, businesses need to move fast—but with control. Managing infrastructure manually just doesn't cut it anymore. That's where Terraform comes in. It's an open-source tool from HashiCorp that makes it easy to define, provision, and manage...
Microsoft has announced that it is retiring Azure Database for MariaDB on September 19, 2025. Beginning on March 19, 2024, Microsoft disabled the option to create new MariaDB instances. Any that were created before this date will continue to run until the retirement...
Windows App: Everything You Need to Know As of November 27, 2024, the Azure Virtual Desktop Preview app is no longer available for download or installation, with support ending on December 27, 2024. Transitioning to the Windows App is essential to maintaining...
Microsoft has announced that it is retiring default outbound internet access for new Azure Virtual Machines (VMs) on September 30, 2025. What is default outbound access? Outbound access is a way for a VM to connect to the internet. Previously, VMs could be created...
Microsoft has begun deprecating TLS versions 1.0 & 1.1 across all services in Azure. This requires clients connecting to Azure resources to use TLS 1.2 at a minimum, preferably 1.3 if supported. While many deadlines have passed, Microsoft has extended support for...
Security and management are essential when managing access to Windows machines in Azure. Using Microsoft Entra credentials achieves both and is a fairly straightforward setup. However, MFA (Multi-Factor Authentication) can complicate the process and require some...
Azure Monitor provides comprehensive tools for monitoring the health and performance of your Azure-managed databases, including Azure Managed SQL, Azure Database for PostgreSQL, Azure Database for MySQL, and Azure Database for MariaDB. By following best practices, you...