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 (MI) Training Plans

  PLAN A PLAN B PLAN C
  Azure
Managed
Instance (Azure MI)
Azure SQL,
Azure VM,
Azure MI
Core DBA,
Azure SQL,
Azure MI
Total Duration 3 Weeks 6 Weeks 12 Weeks
Azure Managed Instance
Azure MI Architecture
Azure MI Replication Topology
Azure MI Connection Types
Machine Learning with Azure MI
Azure SQL Database Migration
Azure SQL DB Security, HA-DR
Azure Always-On, PowerShell
Azure Virtual Machines (VM)
Routine SQL DBA Activities
Emergency SQL DBA Activities
SQL Server, DB Maintenance
DB Repairs, Security Management
Tuning Tools, Execution Plans
Clustering, Always-On Availability
Total Course Fee * INR 12000  INR 9000
USD 150 USD 122
INR 18000
USD 244
INR 39000
USD 487

Trainer: Mr. Sai Phanindra T

Schedules for Azure DBA [Chapters 28 to 39]
S No Timings (IST) Start Date  
  Regular Schedules [Mon - Fri]
1 8 PM - 9 PM Nov 19th Register
  Weekend Schedules [Sat & Sun]
2 6 AM - 8 AM Dec 5th Register
3 8 PM - 10 PM Dec 12th Register
Schedules for SQL DBA [Chapters 1 to 27]
S No Timings (IST) Start Date  
Regular Schedules [Mon - Fri]
1 6 AM - 7 AM Nov 19th Register
2 8 PM - 9 PM Nov 30th Register

If above schedule does not work, opt for Azure Admin Training Videos

Azure Managed Instance Training Highlights :

✔ Azure Fundamentals, Cloud Implementations
✔ SaaS, IaaS & PaaS Implementation Concepts
✔ Azure Kubernetes Services (AKS) Concepts
✔ Azure Active Directory and Security Concepts
✔ Public Cloud and Private Cloud Concepts
✔ Azure Governance Methodologies
✔✔ End to End Real-time Project @ Resume

All Session Are Completely Practical & Real Time

 

Azure Managed Instance Course Contents:

Module I: SQL Server & T-SQL

Installation, Architecture, DB Basics

Module II: Basic SQL DBA

Backup-Restores, Jobs, Performance Tuning, Security

Module III: Advanced SQL DBA

HA-DR, Errors & Solutions, Always-On, SLA

Ch 1: JOB ROLES, INSTALLATION

  • Introduction to Databases, DBMS
  • Microsoft SQL Server : Advantages, Use
  • Versions and Editions of SQL Server
  • SQL DBA Job Roles, Responsibilities
  • Routine Maintenance DBA Activities
  • Emergency SQL DBA Activities
  • SQL Server Pre-requisites: S/W, H/W
  • SQL Server 2019/2017/2016 Installation
  • Default Instance, Named Instances
  • Port Numbers, Instance Differences
  • Service and Service Account Use
  • Authentication Modes and Logins
  • Firewall Configuration in Real-time
  • SQLServr.exe and SQLBrowser.exe

Ch 9: BACKUPS - DB, Filegroup, File

  • Database Backups, Filegroup Backups
  • Log File Backups and Log Truncations
  • COPY_ONLY Backups and Real-time Use
  • Mirror Backups and Split Backups
  • Partial Backups - ReadOnly Filegroups
  • Format, Compression and Checksum
  • Backup Verification, RetainDays, Stats
  • ContinueOnError and Backup Scripts
  • GUI and Script Backups: Differences
  • Backup History Tables in MSDB - Joins
  • Backup Audits. HOT and COLD Backups
  • Backup Devices - Creation and Usage
  • Using Backup Devices - Advantages
  • Common Errors and Solutions

