Home

Azure SQL Database Managed Instance comparison to Azure SQL Database

%3CLINGO-SUB%20id%3D%22lingo-sub-254971%22%20slang%3D%22en-US%22%3EAzure%20SQL%20Database%20Managed%20Instance%20comparison%20to%20Azure%20SQL%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-254971%22%20slang%3D%22en-US%22%3EAzure%20SQL%20Database%20brought%20many%20new%20features%20to%20SQL%20Server.%20Features%20such%20as%20Dynamic%20Data%20Masking%2C%20Always%20Encrypted%2C%20Row-Level%20Security%2C%20Query%20Store%2C%20and%20more.%20However%2C%20Azure%20SQL%20Database%20was%20built%20on%20a%20database%20scoped%20configuration%20model%20and%20has%20certain%20limitations%20compared%20to%20on-premises%20SQL%20Server.%20With%20the%20introduction%20of%20Managed%20Instance%2C%20we%20see%20most%20of%20those%20limitations%20removed.%20Managed%20Instance%20helps%20bridge%20the%20gap%20between%20Azure%20SQL%20Database%20and%20on-premises%20SQL%20Server%20due%20to%20being%20built%20on%20an%20instance%20scoped%20configuration%20model.%20In%20this%20session%2C%20we%20compare%20Azure%20SQL%20Database%20and%20Managed%20Instance%20in%20relation%20to%20on-premises%20functionality%20so%20that%20you%20will%20get%20a%20solid%20understanding%20of%20what%20Managed%20Instance%20has%20to%20offer.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fmyignite.techcommunity.microsoft.com%2Fsessions%2F66191%3Fsource%3DTechCommunity%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ECheck%20this%20session%20out%20in%20the%20Ignite%20Session%20Catalogue%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-254971%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ETHR2085%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Community Manager
Azure SQL Database brought many new features to SQL Server. Features such as Dynamic Data Masking, Always Encrypted, Row-Level Security, Query Store, and more. However, Azure SQL Database was built on a database scoped configuration model and has certain limitations compared to on-premises SQL Server. With the introduction of Managed Instance, we see most of those limitations removed. Managed Instance helps bridge the gap between Azure SQL Database and on-premises SQL Server due to being built on an instance scoped configuration model. In this session, we compare Azure SQL Database and Managed Instance in relation to on-premises functionality so that you will get a solid understanding of what Managed Instance has to offer.

Check this session out in the Ignite Session Catalogue
Session Code
THR2085
Speaker
Tim Radney
Session Type
Theater: 20 Minute
Product
Show more
Audience
Personas
Topic
Data & AI-Data & AI
Format
Session
Level
Intermediate (200)
Show less