Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Learn Microsoft Azure

You're reading from  Learn Microsoft Azure

Product type Book
Published in Dec 2018
Publisher Packt
ISBN-13 9781789617580
Pages 354 pages
Edition 1st Edition
Languages
Author (1):
Mohamed Waly Mohamed Waly
Profile icon Mohamed Waly

Table of Contents (14) Chapters

Preface 1. Microsoft Azure 101 2. Understanding Azure Storage 3. Getting Familiar with Azure Virtual Networks 4. Understanding Azure Virtual Machines 5. Azure Web Apps Basics 6. Managing Azure Web Apps 7. Basics of Azure SQL Database 8. Managing Azure SQL Database 9. Understanding Azure Active Directory 10. Monitoring and Automating Azure Services Using OMS 11. Data Protection and Business Continuity Using OMS 12. Assessments 13. Other Books You May Enjoy

Azure SQL Managed Instances

In the previous chapter, Azure SQL Managed Instances were introduced as one of the Azure SQL Database types. In this section, we will provide more information on them.

Azure SQL Managed Instances offer the full functionalities of SQL Server Enterprise. If you need some features that were not available in the previous types that we discussed (such as SQL Agent or linked servers), this type will fulfill your needs.

Azure SQL Managed Instances can be better than the other Azure SQL Database types, for the following reasons:

  • SQL Server Enterprise edition features support: All of the features that you used to work with an SQL Server on-premises can be used with this type.
  • Dedicated instance: Unlike with the other types of Azure SQL Databases, you will not be sharing the server on which you run your database with others.
  • Backward compatibility: If you have...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €14.99/month. Cancel anytime}