Davide Mauri joins Scott Hanselman to discuss a recently announced feature of Azure SQL DB that makes integration with REST APIs incredibly easy. A new system function enables Azure SQL DB to call any HTTP REST API securely: call an Azure Function, send a message to Event Hub, execute a DAX query in Power BI, enrich data with Cognitive Services, etc. Chapters 00:00 - Introduction 02:15 - Background discussion 06:21 - Demo 1: Calling an Azure Function 10:02 - Demo 2: Query a GraphQL service 12:05 - Demo 3: Update a page in real time with SignalR 15:05 - Demo 4: Power BI executeQueries 17:20 - Demo 5: Event Hub 19:05 - Wrap-up 19:41 - Bonus demo: Cognitive Services Recommended resources sp_invoke_external_rest_endpoint (Transact-SQL) (Preview) Azure-Samples/azure-sql-db-invoke-external-rest-endpoints Azure SQL Database Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Davide Mauri | Twitter: @MauriDB Azure SQL | Twitter: @AzureSQL Azure Friday | Twitter: @AzureFriday Azure | Twitter: @Azure

It's crucial to test recent changes before rolling them out to production, especially for mission-critical workloads. You want to be sure that the system is resilient after the latest code update. Combined with load testing, you can be confident that the system will maintain the expected performance. Heyko Oelrichs and Martin Šimiček join Scott Hanselman to show how integrating automated tests early in the development process will enable you to deploy new releases with high quality. Chapters 00:00 - Introduction 02:30 - Continuous validation 05:30 - Demo setup 09:09 - Demo outcome 13:27 - Azure Front Door 15:27 - Resources Recommended resources Mission-critical workloads Continuous validation with Azure Load Testing and Azure Chaos Studio Getting started guide on GitHub Azure Mission-Critical Online Reference Implementation Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Azure Friday | Twitter: @AzureFriday Azure | Twitter: @Azure Azure Architecture | Twitter: @MSPnP

Mainframe and midrange systems have been at the core of many organizations for their mission-critical workloads. Cristina Potra joins Scott Hanselman to talk about how these systems can be migrated to Azure with the migration frameworks, partners, and expertise. Learn about modernization complexities, strategies, and documentation to cater to every unique customer's needs. Chapters 00:00 - Introduction 02:35 - Modernization Journey Roadmap 08:12 - Modernize mainframe and midrange data 10:11 - Guidance 12:20 - Wrap-up Recommended resources Mainframe migration overview Azure mainframe and midrange architecture design Modernize mainframe and midrange data Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Azure Friday | Twitter: @AzureFriday Azure | Twitter: @Azure For more information, please contact legacy2azure@microsoft.com

The cloud costs money and you want to control that. Barry 'Azure Barry' Luijbregts and Scott Hanselman cover what things cost money in the cloud, how to analyze and track costs, and practical tips to reduce costs to help manage your cloud spending. Chapters 00:00 - Introduction 01:00 - What costs money in the cloud? 06:43 - Managing costs 12:23 - Reporting costs 15:14 - Reducing costs 25:09 - Wrap-up Recommended resources Optimize your Azure costs Use Azure Spot Virtual Machines Cost Management + Billing documentation Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Azure Barry | Twitter: @AzureBarry Azure Friday | Twitter: @AzureFriday Azure | Twitter: @Azure

Drew Skwiers-Koballa shows Scott Hanselman a new option for developing with Azure SQL Database: The Azure SQL Database emulator, which is a containerized database for a desktop dev experience. Use your favorite client OS and dev tools for cloud development without the cloud. Chapters 00:00 - Introduction 02:54 - Modern microservices-demo application overview 04:10 - Database Projects and Integration with VS Code 15:43 - Deployment using GitHub Actions 18:46 - Wrap-up Recommended resources What is the local development experience for Azure SQL Database? Introducing the Azure SQL Database emulator (preview) SQL Database Projects extension (Preview) Download and install Azure Data Studio Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Drew Skwiers-Koballa | Twitter: @SysAdminDrew Azure SQL | Twitter: @AzureSQL Azure Friday | Twitter: @AzureFriday Azure | Twitter: @Azure