Ch 17: REPLICATION For HA - Level 1

  • Replication Architecture and Topology
  • Publication Types - Purpose, Importance
  • DB Articles, Publications, Subscriptions
  • Distribution DB Configuration, Snapshots
  • Snapshot Replication and Repl Agents
  • Adding Articles to Existing (LIVE) Replica
  • PUSH, PULL Subscriptions. N/W Shares
  • Transactional Replication Configuration
  • Log Reader Agent - Configuration, Keys
  • Replication Monitor - Tracer Tokens
  • Replication Monitor - Warnings, Alerts
  • Replication Monitor - Adding Articles
  • Replication Scripts, Reinitialization
  • Replication Warnings and Agent Alerts

Ch 2: SSMS Tool, SQL BASICS - 1

  • SSMS Tool Installation, Connections
  • SQL Server Management Studio
  • Single Server, Multi Server Connections
  • System Databases: Master and Model
  • MSDB, TempDB, Resource Databases
  • SQL and T-SQL: Basic Differences
  • DDL, DML, SELECT Statements
  • Using GUI and SQL Scripts in SSMS
  • Creating Databases : Files [MDF, LDF]
  • Creating Tables in SQL Server
  • Data Storage in Tables : Inserts
  • SELECT : Data Retrieval Statement
  • Table Scans. LIVE QUERY STATISTICS
  • Limitations with SSMS GUI Options

Ch 10: RESTORES & DB RECOVERY

  • Restore Phases - COPY, REDO, UNDO
  • RECOVERY, NORECOVERY Options
  • STANDBY and REPLACE in Restores
  • File, File Group & Metadata Restores
  • Backup Verifications using GUI, Scripts
  • VERIFYONLY : Backup Verification
  • STATS, UNLOAD, STOPAT and INIT
  • PARTIAL / PIECEMEAL Restores - Use
  • Tail Log Backup Usage in Real-time
  • Restores using GUI and T-SQL Scripts
  • MOVE Options for File Level Restores
  • Point-In-Time Restore, Checkpoint LSN
  • Standby Restores and Read-Only State
  • Common Errors and Solutions

Ch 18: REPLICATION For HA - Level 2

  • Merge Replication and Merge Agent Job
  • Replication Conflicts and ROWGUIDCOL
  • Server Subscription & Client Subscription
  • Peer-Peer Replication Connections, Nodes
  • NodeID and Conflict Detection Options
  • Replication Conflicts and sp_MSRepl
  • sp_changedbowner, backup initialization
  • Replication Conflicts and Priority Settings
  • Replication Verify - Rowcount, Checksum
  • Disabling, Cleaning Replication Topology
  • Replication Strategies for HA and DR Plan
  • Replication for Load Balancing Topologies
  • SQL Server Configuration Manager Tool
  • Common Errors and Solutions

Ch 3: SQL BASICS - 2, TEMP TABLES

  • Data Inserts and SELECT Statement
  • WHERE Conditions and Keywords
  • IN Operator and NOT IN Operator
  • Between, Not Between Operators
  • UPDATE Statement & Conditions
  • DELETE & TRUNCATE Statements
  • Logged and Non-Logged Operations
  • ADD, ALTER and DROP Columns
  • Aliases and Batch Statements
  • Import and Export Wizard in SSMS
  • Performing Bulk Operations in SSMS
  • Temporary Tables : Real-time Use
  • Local and Global Temporary Tables
  • # and ## Prefix, Scope of Usage
  • Session Level, Connection Level Use

Ch 11: JOBS, MAINTENENCE PLANS

  • SQL Server Agent Service & Agent XPs
  • SQL Agent Jobs - GUI, Script Creations
  • Job Steps - Creation, Edits and Parse
  • Job Executions, Disable/Enable Options
  • Job History Purge. Job Activity Monitor
  • Database Offline and Backup Errors
  • Database Maintenance - Backup Jobs
  • Scheduling Database Maintenance Plans
  • Automated Job Creations using DMPs
  • Backup Cleanup & History Cleanup Jobs
  • Backup Strategies For Minimal Data Loss
  • Backup Options: Block Size, Transfer Size
  • DB Mail Configurations and Alert System
  • DB Mail Profiles, SMTP Email Accounts
  • Operators : Creation, Job Notifications

