Azure SQL Server for Beginners part 2 of 2

Explore Azure SQL Server fundamentals in part 2, covering security, Azure Active Directory login, encryption, auditing, alerts, geo-replication, always on, monitoring, elastic jobs, linked servers, and elastic queries.

Explore Azure SQL network security by configuring server and database level firewalls, IP rules, and T-SQL controls to securely grant access while avoiding overly permissive Azure services.

Learn to configure Azure SQL firewall rules at both server and database levels using T-SQL, restricting access to only the pro two database while disabling server-wide access and managing rules.

Set up an Azure virtual network to secure access to an Azure SQL database, linking two virtual machines to demonstrate firewall rules and VNet connectivity.

Learn to create Azure Active Directory users and use MFA for secure access to Azure SQL Server, comparing Azure AD logins with traditional SQL authentication.

Learn to create logins and users to access Azure sql server and databases, assign server and database roles (login manager, db manager), and map logins to master and user databases.

Learn to create logins and users, define roles, and grant granular read, write, and crud permissions to specific tables in Azure SQL, scalable for many users.

Learn to connect to Azure SQL Server using Azure Active Directory with multi-factor authentication, create and administer Active Directory users, enable MFA, and designate an AD administrator.

Discover how transparent data encryption (TDE) protects data at rest in Azure SQL databases and managed instances by encrypting the database and backups with a DEK, master key, and certificate.

Explore how to implement transparent data encryption with custom managed keys in azure sql, create a vault and key, and securely copy and restore databases between servers.

Learn how dynamic data masking in Azure SQL protects sensitive data by masking emails, phones, and credit cards in query results, with granular admin access and practical migration steps.

Enable auditing at server and database levels to capture events in audit logs. Analyze logs with preconfigured reports to spot suspicious activity and policy violations.

Set up azure monitor alerts for sql databases by defining scope, conditions, thresholds, and actions to trigger email notifications. learn auditing within monitoring to manage alerts effectively.

Discover how Azure Security Center provides unified security management for Azure SQL databases, virtual machines, and other resources, with Azure Defender for SQL and actionable recommendations to harden your environment.

Learn how to protect Azure SQL databases with delete and read-only locks, preventing accidental deletes or configuration changes on databases or servers, while still allowing edits under delete lock.

Learn Azure SQL database geo replication to create up to four readable secondary databases across regions, enabling manual failover and disaster resilience.

Demonstrates configuring auto failover groups for geo replication of multiple databases across regions, detailing primary and secondary setup, automatic vs manual failover, grace periods, and cost considerations.

Learn how to configure Azure SQL elastic pool geo replication using a PowerShell script, creating primary and secondary servers and a geo-replicated database with firewall setup.

Explore active site recovery for Azure SQL virtual machines, creating a secondary region replica, testing failover, and maintaining uptime with a recovery service vault.

Create a virtual machine and enable replication to a secondary region, then perform test failover and commit recovery points to demonstrate Azure Site Recovery for disaster recovery.

Explore how to set up Azure SQL Server always on in a multi-node environment, including resource group creation, virtual networks, an availability set, and domain controller configuration.

Configure forward and reverse DNS on the domain controller to prevent DNS issues when adding VMs, then prepare to create two server nodes and apply SQL Server configuration.

Configure Azure SQL Server virtual machines, creating server one and server two in an availability set and joining the domain. Verify DNS and ipconfig settings during setup.

Join two SQL Server VMs to the domain, run services as a domain user, enable Always On, configure ports 1433, 5022, 5888, and apply firewall rules.

Learn to configure Azure SQL Server Always On: set firewall inbound ports, enable failover clustering, configure prod SQL Service with domain credentials, restart services, and prepare for cluster creation.

Create an Azure SQL Server Always On cluster by validating two nodes with Failover Cluster Manager and configuring the Availability Group, preparing for a future failover test.

Set up Azure SQL Server Always On availability group across two servers, create and restore a database, perform full and transactional log backups, and test failover.

Master proactive Azure monitoring for SQL databases and VMs by configuring alerts, dashboards, and diagnostics using DMVs, Log Analytics, and query performance insights.

Learn Azure monitoring for SQL on Azure by configuring alerts for disk space and DTU utilization, and explore data migration tool migrations from on premises to the Azure platform.

Explore Azure monitoring graphs for SQL databases: create and customize metrics charts (line, area, bar, grid), pin dashboards, track deadlocks, data I/O, failed connections, and share dashboards with access controls.

Explore monitoring Azure SQL databases and managed instances with dynamic management views. Use resource stats and stress testing to identify CPU, memory, and IO performance issues.

Explore Azure SQL Database diagnostic monitoring by configuring diagnostic logs and streaming telemetry to Log Analytics, Azure Storage, or Azure Event Hubs, and leveraging SQL Insights for intelligent performance recommendations.

Set up Azure SQL Analytics to monitor SQL databases, elastic pools, and managed instances across subscriptions by configuring diagnostic settings, Log Analytics workspace, and resource groups.

Configure and monitor databases and elastic pools with Azure SQL Analytics and a Log Analytics workspace. Set diagnostic settings for each database, including blocking, and migrate data with DMA.

Monitor Azure SQL with dashboards and SQL Analytics, pin resources, and navigate CPU and blocking metrics. Manage elastic pools and databases while avoiding unnecessary charges.

Learn to create elastic jobs in Azure SQL database and distinguish from elastic pools. Use elastic job agent, target groups, and steps with T-SQL or PowerShell to run across servers.

Set up an elastic jobs environment in Azure SQL, provisioning a job server and target databases, then deploy an elastic job agent to populate the databases.

Learn to connect on-premises sql server to an azure sql database using linked servers with a 64-bit odbc connection, create an odbc data source, and query azure data.

Explore elastic queries in Azure SQL to perform cross-database data access, using external data sources and external tables to join remote data across databases.

This lecture guides you through a self-directed Azure SQL sandbox to test your ability to follow instructions, configure firewall rules, and implement Active Directory authentication and permissions.

Azure SQL databases provide a fully managed paas engine that handles upgrades, patching, backups, and monitoring. Scale with elastic pools or vcore/dtu pricing, with 99.9% availability and minimal downtime.

Explore assessing on-premises SQL and Windows server workloads for Azure migration by inventorying assets, evaluating Azure models and transfer methods, and judging feasibility.

Explore migrating on-premises SQL databases to Azure, using elastic pools to handle peak workloads, establish redundancy, and plan a hybrid cloud approach with 2014 to 2019 upgrades.

Learn how to migrate on-premises databases to Azure elastic pools using the data migration assistant, configure pricing, and deploy two SQL databases.

Migrate on-premises SQL databases to an azure virtual machine with sql server, using a storage account and url backups, while retaining control of the windows operating system.

Wrap up part two of Azure SQL for beginners by reviewing on-premises setups, Azure IaaS and PaaS options, backups, security, and monitoring. Practice repeatedly to build mastery today.