Have you ever tried to deploy to Azure with ARM templates, but found them too difficult or overwhelming to learn? Alex Frankel joins Scott Hanselman to show how Bicep—an abstraction on top of ARM templates—gives you all the same power and flexibility, but in a modern, safe, declarative language. Chapters 00:00 - Introduction 03:30 - Demo - a Bicep file from scratch 16:15 - Demo - transpiling with az bicep build 19:40 - Demo - adding a parameter for a name prefix 23:40 - Demo - unplanned debugging activity 25:55 - Demo - back on track 28:00 - Demo - a few more features 35:22 - Wrap-up Recommended resources What is Bicep? Azure / bicep on GitHub Comparing JSON and Bicep for templates Frequently asked questions for Bicep Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Alex Frankel | Twitter: @ADotFrank Azure Friday | Twitter: @AzureFriday Azure | Twitter: @Azure

Amar Gowda joins Scott Hanselman to show how Azure Confidential Computing protects data in use and helps you achieve data security and data privacy goals within a managed cloud environment. Confidential VM's protect VM-based workloads with memory encryption and code integrity for VM and container workloads. Attestation helps you remotely verify the entire VM is a hardware-based Trusted Execution Environment (TEE). Chapters 00:00 - Introduction 01:20 - Azure Confidential Computing 04:00 - Creating a confidential VM from CLI demo 06:28 - Attestation sample client to verify hardware 12:00 - Extensions and CVM on AKS support 13:09 - AKS demo 20:00 - Wrap-up Recommended resources Azure confidential computing Azure Confidential Computing Blog Azure Confidential Computing customer stories Azure-Samples/confidential-container-samples on GitHub Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Amar Gowda | Twitter: @amar_gowda Azure Friday | Twitter: @AzureFriday Azure | Twitter: @Azure

Azure Cosmos DB for PostgreSQL enables developers to build scalable PostgreSQL apps. Kirill Gavrylyuk and Charles Feddersen join Scott Hanselman to explain Distributed SQL PostgreSQL in Azure Cosmos DB. Chapters 00:00 - Introduction 02:12 - Azure Cosmos DB for PostgreSQL demo 09:36 - Demo loading data from Azure Storage and sharding 15:34 - Demo creating a replica for reduced latency 21:56 - Wrap-up Recommended resources Azure Cosmos DB for PostgreSQL Use Azure Cosmos DB for free Azure Cosmos DB for PostgreSQL | How it Works Create an Azure Cosmos DB for PostgreSQL cluster in the Azure portal Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Azure Friday | Twitter: @AzureFriday Azure Cosmos DB | Twitter: @AzureCosmosDB

Estefani Arroyo joins Scott Hanselman to talk about and demo Azure Cosmos DB desktop tools for developing, querying, and testing your applications. The Azure Cosmos DB Linux Emulator provides a high-fidelity emulation of the Azure Cosmos DB service. The Azure Data Studio Cosmos DB API for Mongo DB extension enables you to connect to your Mongo resources and query your data using the mongo shell. Chapters 00:00 - Intro 01:03 - Emulator configuration options 02:20 - Emulator pre-requisites 04:36 - Adding certificates 07:20 - Azure Cosmos DB emulator 08:31 - Querying data 09:27 - Python sample app to try it 10:30 - Visualizing data with Azure Data Studio 12:26 - Mongo shell 15:13 - Wrap-up Recommended resources Install and use the Azure Cosmos DB Emulator for local development and testing Run the emulator on Docker for Linux (Preview) Quickstart: Use Azure Data Studio to connect and query Azure Cosmos DB API for MongoDB (Preview) Get Azure Data Studio Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Azure Friday | Twitter: @AzureFriday

Going from your local development environment to the cloud can be challenging. Savannah Ostrowski joins Scott Hanselman to show how the Azure Developer CLI (azd) uses a set of developer-friendly commands that map to key stages in your workflow and idiomatic application templates to accelerate the time it takes you to get started on Azure. Chapters 00:00 - Introduction 01:45 - Code to Cloud Journey 04:04 - Azure Developer CLI templates 05:42 - Exploring with a sample app 11:57 - azd CLI demo 21:07 - "It even created a dashboard? What?" 21:39 - Exploring the deployed app components 23:01 - Wrap-up Recommended resources What is the Azure Developer CLI? (preview) Introducing the Azure Developer CLI (azd): A faster way to build apps for the cloud Get started using Azure Developer CLI (preview) Find azd templates on GitHub Make your project compatible with Azure Developer CLI (preview) Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Savannah Ostrowski | Twitter: @SavOstrowski Azure Friday | Twitter: @AzureFriday