Ch 19: LOG SHIPPING (HA - DR)

  • Log Shipping Topology for HA and DR
  • Primary and Secondary: Recovery Plan
  • Log Shipping Monitor, Jobs and Alerts
  • NORECOVERY Mode - Configuration
  • STANDBY Mode Configuration & Jobs
  • Log Shipping Jobs and Manual Failover
  • Log Shipping Mode Changes - cautions
  • Re-Restoring Log Backups for Recovery
  • LSBackup, LSCopy & LSRestore Jobs
  • LS Job Audits, Dashboards (Reports)
  • TUF Files and Standby Options in LS
  • Broken Log Shipping Chains & Issues
  • Log Shipping Manual Fail-over Options
  • Log Shipping Configuration Precautions
  • Common Backups Errors & Solutions

Ch 4: CONSTRAINTS, JOINS

  • Constraints and Keys - Data Integrity
  • NULL, NOT NULL Property on Tables
  • UNIQUE KEY Constraints: Importance
  • PRIMARY KEY Constraint: Importance
  • FOREIGN KEY Constraint: Importance
  • REFERENCES, CHECK and DEFAULT
  • Candidate Keys and Identity Property
  • JOINS - Table Comparisons Queries
  • INNER JOINS For Matching Data
  • OUTER JOINS For (non) Match Data
  • Left Outer Joins with Example Queries
  • Right Outer Joins with Example Queries
  • FULL Outer Joins - Realtime Scenarios
  • Join Queries with "ON" Conditions

Ch 12: SECURITY MANAGEMENT

  • Authentication Types & Modifications
  • Windows Logins & SQL Server Logins
  • Logins - Users Mapping, DB Access
  • Server Roles & Database Roles - Usage
  • Object, Column and Schema Security
  • GRANT, WITH GRANT, DENY, REVOKE
  • CONTROL, OWNERSHIP, Authorization
  • Data Encryption: Keys and Certificates
  • Data Encryption with Stored Procedures
  • Job Security : Credentials and Proxies
  • Using Proxies for SSIS Jobs, Repl Jobs
  • Security Scripts and Documentation
  • DMVs for Security Audits, Orphan Users
  • Login, User, Server Principal Audits

Ch 20: DB MIRRORING (HA - DR)

  • DB Mirroring Architecture For HA & DR
  • Log Shipping Versus Database Mirroring
  • TCP Endpoints, TCP Network Security
  • Heartbeat and Polling Concepts in DM
  • Automatic Fail-Over Procedures, Tests
  • PARTNER OFFLINE Conditions, Options
  • DB Mirroring Monitors and Commit Loads
  • SYNCHRONOUS & ASYNCHRONOUS
  • DB Mirroring and Port Configurations
  • Mirroring Monitor, Stop/Resume Options
  • Need for Always-On & Higher Availability
  • DB Recovery without Witness. Failover
  • Mirroring Monitor Jobs - Real-time Usage
  • Common Backups Errors & Solutions

Ch 5: Views & Stored Procedures

  • Views : Types, Usage in Real-time
  • Creating Views For SELECT Statement
  • Views: Executions, Metadata Audits
  • Views: Refresh Options, Recompilations
  • System Predefined Views and Audits
  • Listing Databases, Tables, Schemas
  • Procedures : Types, Usage in Real-time
  • User & System Predefined Procedures
  • Parameters and Dynamic SQL Queries
  • Using Static Joins and Metadata Audits
  • Using Dynamic Joins and Metadata Audits
  • Sp_help, Sp_helpdb and sp_helptext
  • sp_pkeys, sp_rename and sp_help
  • sp_recompile, sp_who, sp_who2, sp_lock

Ch 13: DB Migrations, Perf Tuning - 1

  • CDW : Copy Database Wizard @ SSMS
  • Database Detach and Attach Options
  • SMO Method and Database Scripting
  • CDW SSIS Packages, SSIS Proxies Use
  • Scheduling Database Migration Jobs
  • Detecting and Resolving Orphan Users
  • Containment Databases Authentication
  • Audit Long Running Queries : DMV, DMF
  • Activity Monitor Tool, Server Dashboards
  • Logical I/O, Physical I/O, Database I/O
  • Recent Expensive Queries, Wait Time
  • Active Expensive Queries, Statistics
  • Plan Handle, Execution Time - Audits
  • CPU, IO, Memory Consumption Reports

