In the first part of this two-part series with Hamish Watson, we will look at the various methods available to deploy an Azure SQL database including PowerShell, Azure CLI and Terraform. Creating resources has never been easier or more standard than what we have now.

Related Links:

  • 0:00 Introduction
  • 1:55 A Match Made in the Cloud Overview
  • 4:42 Demo
  • 7:10 Other ways to deploy into Azure
  • 8:22 Continuation of demo
  • 8:56 CI CD Pipeline

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

In part one of this three-part series, Vasiya Krishnan introduces Azure SQL Edge and its features that make it the optimized database engine for IoT Scenarios. In part two, Vasiya will review customer examples and use cases, and in part three, she’ll conclude with a demo that demonstrates how to use Azure SQL Edge to build smarter renewable resources.

Whether migrating an existing application or designing a brand new one, capacity planning process plays a critical role.

Learn how to navigate across Azure SQL Database options like hardware generation, service and compute tiers, and instance sizing principles, trying to find the sweet spot between performance, functionalities, and costs, in the first episode of this three-part series with Silvano Coriani.

Content:

  • 0:00 Introduction
  • 0:58 What is capacity planning
  • 2:04 Azure SQL Database dimensions to consider
  • 3:30 Deployment options
  • 4:50 Purchasing models
  • 6:25 Service tiers
  • 7:55 Compute sizes and resource limits

Are you interested in learning how to translate your existing SQL Server expertise to Azure SQL?

In this episode, Bob Ward, Anna Hoffman, and Marisa Brasile announce all-new content on YouTube, Github, and Microsoft Learn to help you become an Azure SQL professional.

To support you as you learn, you can join Bob & Anna in four-day series of live sessions: aka.ms/azuresqlbootcamp

Start learning Azure SQL today:

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

One of the major benefits of Azure SQL Database is that the Azure platform provides additional protection for your database against SQL Injection attacks and Data Exfiltration, amongst other threats.

Join Joey D’Antoni as he shows you how to configure Advanced Threat Protection, and some of the protections it offers.

Video index:

  • [01:37] What is Advanced Threat Protection?
  • [02:46] Microsoft Azure Configuration
  • [03:36] Advanced Threat Protection types
  • [04:48] Enable auditing
  • [05:19] Tracking alerts