In this episode of Data Exposed with Sasha Nosov, learn how Azure Arc allows you to leverage Azure Services for your existing database applications hosted on-premises or in other public clouds, without changing or even stopping them.

Content & Time Stamps:

  • 0:00 Introduction
  • 0:45 What is Azure Arc
  • 2:30 About Azure Arc Enabled SQL Server
  • 3:03 Architecture of Azure Arc Enabled SQL Server (Public Preview)
  • 8:09 Environment Health Demo
  • 13:18 Azure Arc Enabled Data Services vs Azure Arc Enabled SQL Server
  • 17:00 What versions of SQL Server are supported
  • 17:45 Getting started & registering for Azure Arc enabled SQL Server

Learn the differences between the Basic, Standard, and Premium tiers of Azure SQL Single Database.

Provisioning is one component of maximizing the value of your deployment – licensing is another.

In this video with Matt Gordon, take a walk through the differences between licensing by DTU and by vCore and talk about what may be right for you and your needs.

Linked servers enable the SQL Server and Azure SQL Database Managed Instance to read data from remote data sources and execute commands against the remote database servers.

In this video, Anna Thomas and Colin Murphy go over configuring linked servers in Azure SQL Database Managed Instance.

At the end, Anna briefly mentions creating a linked server to the readable secondary replica for read-heavy workloads.

Capacity planning plays a critical role in migrating an existing application or designing a new one. In the final part of this three-part series with Silvano Coriani, we’ll review various Azure SQL capacity planning scenarios, as well as review best practices and recommendations on what to use when. 

Time index:

  • 0:00 Introduction
  • 1:26 Greenfield development scenario
  • 5:42 Existing applications on-prem or other clouds scenario
  • 7:42 On-prem demo
  • 12:01 Changes in existing Azure SQL DB apps scenario

Microsoft Developer

In this episode of Data Exposed with Vladimir Ivanovic, he announces a set of major performance improvements for Azure SQL Managed Instances, which enable customers to migrate their more performance-hungry database workloads to Azure SQL Managed Instance.

These improvements are automatically enabled for all existing and future Azure SQL Managed Instances at no extra charge, making Azure SQL Managed Instance the best fully-managed database platform for mission-critical workloads.

Time stamps:

  • 0:00 Introduction
  • 0:58 Azure SQL Managed Instance Performance Improvements
  • 1:45 Improved log rate for SQL MI General Purpose
  • 2:40 Improved log rate for SQL MI Business Critical
  • 3:55 Pricing
  • 4:30 Opportunities
  • 5:22 Improvements are available now!

Resources:

  • Azure SQL Managed Instance Resource Limits: https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?WT.mc_id=dataexposed-c9-niner
  • Service Tier Characteristics: https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits#service-tier-characteristics

In the conclusion to this two-part series with Allan Hirt, learn how Azure can be used to create disaster recovery solutions for your on premises Microsoft SQL Server instances and databases through the use of built-in availability features of SQL Server. 

Index:

  • 0:00 Introduction
  • 1:22 Built in hybrid disaster recovery options overview
  • 2:22 Hybrid Log Shipping
  • 4:27 Hybrid “Normal” Availability Group
  • 7:34 Hybrid Distributed Availability Group
  • 11:55 Hybrid Failover Cluster Instance

Microsoft added several features to SQL Server 2019 that can improve performance without changes to code.

One of these is T-SQL Scalar UDF Inlining.

The use of UDFs is a red flag when tuning queries, but, in some cases, the engine will treat these as if the underlining code was added directly to the select statement.

Tune in to this session with Kathi Kellenberger to see when this new feature will help, and, more importantly, when it won’t.

Content index:

  • 0:00 Introduction
  • 1:10 What are UDFs?
  • 1:47 Performance Issues
  • 2:30 UDF Scalar Inlining
  • 3:15 Demos
  • 11:40 Control when inling is used

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