Episode 136 – Azure SQL Managed Instance

Podcast: Play in new window | Download (Duration: 30:47 — 21.2MB)

Subscribe: Google Podcasts | Spotify | Amazon Music | Pandora | iHeartRadio | Stitcher | Email | RSS

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.

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

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

Previous Episodes

• Episode 129 – The Latest and Greatest in Azure and Office 365
• Episode 128 – Automating SharePoint Online with Flow, PowerShell, and Azure
• Episode 126 – Privileged Accounts In Azure AD The Right Way
• Episode 122 – Saving Money on Compute in Azure
• Episode 117 – Azure Enterprise Scaffold

About the sponsors

	Every business will eventually have to move to the cloud and adapt to it. That’s a fact. ShareGate helps with that. Our 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. Visit https://sharegate.com/ to learn more.
	Sperry Software, Inc focuses primarily on Microsoft Outlook and more recently Microsoft Office 365, where a plethora of tools and plugins that work with email have been developed. These tools can be extended for almost any situation where email is involved, including automating workflows (e.g., automatically save emails as PDF or automatically archive emails that are over 30 days old), modifying potentially bad user behaviors (e.g., alert the user to suspected phishing emails or prompt the user if they are going to inadvertently reply to all), and increased email security (e.g., prompt the user with a customizable warning if they are about to send an email outside the organization). Get started today by visiting www.SperrySoftware.com/CloudIT
	As the leading global brand for enabling the Microsoft Cloud, Opsgility’s global Microsoft MVP and multi-certified Cloud Solutions Architect team has authored over twenty MOC Courses, the Microsoft Press Book Implementing Azure Solutions 70-533 and numerous Microsoft Cloud Practice Playbooks for Microsoft Partners. And for a limited time, you can get your team certified in the most exciting cloud business today with a 25% discount off instructor-led training prep courses for Azure and Microsoft 365! Visit https://opsgility.com/MicrosoftCloud to learn more.
	Intelligink utilizes their skill and passion for the Microsoft cloud to empower their customers with the freedom to focus on their core business. They partner with them to implement and administer their cloud technology deployments and solutions. Visit Intelligink.com for more info.