Front-end web applications often call back-end APIs for data and services. Annina Keller joins Scott Hanselman to show how Azure Static Web Apps provides built-in serverless API endpoints via integration with Azure services, including Azure App Service, Azure API Management, Azure Container Apps, and Azure Functions. Chapters 00:00 - Introduction 03:18 - Simple demo 10:30 - Demo with OAuth and API Management 17:50 - Wrap-up 18:40 - Resources Recommended resources Overview of API support in Azure Static Web Apps Use Static Web Apps API and API Management Authorizations to integrate third party services API Management - Authorizations overview New API backend options in Azure Static Web Apps Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Annina Keller | Twitter: @AnninaKe Azure Friday | Twitter: @AzureFriday

Lakshmi Murthy joins Scott Hanselman to show how to build your enterprise data model using Azure Synapse database templates to add rich business context to your data and drive meaningful analytics. Chapters 00:00 - Introduction 01:07 - Azure Synapse database templates 04:54 - Demo: Creating a lake database 10:35 - Demo: Customizing and querying 17:04 - Wrap-up Recommended resources Lake database templates Announcing GA of Database Templates in Azure Synapse Analytics How-to: Create a lake database from database templates Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Azure Friday | Twitter: @AzureFriday

Elizabeth Barnitt joins Scott Hanselman to discuss and demo GraphQL support in Azure API Management, which allows you to import, validate, secure, and augment GraphQL APIs in Azure. Azure API Management enables you to both govern your existing GraphQL servers and build one from scratch with Synthetic GraphQL, which allows you to combine your existing REST and SOAP endpoints into a single, easy to query endpoint. Chapters 00:00 - Introduction 01:23 - What is GraphQL? 11:34 - Demo - Import a GraphQL API 18:12 - Demo - Synthetic GraphQL 21:24 - Wrap-up Recommended resources Azure API Management resources Import a GraphQL API Import a GraphQL schema and set up field resolvers Protect, Augment, and Build GraphQL APIs with Azure API Management Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Elizabeth Barnitt | Twitter: @BarnittE Azure Friday | Twitter: @AzureFriday

Managing concurrent access to a resource, be it a row, a table, or a single value, is easy if no one is trying to modify the underlying data. But what happens if someone changes data while someone else is reading it? Even better, what could happen if two or more users try to change the same data at the same time? Well, there are a couple of options. The easiest is to just ask everyone to queue up, the other is to have multiple versions of the data available over time so that no one must wait for the changes to be finished. Let's explore both the options with Lara Rubbelke and Davide Mauri on Azure Friday. Chapters 00:00 - Introduction 01:50 - DEMO: Locking behavior 03:20 - DEMO: Default "read committed snapshot" behavior 05:20 - Migrating from SQL Server to Azure SQL DB 06:42 - DEMO: snapshot isolation level 12:12 - Wrap-up Recommended resources Transaction locking and row versioning guide SET TRANSACTION ISOLATION LEVEL (Transact-SQL) Azure SQL Database Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Lara Rubbelke | Twitter: @SQLGal Davide Mauri | Twitter: @MauriDB Azure Friday | Twitter: @AzureFriday

Rong Zhang and Tats Mishra join Scott Hanselman to talk about the AKS extension in VS Code that provides a fully integrated Azure Kubernetes Services diagnostics experience. Chapters 00:00 - Introduction 01:53 - Get the extension + connect to Azure 03:18 - Extension features 05:32 - AKS Periscope 06:47 - Navigational features 07:24 - Cluster properties 08:25 - Creating workflows 09:43 - Azure Service Operator 11:05 - Wrap-up Recommended resources AKS tools and diagnostics in VS Code AKS Extension for Visual Studio Code Azure Kubernetes Service Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Rong Zhang | Twitter: @RongZhang817 Tatsat Mishra | Twitter: @Tats_innit Azure Friday | Twitter: @AzureFriday

