Ch 1: Azure Managed Instance Intro

• Azure Managed Instance Fundamentals
• Azure SQL: Logical, Virtual & Managed
• Deployment Options of Azure SQL?
• SQL Server PaaS Implementation
• Azure Managed Instance - Advantages
• Azure Managed Instance - Architecture
• Scaling Options & Vcore Purchasing

• Flexible Service Tiers and Compliance
• Frictionless Deployments in Azure MI
• Comparing Azure MI with Azure VM
• Comparing Azure MI with Logical Server
• Database Engine Stability, Availability
• Automated Tuning, Technical Features
• Virtual Networks and Peer Connections

Ch 5: Azure MI - Tuning Concepts

• Azure Managed Instance: Query Tuning
• Automated and Manual Tuning in MI
• Instance Level, Database, Object Level
• Resource Dependancies: Service Plan
• Memory, Disk Usage & Networking
• General Pupose & Business Critial Plans
• Memory Impact on Database Tuning
• Disk and Virtual Core Impact on Tuning
• Memory, Disk, Vcore Recommendations
• Tabel Level Query Tuning Options
• Implementing In-Memory OLTP
• Benefits of Memory Optimized Tables
• Temporal Tables : Creation and Usage
• Data Capture with Temporal Tables
• Creating History Tables, Time Data

Ch 9: Azure MI - HA DR with Replication

• Replication with Azure Managed Instance
• Replication Topology with Azure Shares
• Creating Azure Storage Accounts
• Configuring Azure File Share Services
• Distributor Configuration with File Share
• Articles, Publications & Publication Types
• Snapshot, Transactinal and Merge
• Push and Pull Subscriptions in Azure MI
• Replication Agents: Snapshot, Log Reader
• Distribution Agent. Push / Pull Models
• Replicating Azure MI with Azure VM
• Creating Distributor, Publication in Azure MI
• Creating Subscriptions in Azure MI
• Configuring, Monitoring Replication in MI
• Data Sync Verification; Alerts / Warnings

Ch 2: Azure MI Configurations

• Azure Managed Instance Architecture
• Network Environment, VNets, EndPoints
• Capacity and Compute with VCore
• Gen 4 and Gen 5 Purchasing Options
• CPU Cores, Processor and SSD Capacity
• Proxy, Redirect & Default Connections
• Connection Topology In/Out Azure

• TLS Versions and Security Options
• Azure MI Entities: Virtual Nets, Subnets
• Routing Tables, Virtual Clusters, NSG
• Network Watchers with Azure MI
• Managed Instance Configurations
• Deployment Monitoring with Azure MI
• Azure Managed Instance Key Features

Ch 6: Azure Managed Instance Backups

• Azure MI: Backups Architecture
• Azure MI: Automated & Manual Backups
• Backups with Encrypted Databases
• Backup Compression Ratio in Azure MI
• Backup Frequency: Full, Differential, Log
• Backup Storage Redundancy Options
• LRS, GRS and ZRS Options for Backups

• Backup Scheduling - Automated, Manual
• Backup Storage Consumption Tuning
• Backups Retention Time, Encryptions
• Manual Backups: COPY_ONLY, FORMAT
• Backups with Azure Storage Account
• SAS: Shared Access Signature For Security
• Creating Access Links with Containers
• Disable/Enable Encryptions with Backups

Ch 10: Managed Instance Pools

• Azure Managed Instance Pools
• Real-time Advantages with Az MI Pools
• vCore Purchasing Options in Az MI Pools
• Vnet Integration & Multi Instance Pools
• Deployment and Security Advantages
• IP Allocations and Network Configurations
• Gateway Configurations with Azure MI
• Virtual Machine Partitions & Pricing

• Application Scenarios with Az MI Pools
• Minimal IP Address Allocations
• Multiple Single Instances, Resource Limits
• Storage Size Pools, Databases in Pools
• Azure Active Directory (AAD) Admins
• Supported Features with Managed Pools
• Performance & Security Considerations

