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 based model. see how significant saving you would get with this offer.

https://azure.microsoft.com/en-us/pricing/hybrid-benefit/

Note: same offer is given for Windows servers also.

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 guide

https://docs.microsoft.com/en-us/azure/sql-database/#5-minute-quickstarts

 Azure SQL MI starting guide

Creating managed instances on Azure docs: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-get-started.

In this approach you can:

  1. Use Azure Deploy button to create a valid Azure VNET, subnet, UDR.
  2. Use Azure portal to configure Managed Instance
  3. Use Azure Deploy button to create VM with installed SSMS/SQL Operation studio

Also, in https://docs.microsoft.com/en-us/azure/sql-database/#5-minute-quickstarts we have link to ARM Deployment link that can be used to create full environment, managed instance and VM using single deploy button.

Please try it if you need to configure and create managed instance.

Azure SQL Data Sync

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 enterprise data sync requirements.

The Data Sync uses a hub and spoke topology to synchronize data and can be configured below sync options

Sync Schema
Sync  Direction
Sync interval
Conflict resolution policy

Check out the Azure SQL Data Sync documentation to get started, and get more details from the following content:

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 active geo-replication but the same asynchronous replication mechanism is used.

auto-failover groups (in-preview) gives you listener ( read-write and read-only ) end-point which you can configure to application code ( connection string ) , during the  failover  end-point remain unchanged and no need change application code ( it’s automatic failover ) .

read more https://docs.microsoft.com/en-us/azure/sql-database/sql-database-geo-replication-overview

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 monitor the table size and truncate the data as needed.

Example on getting started with Elastic Jobs: https://gallery.technet.microsoft.com/scriptcenter/Automating-management-of-e7c15e2f