Davide Mauri is back with Lara Rubbelke to discuss columnstore indexes. In a typical relational database data is stored per row. This means that all row columns are saved together, which is great in all those cases where you want to retrieve all the information related to a specific row. But what if you want to have all the data stored in a subset of columns but for all the rows? That would be complex and slow—unless data was saved per-column instead of per-row. That's exactly what columnstore indexes in Azure SQL Database enables you to do. Chapters 00:00 - Introduction 01:00 - Columnstore overview 07:00 - Demo: index creation 10:14 - Demo: querying with columnstore 13:53 - Demo: batch mode with LAG operator 15:00 - Wrap-up Recommended resources Columnstore indexes: Overview Azure SQL Database Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Lara Rubbelke | Twitter: @SQLGal Davide Mauri | Twitter: @MauriDB Azure Friday | Twitter: @AzureFriday

Lior Kamrat joins Scott Hanselman to discuss Azure Arc-enabled Kubernetes extensibility model, which makes any Kubernetes cluster outside of Azure a target location for many Azure services. Chapters 00:00 - Introduction 01:58 - Extensibility model 04:54 - Azure portal 09:20 - Demo, Part 1 16:30 - Demo, Part 2 17:50 - Wrap-up Recommended resources Azure Arc landing zone accelerator for hybrid and multi-cloud What is Azure Arc-enabled Kubernetes? Azure Arc Jumpstart Jumpstart ArcBox - Overview Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Twitter: Scott Hanselman | @SHanselman Twitter: Lior Kamrat | @LiorKarmat Twitter: Azure Friday | @AzureFriday

If you are familiar with the Event Sourcing and CQRS patterns, then you know that they are extremely powerful, but can be quite complex to implement correctly. Davide Mauri joins Lara Rubbelke to show temporal tables give you the same benefits without the related challenges. Chapters 00:00 - Introduction 01:28 - Demo using temporal tables 06:11 - Demo using 'as of' 07:36 - Demo for a range of time 08:32 - Wrap-up Recommended resources Getting started with temporal tables Configure temporal retention policy Azure SQL Database Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Twitter: Lara Rubbelke | @SQLGal Twitter: Davide Mauri | @MauriDB Twitter: Azure Friday | @AzureFriday

Bruno Borges joins Scott Hanselman to talk about Java development with Microsoft. Like many of our customers, Microsoft is a Java shop with lots of systems that rely on Java and its ecosystem. We employ thousands of Java engineers, run millions of JVMs, and process terabytes of data every day, to deliver the services everyone loves. We also built tools and services specifically designed for Java developers and applications. Chapters 00:00 - Introduction 02:53 - Java usage at Microsoft 04:55 - Microsoft Build of OpenJDK 07:18 - Modern Java at Microsoft (Java 17) 09:11 - Microsoft tools for Java 12:53 - Build on your terms 14:19 - Build or migrate Java apps 16:19 - Wrap-up Recommended resources Java on Azure Azure is the home for your enterprise Java applications Microsoft Build of OpenJDK Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Twitter: Scott Hanselman | @SHanselman Twitter: Bruno Borges | @BrunoBorges Twitter: Azure Friday | @AzureFriday

In recent years, developers pushed for relational databases to be more flexible and open to the many different formats (e.g., JSON, graph, and spatial) to store and manipulate data. Davide Mauri joins Lara Rubbelke to show how Azure SQL Database enables you to take advantage of the rock-solid foundation of relational databases with the flexibility offered by non-relational models. And best of all, it's seamlessly integrated to empower you to choose the best technology for the job. Chapters 00:00 - Introduction 02:00 - Working with JSON data 11:34 - SQL graph 17:17 - Samples 18:19 - Spatial data 19:35 - Wrap-up Recommended resources Work with JSON data in SQL Server SQL Graph Architecture Spatial Data Types Overview Browse Azure SQL DB code samples Azure SQL DB Samples and Best Practices on GitHub Connect Lara Rubbelke | Twitter: @SQLGal Davide Mauri | Twitter: @MauriDB Azure Friday | Twitter: @AzureFriday