Episode 136 – Azure SQL Managed Instance

by [Scott](/content/author/scottmsclouditpro/ "Posts by Scott"/index.html) | Aug 1, 2019 | Podcast

In Episode 136, Ben and Scott go through some of the high-level features of Azure SQL Managed Instance and how it compares to SQL in Azure IaaS against Azure SQL single and elastic databases. They also talk about some of the configurations you’ll want to pay attention to when bringing Azure SQL MI into your environment.

Show Notes

• Managed instances overview
• Choose the right SQL Server option in Azure
• Feature comparison: Azure SQL Database versus SQL Server
• Connectivity architecture for a managed instance in Azure SQL Database
• Determine VNet subnet size for Azure SQL Database Managed Instance
• Create a virtual network for Azure SQL Database Managed Instance
• Configuring a Custom DNS for Azure SQL Database Managed Instance
  • Why Azure SQL Managed Instance needs IP address 168.63.129.16 in custom DNS configured in instance subnet and how it affects name resolution
  • Update sql-database-managed-instance-custom-dns.md
• Connect your application to Azure SQL Database Managed Instance
• Dev/test pricing option for individual Visual Studio subscribers is now available for Azure SQL Database managed instance

Sponsors

• Sperry Software – Powerful Outlook Add-ins developed to make your email life easy even if you’re too busy to manage your inbox
• ShareGate – ShareGate’s industry-leading products help IT professionals worldwide migrate their business to the Office 365 or SharePoint, automate their Office 365 governance, and understand their Azure usage & costs
• Opsgility – Your Cloud enablement partner to help guide your organization through all phases of Cloud migration and adoption
• Office365AdminPortal.com – Providing admins the knowledge and tools to run Office 365 successfully
• Intelligink – We focus on the Microsoft Cloud so you can focus on your business