From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Configure Azure SQL Managed Instance

Configure Azure SQL Managed Instance

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Configure Azure SQL Managed Instance

“

- Welcome back, this is Lesson 2.2: Configure Azure SQL Database Managed Instance for Scale and Performance. So in our last video, we discussed scale and performance for Azure SQL Database. Now we're going to cover the same thing, but for Azure SQL Managed Instance. And let's start by providing a quick overview of what Azure SQL Managed Instance is. So Azure SQL Managed Instance, this is a scalable cloud database server that's always running on the latest stable version of Microsoft SQL Server Engine that offers 99.99% built in high availability and Azure SQL Managed Instance offers close to 100% feature compatibility with on-premises SQL Server. Now since it is a PaaS service, you get to focus on the domain specific database administration and tasks as well as optimization activities that are critical for your business, and Microsoft handles all the administration needs, such as backups, as well as patching and maintenance and updating the SQL Server and operating system. And this…

Contents