Ch 3: Azure MI Connections From VM

• Accessing Azure Managed Intances
• VM Connections and Peer Connections
• Azure Managed Connections from VM
• Configure Azure Virtual Machines with VN
• Resuing Virtual Networks and Subnets
• Azure SQL and Azure VM Deployments
• Azure VM Connections to Azure MI

• Installing and Using Azure Power Shell
• Power Shell for Azure VM Deployments
• PowerShell Commands & JS Templates
• Azure Managed Instance Connections
• Azure MI: SQL Server Authentication
• Creating New Databases in Azure MI
• Differences with On-Premise DB Creation

Ch 7: Azure MI Restores, Monitoring

• Data Recovery Options with DB Restores
• Creating New Databases, DB Replace
• Point In Time Recovery [PITR] in Az MI
• Recovery Time Factors and Challenges
• Deleted Database Restore, Geo Restore
• Manual Restores with Server Credentials
• SAS Key Usage, Monitoring, Verifications

• Azure Managed Instance Monitoring
• Monitoring Azure MI from Azure Portal
• Azure MI : Instance and Database Metrics
• Overview Page, Resource Usage Reports
• Metrics, Alerts and Diagnostics in MI
• Monitoring Azure MI from SSMS Tool
• Standard Reports: Memory Comsumption
• Standard Reports: Server Dashboards

Ch 11: On-Premise Connections

• Azure Point to Site (P2S) Connections
• Open VPN Connections with Azure MI
• TLS VPN Solutions, Real-time Usage
• P2S VPN Client Authentications
• Azure Active Directory Authentication
• Multi Factory Authentication in Azure
• Azure MI : AD Connections with SSMS
• Azure AD Tenants and Gateways

• AD DS Domain Server Configurations
• RADIUS Server Concepts for Azure MI
• OnPremise Connections with Azure MI
• Differences with On-Premise DB Engine
• T-SQL Scripts, Agent, Backups & Restores
• Onpremise Migrations to Azure MI
• Azure MI Migrations to OnPremise

Ch 4: Azure MI Migrations From VM

• Azure Managed Instance Migrations
• Pre and Post Migration Precautions
• Database Exports using SSMS (bacpac)
• Database Backups using T-SQL Scripts
• Database Imports and Restore Options
• Using Azure Storage Accounts, Containers
• Access Keys and Secured BAK File Store

• T-SQL Differences with Azure MI
• Database Creation Differences
• Database Options, Security Differences
• Backup and Restore Differences in MI
• TempDB and MSDB Differences in MI
• SQL Server Agent, Replication Differences
• DB Mirroring and Credential Differences

Ch 8: Azure MI Security Management

• Azure Managed Instance Security
• Network Security, Access Management
• Threat Protection, Information Protection
• Customer Data Security & Encryptions
• Encryption at REST and TRANSIT
• Network Security with Subnets in VM
• Endpoint Connections with Client, Public

• Azure MI: Authentication Modes
• SQL Authentication and Azure AD
• Authorization Levels, Row Level Security
• Threat Protection with Advanced Options
• SSL, TLS and TDE Implementations
• Always Encryption Options in Azure MI
• Key Management, VA and Containment
• Creating Logins, Users, Roles. Previliges

Ch 12: Azure MI Features Comparison

• Azure MI Features with Azure SQL DB
• Azure MI Features with Azure VMs
• Azure MI Features with OnPremise
• Security Differences & Credentials
• HA DR Differences and Compatability
• Performance Tuning Comparisons
• Always Encrypted Feature in Azure
• Detach and Attach Options in Azure MI

• Audditing and Azure AD Authentication
• BULK INSERT, Built-In Functions
• CDC - Change Data Capture, CT Tables
• ColumnStore Indexes, Credentials
• DB Mail and SMTP Connections
• DBCC Commands and DB HealthChecks
• Azure Managed Instance Advantages