Ch 21: PATCHES, UPGRADES, CUs

  • Maintenance: Precautions & Downtime
  • DB Backups, Scripting and Services
  • Service Packs and Patch/Hotfix Activities
  • Cumulative Updates (CU), Hotfix Process
  • Instance Selectivity for Updates, Cautions
  • Verifications, Smoke Test and Rollbacks
  • Multi Instance Updates & Port Changes
  • SERVER Upgrades & VERSION Changes
  • Silent Installation & Installation Repairs
  • Verifications, Smoke Test and Rollbacks
  • System Database REBUILDs using CMD
  • Silent Installation & Installation Repairs
  • SQLCMD Tool and Instance Connections
  • DAC : Dedicated Administration Console

Ch 6: UDF, Triggers, Stored Procedures

  • Functions : Types, Usage in Real-time
  • Scalar, Inline and Multi-Line Functions
  • System Predefined Functions, Audits
  • DBID, DBName, ObjectID, ObjectName
  • Date and Time Functions: Getdate()
  • User & System Predefined Procedures
  • Parameters and Dynamic SQL Queries
  • Triggers: Real-time Usage in SQL Server
  • DDL Triggers and DML Triggers
  • Automations with Triggers: DML,DDL
  • INSERTED, DELETED Memory Tables
  • Table Data Replication using Triggers
  • System Objects for Listing Triggers
  • Recompilations with Triggers - Cautions

Ch 14: Tuning 2 - Indexes, Partitions

  • Indexes: Architecture and Index Types
  • B Tree Structure, IAM Page [Root]
  • Clustered & NonClustered Indexes
  • Included, Columnstore, Online
  • Filtered, Covering, Indexed Views
  • Fill Factor and Pad Index Options
  • Query Store - Settings and Advantages
  • PARTITIONS : Advantages, Performance
  • Partition Functions & Partition Schemes
  • Partitioning Un-partitioned Tables: GUI
  • Partition Compression : ROW and PAGE
  • Auditing Table Partitioned Structures
  • Statistics : Purpose, Auto Creation, Audits
  • NUMA Nodes, Processor, IO Affinity

Ch 22: Clusters & AlwaysOn [Overview]

  • Detailed Implementation @ Ch 34, 35
  • Windows Clusters For HA and DR
  • Domain Controller (DC) Configuration
  • Active Directory (AD) Accounts, Use
  • SAN [Storage Area Network] and LUN
  • Public IP Address, Private IP Address
  • Windows Level Clusters, MSCS Service
  • Active-Active, Active-Passive Clusters
  • Always On Availability Group [AOAG]
  • Synchronous and Asynchronous Modes
  • Synchronization, Automated Seeding
  • Data Synchronization for AOAG
  • Backup Preferences, Location Options
  • Detailed Implementation @ Ch 34, 35

Ch 7: Transactions, Lock Management

  • Linked Servers and Real-time Usage
  • Creating Linked Servers in SQL Server
  • Security Options and Access Options
  • Remote Data Access RPC Settings
  • RPC Out, Remote Login Credentials
  • Transactions : Types, ACID Properties
  • Transaction Types and AutoCommit
  • EXPLICIT & IMPLICIT Transactions
  • COMMIT and ROLLBACK Statements
  • Lock Hints: READPAST, NOLOCK
  • LOCKS : Types and Isolation Levels
  • S, X, IX,U, MD, Sch-M and Sch-S
  • Lock Audits : SP_WHO2, SP_LOCK
  • Deadlock Audits and Deadlock Graphs

Ch 15: Tuning 3 - INDEX MANAGEMENT

  • Working with Indexes and Partitions
  • Internal and External Fragmentation
  • Index Rebuilding Process and Audits
  • Database Maintenance Plans Jobs
  • Last Used, Page Count, Fragmentation
  • Degree Of Parallelism [DOP] Settings
  • Resumable Indexes: ONLINE, RESUME
  • Tuning Tools : Workload Files, Trace Files
  • Profiler Tuning Template, SP Events
  • DTA, Profiler Trace : Recommendations
  • Perfmon Tool Counters, Realtime Tracking
  • Execution Plan Analysis and Internals
  • Query Costs: IO Cost and CPU Cost
  • Query Costs: SubTree & Operator Cost

