Azure Hybrid Benefit for Azure SQL

Maximize your current Software Assurance investment by using your existing SQL Server licenses to save up to 55 percent on vCore-based SQL Database options, SQL Server in Azure Virtual Machines and SQL Server Integration Services. The calculator will give the option to select Azure SQL instance type ( Mi,Elastic pool or single database)  with vCore … “Azure Hybrid Benefit for Azure SQL”

Read More

Azure SQL Managed Instance

Azure SQL Managed Instance is the best suited for your on-prem ,complex SQL deployment move to Azure. Which has  many features and will be GA very soon. Quick start guides allow you to provision Azure SQL Instances ( MI,Single or Elastic pool)  with many options like Azure Portal,PowereShell or CLI, below URL give the starting … “Azure SQL Managed Instance”

Read More

Azure SQL Database auto-failover groups

The auto-failover groups ( Preview)  feature is regards to the Azure SQL HA and it’s combination of Active geo-replication. Active geo-replication leverages the Always On technology of SQL Server to asynchronously replicate committed transactions on the primary database to a secondary database using read committed snapshot isolation (RCSI). Auto-failover groups provide the group semantics on top of … “Azure SQL Database auto-failover groups”

Read More

Scale and Pause or Resume using scheduled autoscaling

Dynamically scaling SQL PaaS elastic pool DB https://docs.microsoft.com/en-us/azure/sql-database/scripts/sql-database-monitor-and-scale-pool-powershell  Azure Analysis Services – Scale and Pause or Resume using scheduled autoscaling https://gallery.technet.microsoft.com/scriptcenter/Scale-and-Pause-or-Resume-54ce97a2 Auto-archival using Elastic Jobs or Azure Automation Example Azure Automation: https://gallery.technet.microsoft.com/scriptcenter/Azure-Automation-Your-SQL-30f8736b Also relevant to multi-tenant application and pool of databases (tenant per DB) , you want a single automated job to run across all DBs to … “Scale and Pause or Resume using scheduled autoscaling”

Read More