Azure Managed Instance

Complete Practical and Real-time Training on Azure Managed Instance. Azure SQL Managed Instance provides users and option in Azure to combine all the great features that come with a platform as a service (PaaS) with a scalable cloud database service that has the broadest SQL Server database engine compatibility. It presents an option for those who are looking to migrate their current database solution to Azure and still have access to near 100% of the most recent SQL Server features with minimal database changes.

This class is a great option for those who are looking to understand the benefits of Managed Instance as compared to other services such as Azure SQL DB. Users will also understand performance, cost, and features available within Managed Instance.

 

Azure Managed Instance Course Contents:

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
Register Today  Other Popular Courses: Azure Synapse Training, Azure Cosmos DB Training, Azure Data Factory Training, Azure Data Engineer Training, Azure Admin Training, AZ-104 Training [+] More Courses

SQL Server T-SQL, Azure SQL, Azure DBA, Azure BI, Azure Data Engineer, Power BI Training