Ch 23: ROUTINE SQL DBA ACTIVITIES

  • Audit Login Failures : Server Logs
  • Monitoring Connectivity Issues
  • Database Refresh and MSDTC
  • Adhoc Memory Dump Files
  • PLE (Page Life Expectancy) Issues
  • Object Refresh and Recompilations
  • Server Registrations and Operations
  • Lock Monitoring Operations
  • Index Management Options
  • Open Transactions, Blocking
  • Backup and HA-DR Strategies
  • DB Restores and DB Repairs
  • Online and Offline Backups - Issues
  • Port Level Issues and Solutions

Ch 8: Server, DB Architecture

  • Server Architecture and Protocols
  • Database Engine and Query Processor
  • Parser, Optimizer, SQL & DB Manager
  • Storage Engine Components, SQL OS
  • File Manager and Database Files
  • Transaction Services, Buffer Manager
  • Lock Manager, IO Manager, MDAC
  • CLR, WAL, Lazy Writer, Checkpoint
  • Database Architecture - Data Files
  • Database Architecture - Log Files
  • Primary (mdf), Secondary Files (ndf)
  • Filegroups Usage, ReadOnly Filegroups
  • Database Files: Size and Location
  • Pages, Extents. Uniform, Mixed Extent

Ch 16: Health Checks, Issues, Solutions

  • Alerts : Creation and Notifications
  • DB Suspect Event Alerts (023)
  • Important Perfmon Counters, Alerts
  • Log Space, Memory, Tempdb Alerts
  • Scheduling Alerts & Notifications
  • DBCC CHECKDB : DB Health Checks
  • Allocation Errors, Consistency Errors
  • DBCC ShowContig, Extent Fragmentation
  • Trace Flags and Page Restores
  • DBCC Page: GAM, SGAM and PFS
  • Consistency Errors : Cause & Solutions
  • Allocation Errors : Cause and Solutions
  • Log Space Issues and Log Rebuilds
  • Memory & TempDB Issues, Solutions

Ch 24: EMERGENCY DBA ACTIVITIES

  • Server Down Issues and Solutions
  • Database Down Issues and Solutions
  • Data Missing Issues and Solutions
  • Hot CPU and Resource Allocations
  • Health Checks, Issues, Solutions
  • Automated Backups, Log File Readers
  • Ticketing Tools : SLA & OLA Concepts
  • Incident Management and Ticketing
  • Immediate, High and Medium Priority
  • Levels of Support for Production DBA
  • Licensing and Pricing Options
  • Versions, Editions Comparisons
  • 3rd Party Tools: Real-time Use
  • 3rd Party Tools: Dell Litespeed, Usage

Ch 25: CLOUD INTRO, AZURE CONFIG

  • Introduction to Cloud & Advantages
  • Cloud Architecture: IaaS, PasS and SaaS
  • Microsoft Cloud Advantages, Azure Platform
  • Azure Products and Services - MarketPlace
  • Database Implementations in Azure Platform
  • Comparing PaaS and IaaS Implmentations
  • Paas Implementations For SQL Server
  • IaaS Implementations For SQL Server
  • Logical, Virtual Machine, Managed Instance
  • Installing SSMS and Azure Data Studio
  • Azure Account and Free Subscription
  • Azure Resources: Resource Groups Usage
  • Azure Active Directory: User & Groups
  • Azure Active Directory Authentication

Ch 29: XEL, STRETCH DATABASES

  • SQL Traces : Creation and Audits
  • Event Class, Category, Filter, Conditions
  • Extended Events, Target, Action, Session
  • TSQL, SP Debug Events with Global Fields
  • Catalog & Dynamic Management Views
  • XE Profiler - Templates for Event Profiling
  • Comparing XE Profiler with SQL Profiler
  • Azure SQL Database with On-Premise
  • Stretch Databases Tuning Benefits, Cautions
  • Table Migrations with Azure SQL Databases
  • Compute Performance Levels, DSU Pricing
  • Data Storage, Azure Database Snapshots
  • Remote Data Archive Configuration in Azure
  • Database Master Key, Cold Data Migration

