This template is for data estates that need a place to consolidate their data into one place for reporting while having the full SQL Server feature set.
It will deploy:
- SQL Managed Instance (Gen 5 4 Cores)
- Azure Storage Account (Blob Storage)
- Azure Data Factory
- Jump Box Virtual Machine (B2ms with SSMS and Self Hosted Integration runtime preinstalled)
To deploy the DPi30 Simple Template click the button below and fill in the required information.
After deploying the simple template you will want to start getting data into your database. Here a few links to help you get started:
- How to connect and sign on to an Azure virtual machine running Windows
- Copy data to and from Azure SQL Database Managed Instance by using Azure Data Factory
- Create and configure a self-hosted integration runtime
- Columnstore Indexes
- Enable vNet Peering
Managed Instance allows you to use SQL Server features such as cross database queries without having to worry about items like backups or setting up with best practices.
SQL Azure Managed Instance currently cannot access Data Lake Gen 2 directly. To allow for bulk insert of data we are using Blob storage for direct access from SQL Azure.
Data Factory is the best option to orchestrate all this data movement and has the best options for moving data from one place to another quickly and easily.
Since Managed Instance is contained within a Virtual Network the safest way to access it is via a Jumpbox sitting inside the same Virtual Network.
Because of the complexity of network routes and subnet requirements for Managed Instance it is easier to have it be in it's own vNet and then peer the network to your current vNet.