In this video, you will learn how to deploy recommended HADR architectures using SQL Server on Azure Virtual Machines with an optimal TCO using your Software Assurance Benefits.[00:00] Intro[00:31] Recap of previous episode[00:48] Architectures for SQL Server on Azure SQL VMs[01:24] HA/DR benefits for SQL Server on Azure SQL VMs[02:10] Architecture using Azure SQL VMs with HA/DR benefits since November 2019[03:02] Operations allowed on passive replicas[04:06] Summary Learn more at https://aka.ms/sqlserver2019licenseguide?WT.mc_id=dataexposed-c9-niner and https://techcommunity.microsoft.com/t5/sql-server/optimize-tco-with-new-sql-server-software-assurance-benefits-for/ba-p/1123731?WT.mc_id=dataexposed-c9-niner.

In this video, you will learn how to deploy recommended HADR architectures using Azure as a DR center with the best TCO using Software Assurance.[00:00] Intro[00:31] Licensing for HA/DR when using Azure as a disaster recovery site[01:42] Operations allowed on secondaries[02:01] Architecture with Azure for disaster recovery[03:30] Setting up an Azure SQL VM for disaster recovery[04:38] Summary Learn more at https://aka.ms/sqlserver2019licenseguide?WT.mc_id=dataexposed-c9-niner and https://techcommunity.microsoft.com/t5/sql-server/optimize-tco-with-new-sql-server-software-assurance-benefits-for/ba-p/1123731?WT.mc_id=dataexposed-c9-niner.

In this video, you will learn how to deploy recommended HADR architectures with the best TCO using Software Assurance.[00:00] Intro[00:32] Reminder of benefits for HA/DR[01:11] Common scenarios[02:14] Operations allowed on passive secondaries[03:28] Operations not allowed on passive secondaries[03:49] Application of SA benefits in more complex setup[05:50] Summary Learn more at https://aka.ms/sqlserver2019licenseguide?WT.mc_id=dataexposed-c9-niner and https://techcommunity.microsoft.com/t5/sql-server/optimize-tco-with-new-sql-server-software-assurance-benefits-for/ba-p/1123731?WT.mc_id=dataexposed-c9-niner.

In this video, you will learn how you can get a better TCO for recommended SQL Server HADR architectures with your Software Assurance benefits. [00:00] Intro[00:30] Deploying SQL Server in High Availability / Disaster Recovery configuration[01:36] HA and DR benefits introduced in November 2019[02:15] Applying HA / DR benefits to typical HA/DR configuration[04:22] Contrasting licesing before and after November 2019[04:59] Application to older versions of SQL Server and various architectures[05:31] SummaryLearn more at https://aka.ms/sqlserver2019licenseguide?WT.mc_id=dataexposed-c9-niner and https://techcommunity.microsoft.com/t5/sql-server/optimize-tco-with-new-sql-server-software-assurance-benefits-for/ba-p/1123731?WT.mc_id=dataexposed-c9-niner.

In this video, you will learn about how to license a Big Data Cluster in SQL Server 2019. The video also talks about the Software Assurance benefits that are available for Big Data Cluster deployments.[00:00] Intro[00:30] What is SQL Server big data cluster?[01:45] Architecture for big data cluster and benefits[03:33] Licensing SQL Server big data cluster[04:40] Scaling out (expanding horizontally)[05:27] Benefits of Software Assurance for big data cluster licensing[07:59] SummaryLearn more at: https://www.microsoft.com/en-us/sql-server/sql-server-2019 and https://techcommunity.microsoft.com/t5/sql-server/optimize-tco-with-new-sql-server-software-assurance-benefits-for/ba-p/1123731?WT.mc_id=dataexposed-c9-niner.

Persistent Log Buffers, sometimes referred to as tail of log caching, uses persistent memory to persist the database log buffer, eliminating bottlenecks that may occur on busy systems waiting for the log buffer to flush to disk. A process known as log hardening. learn more here: https://docs.microsoft.com/en-us/sql/relational-databases/databases/add-persisted-log-buffer?view=sql-server-ver15 [00:00] Intro[00:45] Positioning persistent log buffer[01:13] Persistent memory (PMEM) devices[01:58] Usecase for and benefits of persistent log buffer[02:31] Best practices for SQL Server with PMEM in Windows[03:38] Best practices for SQL Server with PMEM in Linux[04:01] What is persistent log buffer?[04:43] What is forced delayed durability?[05:30] Difference between persistent log buffer and forced delayed durability[06:42] Demo: setting up persistent log buffer[07:54] Wrap-up

You may have heard about SQL Notebooks in Azure Data Studio, now you can get started creating your very first SQL notebook. In this video, you will learn how to use text and code cells to build an interactive document experience. In addition, we will show you some basics to edit your SQL notebook. Learn more about SQL Notebooks here: https://docs.microsoft.com/sql/azure-data-studio/sql-notebooks?view=sql-server-ver15&WT.mc_id=dataexposed-c9-niner. [00:00] Introduction[00:27] Notebooks definition[00:50] Notebooks in Azure Data Studio, including SQL kernel[02:00] Tutorial: using Notebooks in Azure Data Studio[05:33] Next steps[06:02] Wrap-up

We'll talk about what is Spark and using it in Big Data Clusters.More info: https://docs.microsoft.com/en-us/sql/big-data-cluster/tutorial-data-pool-ingest-spark?view=sql-server-ver15 [00:00] Introduction[00:30] One-sentence definition of Spark[00:47] Storing Big Data[01:44] What is Spark?[02:35] Language choice[03:27] Unified compute engine[04:57] Spark with SQL Server[05:47] Learning more[06:10] Wrap-up

In this video we are going through the high availability options you have for the mission critical services running within the SQL Server Big Data Clusters. Find out more here: High AvailabilityHigh Availability for HDFS and Spark[00:00] - Introduction[01:00] - Storage recap for Big Data Clusters[02:47] - High Availability options[04:34] - High Availability for SQL Server master instance[06:18] - Availability Groups in Big Data Clusters[07:07] - High Availability for HDFS[07:51] - High Availability for Spark[08:27] - Demo: configuring High Availability in Big Data Clusters[10:55] - Getting started[11:25] - Summary and wrap-up

In this video, we'll discuss Accelerated Database Recovery, and how it can solve many availability challenges with no operational or application changes. Find out more about ADR in our documentation. [00:00] - Introduction[00:40] - What is Accelerated Database Recovery (ADR)[01:36] - The current SQL Server Database Recovery process[03:00] - Database Recovery process with ADR[04:58] - Benefits of ADR[06:00] - Enabling ADR[07:02] - Truncating transaction log strategy with ADR[07:44] - Summary and wrap-up