Continuing from part 1, learn why Azure SQL is the best database in the cloud for developers, dive deeper into architectures, and review customer case studies to truly understand how Azure SQL really shines. Click here to watch part one.

Video index:

  • [01:05] Data architectures applied with Azure SQL
  • [03:00] Hyperscale
  • [04:00] Demand analytics, forecasting, recommendation
  • [06:00] Easy setup
  • [07:15] Detection & security customer studies

Additional Resources:
JSON Samples
10 Reasons why Azure SQL is the Best Database for Developers
Big Red Cloud Case Study
Bing Ads Technical Blog Post
DevOps for Azure SQL Intro
Sync Mobile Apps with Azure Using Change Tracking API

Microsoft Mechanics has SQL Server guru and recent Data Driven guest, Bob Ward on to talk about Azure Migrate.

Running SQL Server on-premises and looking to move to Azure? Review your best options for assessment and migration. Bob Ward, SQL Server database expert and engineering lead, joins host Jeremy Chapman to walk through different migration options for moving your SQL Databases into the cloud, and then shows how to perform a migration end-to-end.

In this video, learn how you can get a better TCO for recommended SQL Server HADR architectures with your Software Assurance benefits.

Outline:

  • Intro
  • Deploying SQL Server in High Availability / Disaster Recovery configuration
  • HA and DR benefits introduced in November 2019
  • Applying HA / DR benefits to typical HA/DR configuration
  • Contrasting licensing before and after November 2019
  • Application to older versions of SQL Server and various architectures
  • Summary

Learn more at https://aka.ms/sqlserver2019licenseguide?WT.mc_id=franksworld and https://techcommunity.microsoft.com/t5/sql-server/optimize-tco-with-new-sql-server-software-assurance-benefits-for/ba-p/1123731?WT.mc_id=franksworld.

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.

  • [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

Here’s a great blog post on SQL Server 2019 Big Data Cluster and how it integrates Microsoft SQL Server and the best of big data open-source solutions.

Our testing demonstrates that the performance scales linearly from 1TB to 100TB datasets seamlessly and the various system resources are effectively utilized. Microsoft SQL Server 2019 Big Data Cluster leverages the high performance of Intel® Xeon® processors and Intel® SSDs to deliver great performance for complex queries. In addition, the benchmark results demonstrate powerful elasticity and performance of the entire platform.

The combination of Microsoft SQL Server 2019 Big Data Cluster and Intel’s Xeon Scalable platform can address many of your Big Data challenges. You can store and analyze data from multiple sources at scale, in various data formats, with scale-out compute for data processing and machine learning, together with the industry-leading experience of SQL Server.