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”
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”
Do you need to sync data between azure SQL databases ? or on-prem SQL to Azure SQL ? with unidirectionally or bidirectionally ? Here is the tool for it “Azure SQL Data Sync” , which is now in GA and ready to deploy to production. This has many built in features and functionalities to cater … “Azure SQL Data Sync”
Below diagram will enplane multiple ways of integrating data sources ( on-prem or cloud ) ,data connection methods ( import/direct query) and expressions ( MDX/DAX) with AAS.
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”
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”