Tag Archive: Azure SQL Database

Azure SQL Standard vs Premium DTU Comparison

Scott McNeany February 17, 2019 Azure SQL Azure, Azure SQL Database, Azure SQL Pricing

For anyone who feels like Microsoft’s Azure SQL sizing is a black box, you are not alone. For existing workloads, you can download and run the DTU Calculator against your on premise database. But for new applications, Microsoft does not…
Read more

Rebuilding Indexes Nightly on Azure SQL Database

Scott McNeany December 31, 2018 Azure Automation Azure, Azure Automation, Azure SQL Database, Azure SQL Database Administration, PowerShell

There are a number of ‘gotchas’ when working with Azure – things that you’ve done the same way for so many years you take them for granted. We were recently tasked with setting up nightly maintenance on a SQL Azure…
Read more