Ch 33: POWERSHELL, AZURE VMs

  • Azure Virtual Machines : Deploy, Configure
  • Configure Windows Server, Redhat Linux
  • Azure Storage Blades and Pricing Options
  • Azure VM - Settings, Access & DB Creation
  • On-Premise & Azure VMs: Similarities
  • SQL Server Instance, Agent in Azure VM
  • Azure SQL Database in VM to SQL Cloud
  • Azure SQL Database in VM to on-Prem
  • Deployment Automation Scripts in Azure
  • Azure Cloud Shell - PowerShellGet
  • Power Shell Scripts for Configurations
  • Power Shell Scripts for Job Schedules
  • Power Shell Scripts for Firewall, ARM
  • Azure CLI - Purpose, Real-time Use

Ch 26: AZURE SQL SERVER CONFIG

  • Installing SSMS and Azure Data Studio
  • Azure Account and Free Subscriptions
  • Azure SQL Server (Logical Server)
  • Azure SQL Server Logical Server Firewall
  • Firewall Rules - IP for Remote Access
  • Server Properties and Status Format
  • Password Resets in Azure SQL Server
  • Azure SQL Databases & Pricing Tiers
  • Azure SQL Database Access from SSMS
  • Elastic Scaling with Azure Databases
  • General Purpose and Business Critical
  • Basic, Standard and Premium Plans
  • vCore Based Purchasing : Gen 4, Gen 5
  • Resource Groups For Azure SQL Server

Ch 30: ALERTS, BACKUPS / RESTORES

  • Azure SQL Server Activity Log and Options
  • Events, Operations and Event Categories
  • Quick Insights from Events and Filters
  • Events Exports to Event Hub, Log Analytics
  • Log Analytics Workspace, Alert Rules
  • Email / SMS Notifications and Schedules
  • Log Analytics Settings and Azure Storage
  • Activity Logs and Audit Reports, Insights
  • Azure SaaS Notifications System Options
  • Automated Backups in Azure SQL Database
  • Long Term, Automated Backup Retentions
  • Backups - Retentions, Audits. LTR Policy
  • Restore Points and Database Recovery
  • Geo-Redundant Backups and Restores

Ch 34: Windows Clusters with Azure VM

  • Windows Clusters For HA and DR
  • Virtual Networks, Subnets and Ips
  • Availability Sets and Availability Zones
  • Fault Domains and Update Domains
  • DC Deployment & Configurations
  • Active Directory Domain Services
  • SAN [Storage Area Network] and LUN
  • DNS Server, DSRM and Private IP
  • Windows Level Clusters, MSCS Service
  • Active-Active, Active-Passive Clusters
  • DNS Tools, Actions & Adding AA Hosts
  • SQL Clustering Service & RAID Levels
  • SQL Cluster Groups, Domain Accounts
  • Quorum and MSDTC Disks. LUN Grows

Ch 27: ELASTIC DTUs, MIGRATION

  • Azure Storage: Creation & Containers
  • LRS, GRS and RA-GRS Storage Accounts
  • Storage Containers, Storage Explorer Tool
  • Data and Database Migration in Azure
  • Data Migration Assistant (DMA) Tool
  • DB Migrations To Azure SQL Databases
  • Database Exports and Imports in Azure
  • Migration Scopes: Schema and Data
  • Schema Generation, Migration Compatibility
  • Data Migration Verification and Row Counts
  • DTU: Data Transaction Unit and Resources
  • Bounding Box Model, Elastic Pool Queries
  • eDTUs, Elastic Pool. Per Database Settings
  • Performance Recommendations in Azure

