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:

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:

Accessing Azure Managed Instances: VM Connections and Peer Connections: Azure Managed Connections from VM: Configure Azure Virtual Machines with VN: Reusing Virtual Networks and Subnets: Azure SQL and Azure VM Deployments: Azure VM Connections to Azure MI: Installing and Using Azure PowerShell: PowerShell 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:

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:

Azure Managed Instance – Query Tuning: Automated and Manual Tuning in MI: Instance Level, Database, Object Level: Resource Dependencies – Service Plan: Memory, Disk Usage & Networking: General Purpose & Business Critical Plans: Memory Impact on Database Tuning: Disk and Virtual Core Impact on Tuning: Memory, Disk, Vcore Recommendations: Table 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:

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:

Data Recovery Options with DB Restores: Creating New Databases, DB Replace: Point In Time Recovery [PITR] in Azure 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 Consumption: Standard Reports – Server Dashboards:

Azure Managed Instance Security: Network Security, Access Management; Threat Protection, Information Protection; Customer Data Security & Encryption; 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, Privileges.

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, Transactional, 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

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

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-Factor 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; On-Premise Connections with Azure MI; Differences with On-Premise DB Engine; T-SQL Scripts, Agent, Backups & Restores; On-Premise Migrations to Azure MI; Azure MI Migrations to On-Premise

Azure MI Features: Azure MI Features with Azure SQL DB; Azure MI Features with Azure VMs; Azure MI Features with On-Premise; Security Differences & Credentials; HA/DR Differences and Compatibility; Performance Tuning Comparisons; Always Encrypted Feature in Azure; Detach and Attach Options in Azure MI. Auditing and Authentication: Auditing 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 Health Checks; Azure Managed Instance Advantages