Azure SQL Server for Beginners part 1 of 2

Introduce beginners to managing Azure SQL databases, covering the Azure SQL Database family, elastic pools, virtual machines, and managed instances, with emphasis on cost awareness and prerequisites.

Explore the on premises environment—physical server rooms, hardware, and IT staff managing servers and costs—and evaluate migrating to Azure, including emulating on premises with SQL Server 2019 Developer Edition.

Install the SQL Server 2019 Developer Edition, SSMS, and AdventureWorks 2019 to emulate an on premises environment, following download, install, and restore steps.

Install SQL Server Management Studio (SSMS) and restore the AdventureWorks database on SQL Server. Learn how to connect, manage backups, and migrate databases between on-premises and Azure.

Explore how to install and open Azure Data Studio, connect to on-premises SQL Server and Azure cloud, and prepare the environment for managing SQL resources.

Create a Microsoft and Azure account to access the Azure portal and start with $200 credit for 12 months of free services; explore sql databases, storage, and the dashboard.

Explores quiz one on learning SQL on Azure, answering true or false with reasons about Azure portal access, Azure Studio, SQL Server 2019 Developer edition, and production versus testing use.

Explore Microsoft Azure and cloud services that host SQL databases and other resources. Learn benefits like migrating on-premises hardware to the cloud, scaling resources, and reducing upfront costs.

Explore Azure cloud computing models: infrastructure as a service, platform as a service, and software as a service, and how migration from on premises to Azure shapes control and costs.

Explore Azure SQL models by comparing IaaS and PaaS, detailing singleton databases, elastic pools, and managed instances, plus migration considerations and pricing tiers.

Compare the DTU and VCore pricing tiers in Azure SQL, and learn how elastic pools share resources to optimize costs.

Explore quiz two on azure sql to choose between IaaS, PaaS, and SaaS, decide database, VM, or managed instance options, and review DTU vs vCore pricing and elastic pools.

Connect to on-premises sql server via ssms. Compare it with azure sql databases and learn that azure databases are self-contained, isolated containers; practice creating, using, and querying a prod database.

Learn to navigate the Azure portal, access and create SQL databases on Azure, and manage SQL databases, managed instances, and SQL Azure VMs through intuitive dashboards.

Create a SQL database in Azure by selecting a subscription, creating a resource group and server, configuring admin login and location, then choosing a basic to standard tier.

Create a second Azure SQL database and connect it from on-premises using SSMS and the Azure portal. Learn per-database hourly pricing, firewall rules, and self-contained nature of Azure SQL databases.

Learn to automate Azure SQL database provisioning using PowerShell scripts, including connecting to Azure, creating resource groups and logical servers, configuring firewall rules, and deploying databases with pricing tier.

Create Azure SQL databases in one step with a PowerShell script that provisions a resource group, a logical server with firewall, and a database at a standard pricing tier.

Tackle quiz three to learn creating an Azure SQL database with default settings, why the use statement fails, and how dtus pricing affects charges.

Navigate the Azure SQL database page to explore resources, edit columns, view activity logs, and manage pricing, geo replication, and connections for Azure Data Studio integration.

Deploy SQL Server on Azure virtual machine as an IaaS solution, gaining OS control, flexible licensing, and pay-as-you-go management; use developer edition for testing and configure backups and availability options.

Deploy and connect to an Azure virtual machine, install SQL Server and SSMS, and manage a full SQL Server on Azure IaaS with RDP access and cloud-managed patching.

Discover cost-saving steps for Azure SQL Server on VM by stopping the VM, deallocating, deleting the resource group, and setting auto shutdown, with a look at PowerShell recreation.

Deploy a virtual machine and provision a SQL server on Azure using PowerShell commands, while tracking costs and deleting resources to avoid charges.

Explore Azure SQL elastic pools to share DTUs across many databases, reduce costs with no per-database charges, and use auto scale with DTU or VCore models.

Explore how three Azure SQL databases are created and migrated into an elastic pool. Observe the cost savings and DTUs configuration.

Explore how to set up an Azure SQL managed instance in a dedicated subnet, including storage account creation, networking, budget alerts, and access via a jump box.

Learn to deploy and manage an Azure SQL managed instance via PowerShell or GUI, access via a jump box and SSMS, and assess on-premises migrations.

Learn to monitor and control Azure cost with cost analysis and budgets for SQL resources. Create budget alerts scoped to a subscription or resource group to prevent overspending.

Use the Azure SQL Database calculator to determine the best DTU or vcore model by collecting on-premises performance data and testing with a SQL stress utility to guide migration decisions.

Explore migrating on-premises databases to Azure SQL Database using the Data Migration Assistant and Azure Data Migration Service, considering downtime, licensing, and deployment models.

Export your on-premises database to Azure SQL Database with SSMS using the Deploy Database to Microsoft Azure SQL Database wizard, and verify the exported tables in Azure.

Quiz four covers how Azure SQL charging works, elastic pools, and migration tools for on-prem to Azure, including the data migration tool and data migration service, in a test environment.

export the on-premises database to an Azure backpack file with the export data tier application, then import the backpack into Azure SQL using the portal and storage blob.

Migrate on-prem data to Azure SQL by exporting with BCP and executing BCP commands from the SQL pane to move text or CSV files to Azure databases.

Learn to migrate multiple onprem databases to Azure elastic pools using PowerShell, moving databases between pools and to a standalone Azure SQL database with hands-on scripting.

Azure automatically backs up SQL databases with weekly full backups, differentials, and frequent log backups for restores; retention ranges seven to 35 days, and long-term backups up to ten years.

Explore how Azure SQL Database backups work, including weekly full backups, differential backups, and log backups, with configurable retention and the cost of point-in-time restores.

Learn how to restore a deleted Azure SQL database, navigate deleted databases, review and restore, and avoid ongoing costs by deleting resources after restoration.

Learn to back up an on-premises SQL Server to Azure storage via a credential and access key, then restore to on premises using a different database name, navigating blob leases.

Back up and restore a database on an Azure VM using a shared access signature token, with storage container, credential, and restricted access.

Learn to back up multiple SQL databases across Azure VMs using Recovery Services Vault, enabling centralized monitoring, soft delete, and cross-region restore with geo or local replication.

Learn to set up a Recovery Services vault, enable local redundancy, and back up multiple SQL Server databases across VMs with an hourly log and daily full backup policy.

Explore Azure SQL backup policies and retention schedules, including full, differential, and log backups, and learn how to delete vaults and unregister resources to control costs.

Create a resource group, a virtual machine, and a recovery vault to restore an Azure SQL database from VMs in vault, and migrate on premises data with the wizard.

Master security, disaster recovery, and performance monitoring in Azure SQL Administration part two, covering network and server security, Azure AD authentication, encryption, Always On, and geo-redundant backup strategies.