Ch 31: HA - DR : Geo Replication, DB Sync

  • Failover Groups, Active Geo-Replication
  • Read-Write Policy & Automated Failover
  • Geo Replication Configuration in Azure
  • Primary-Secondary and Read / Write Modes
  • GeoReplication Monitoring, Forced Failover
  • Azure Server Failover Process, Strategies
  • Automated, Manual and Forced Failover
  • Backup Errors, Geo Replication Errors
  • SQL Data Sync Service and Sync Groups
  • HUB, MEMBER and SYNC DATABASE
  • Sync Direction, Sync Schema, Sync Interval
  • bi-directional Load Balancing and Failover
  • Conflict Resolutions with HUB, MEMBER
  • Cloud to Cloud, OnPremise Synchronization

Ch 35: Always-On in SQL Server Clusters

  • SQL Server VMs and File Share Witness
  • Joining Machines to Domain Network
  • Install Accounts to Active Directory
  • Install Failover Cluster (FCI) Features
  • Firewall Configurations, Port Exceptions
  • FSW File Shares and Usability Options
  • Need for Always - On Availability (AAG)
  • Always On Availability Group [AOAG]
  • Multi-Database Replication Options
  • Backup Preferences, Automated Seeding/li>
  • Synchronous and Asynchronous Modes
  • Data Synchronization for AOAG
  • AOAG Dashboards & Automated Failover
  • Need for Azure Managed Instances

Ch 28: AZURE SQL DATABASE TUNING

  • Azure SQL Server Level Tuning Options
  • Azure SQL Database Level Tuning Options
  • Automated Tuning Options and Peak-Loads
  • Force Plan, Create Index and Drop Index
  • Performance Insight and Recommendations
  • IO Metrics, CPU Metrics & Query Statistics
  • Data File IO, Log File IO, Custom Reports
  • Query Audits with Query IDs, Dashboards
  • DTU Usage Reports and Elastic Queries
  • Query Recommendations, Query Costs
  • Azure Search Service and Pricing Tiers
  • Azure Search for Data Import. Indexer
  • Suggester and Analyzer Modes for Tuning
  • Retrievable, Facetable, Facetable Indexes
  • Filterable and Searchable Indexes
  • Change Tracking & Watermark Columns

Ch 32: SECURITY MANAGEMENT, RLS

  • Firewall and Virtual Network Configurations
  • Server Firewall, Database Firewall Rules
  • System Procedures for Firewall Settings
  • Logins, Users, Roles Permissions @ T-SQL
  • Creating Users without Logins. Containment
  • GRANT, DENY, REVOKE, WITH GRANT
  • Role Level and Schema Level Security
  • Threat Detection, Transparent Data Encryption
  • Vulnerability Assessment, Data Masking
  • Implementing RLS - Row Level Security
  • Creating Users with and without Logins
  • Using SECURITY Schema for RLS Functions
  • Creating Security Predicates and Filters
  • Security Policies for Row Level Security
  • EXECUTE AS option & STATE for RLS
  • Dynamic Data Masking with Azure SQL DB

Ch 36: Azure SQL DBA Project & DP 300 Exam

  • Real-time Project For your Resume
  • DP 300 Microsoft Examination Guidance
  •  
  •  

Ch 37: 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 41: Azure MI - Tuning Concepts

  • 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

Ch 45: 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, Transactional and Merge
  • Push and Pull Subscriptions in Azure MI
  • Replication Agents: Snapshot, LogReader
  • Distribution Agent. Push / Pull Models
  • Replicating Azure MI with Azure VM
  • Create Distributor, Publication in Azure MI
  • Creating Subscriptions in Azure MI
  • Data Sync Verification; Alerts / Warnings

Ch 38: 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 42: 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 @ Security
  • Disable/Enable Encryptions with Backups

Ch 46: 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
  • 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 39: Azure MI Connections From VM

  • 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 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 43: 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
  • Memory Consumption, Server Dashboards

Ch 47: 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

Ch 40: 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 44: 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 Encrypted, Key Management, VA
  • Creating Logins, Users, Roles. Privileges

Ch 48: 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 Compatibility
  • Performance Tuning Comparisons
  • Detach and Attach Options in Azure MI
  • 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 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