Azure Friday (HD) - Channel 9

Hansjoerg Scherer joins Scott Hanselman to discuss how to deploy your mission-critical workload in an Azure landing zone. For enterprises, a mission critical workload is expected to integrate with resources owned by centralized platform team. They control and govern the shared infrastructure for the entire organization. Connectivity and governance controls influence where and how the application is deployed in your corporate tenant. Learn about the best practices for deploying your workload in this shared responsibility approach and still achieve the goal of maximum reliability. Chapters 00:00 - Introduction 00:50 - Azure landing zones 03:04 - Exploring an example landing zone in the Azure portal 07:15 - Reference implementation of an Azure landing zone 12:30 - Deployment using a CI/CD pipeline 14:05 - Exploring policy compliance 16:00 - Getting-started guide and resources 17:30 - Wrap-up Recommended resources Mission-critical baseline architecture in an Azure landing zone Azure Mission-Critical Connected on GitHub Mission-critical workload documentation Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Azure Friday | Twitter: @AzureFriday Azure Architecture | Twitter: @MSPnP Azure | Twitter: @Azure

Gavin Aguiar and Shreya Batra join Scott Hanselman to discuss the v2 programming model for Azure Functions using Python, which provides an Azure Functions development experience that is more familiar to Python developers. Key features include triggers and bindings declared as decorators, a simplified folder structure, and support through easy-to-reference documentation. Chapters 00:00 - Introduction 01:18 - Azure Functions backgrounder 04:30 - v2 programming model for Python 06:40 - VS Code extension for v2 programming model for Python 08:40 - Demo: Create an Azure Function with the v2 programming model for Python 12:00 - Missing a Storage account... 14:00 - App decorators add the magic... 15:00 - Demo of a more complicated example 21:50 - Wrap-up Recommended resources Azure Functions: V2 Python Programming Model Azure Functions Python developer guide Python V2 model Azure Functions triggers and bindings (preview) Quickstart: Create a function in Azure with Python using Visual Studio Code V2 Programming Model for Azure Functions using Python Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman Shreya Batra | Twitter: @BatraShreya Azure Friday | Twitter: @AzureFriday Azure Functions | Twitter: @AzureFunctions Azure | Twitter: @Azure

Sebastian Bader joins Scott Hanselman to show how you can use health modeling to minimize downtime of your mission-critical workloads on Azure. With health modeling, you don't only see the health status of the entire system, you also see the dependencies between your components and an intuitive indication of degraded components. See exactly where to start your investigations to quickly find the root cause and the cascading impacts caused by the incident. This is the second episode on running mission-critical workloads on Azure. See the previous episode on how to continuously validate and test your mission-critical Azure workloads. Chapters 00:00 - Introduction 00:56 - Typical dashboards 03:39 - Exploring sample application 04:21 - Health monitoring dashboard 07:55 - What it takes to build 11:12 - Azure Mission-Critical Online Reference Implementation 13:22 - Getting started Recommended resources Health modeling for mission-critical workloads Mission-critical workloads 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 Architecture | Twitter: @MSPnP Azure | Twitter: @Azure

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

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

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

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

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

John Downs joins Scott Hanselman to discuss how to design, architect, and build multitenant solutions on Azure. If you're building a SaaS product or another multitenant service, there's a lot to consider when you want to ensure high performance, tenant isolation, and managing deployments. We'll walk through some example SaaS architectures and see how Microsoft provides guidance to help you to build a multitenant solution on top of Azure. Chapters 00:00 - Introduction 00:23 - Multitenancy in the cloud 06:28 - Multitenancy guidance 07:00 - Design considerations 16:09 - Architectural approaches 18:07 - Service-specific guidance 20:28 - Wrap-up Recommended resources Architect multitenant solutions on Azure Architecting multitenant solutions Livestream event Share your feedback Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Scott Hanselman | Twitter: @SHanselman John Downs | Twitter: @JDwns Azure Friday | Twitter: @AzureFriday

In the first of a series of episodes about Azure SQL Database, Davide Mauri joins Lara Rubbelke to give an overview of Grouping Sets and Windowing Functions, which can make you, your solution, and your code much more efficient. Chapters 00:00 - Introduction 01:01 - Discussion 03:58 - Grouping Sets 11:56 - Windowing Functions 25:11 - Wrap-up Recommended resources Azure SQL Database Azure SQL documentation Azure SQL Database code samples Write queries that use window functions 10 reasons to use Azure SQL in your next project Connect Lara Rubbelke | Twitter: @SQLGal Davide Mauri | Twitter: @MauriDB Azure Friday | Twitter: @AzureFriday

Tanya Janca joins Scott Hanselman to discuss the various security features within Azure that are cloud native and what that means for security professionals. Discussing the benefits of DDoS protection (and what DDoS is) will help you understand its value and when it's needed. We also discuss the added value of Azure Defender features such as JIT, FIM, and Application Adaptive Controls in preventing ransomware. Chapters 00:00 - Introduction 00:20 - Distributed Denial of Service (DDoS) attacks 03:00 - DDoS Protection in Azure 05:55 - Microsoft Defender for Cloud 06:42 - Microsoft Defender for Cloud | Workload protections 10:53 - We Hack Purple Community 11:42 - Wrap-up Recommended resources Azure DDoS Protection Standard overview What is Microsoft Defender for Cloud? We Hack Purple Community Top 5 security items to consider before pushing to production Connect Scott Hanselman | Twitter: @SHanselman Tanya Janca | Twitter: @SheHacksPurple We Hack Purple Academy & Community! | Twitter: @WeHackPurple Azure Friday | Twitter: @AzureFriday

Henk Boelman joins Scott Hanselman to discuss how AI can help to create more accessible experiences with Azure Machine Learning, Azure Cognitive Services, and Azure Media Services. They will look at the AI building blocks available in Azure and see how these building blocks can be applied. Chapters 00:00 - Introduction 03:32 - Henk's demo environment using Jupyter notebooks 05:28 - Computer Vision demo 10:42 - Custom Vision demo 16:59 - Face demo 20:20 - Handwriting example 20:59 - Text to speech example 22:38 - Bonus demo: Accessible stream with Azure Media Services 26:42 - Wrap-up Recommended resources hnky / azure-friday Computer Vision documentation Custom Vision documentation Face documentation Tech A11y Summit Connect Scott Hanselman | Twitter: @SHanselman Henk Boelman | Twitter: @HBoelman Azure Friday | Twitter: @AzureFriday

John Stallo joins Scott Hanselman to introduce Azure's new, fully managed load testing service that enables developers and testers to generate high-scale load and gain actionable insights to catch performance bottlenecks at scale. Chapters 00:00 - Introduction 03:07 - Getting Started with Azure Load Testing 05:43 - Running a load test 08:54 - How did the application components behave? 15:00 - Wrap-up Recommended resources Azure Load Testing What is Azure Load Testing Preview? Quickstart: Create and run a load test with Azure Load Testing Preview GitHub: microsoft / azure-load-testing

Learn how to use the new Azure Cosmos DB indexing metrics to improve query performance. Tim Sander shows Scott Hanselman how to obtain, interpret, and make changes based on the indexing metrics. Chapters 00:00 - Introduction 02:23 - Default indexing policy 04:18 - Optimizing for write performance 07:23 - Index metrics 09:32 - Composite indexes 16:42 - Roadmap insights 18:00 - Wrap-up Recommended resources Optimize query performance with Azure Cosmos DB indexing metrics Troubleshoot query issues when using Azure Cosmos DB New ways to use composite indexes in Azure Cosmos DB Indexing metrics in Azure Cosmos DB Connect Scott Hanselman | Twitter: @shanselman Tim Sander | Twitter: @_TimSander Azure Friday | Twitter: @AzureFriday

Isaac Levin from Elastic joins Scott Hanselman to discuss Elastic Cloud on Azure. Elastic Cloud is an Elasticsearch and Kibana managed service - with solutions for enterprise search, observability, and security. Running Elastic on Azure enables you to take data from any source - reliably and securely, in any format - then search, analyze, and visualize that data in real time. Elastic on Azure users experience frictionless integration directly within the Azure portal, allowing for faster time to market. With deployment models to meet your unique use case, you'll gain the speed, scale, and relevance you need to react quickly to support your rapidly evolving business needs. Chapters 00:00 - Introduction 01:04 - Getting started with Elasticsearch 04:05 - Enterprise search 05:10 - App Search: Engines 06:06 - App Search: Analytics 06:58 - App Search: Web crawler 08:16 - App Search: Search UI 10:17 - App Search: Relevance tuning 12:13 - App Search: Synonyms 14:56 - App Search: Curations 17:15 - Wrap-up Recommended resources Elastic on Azure Elastic Enterprise Search Elastic Search UI Create a free account Connect Scott Hanselman | Twitter: @shanselman Isaac Levin | Twitter: @isaacrlevin Elastic | Twitter: @elastic Azure Friday | Twitter: @azurefriday

Matias Quaranta joins Scott Hanselman to show how the updated Azure Cosmos DB extension for Azure Functions uses the latest Azure Cosmos DB .NET SDK to add support for Azure AD authentication. Dispense with connection strings required, improve performance, and get support for custom serialization. Chapters 00:00 - Introduction 01:31 - Identity-based connections with managed identities 09:50 - Performance improvements 12:15 - Custom serialization 13:59 - Wrap-up Recommended resources Azure Functions developer guide Built-in role definitions Azure Cosmos DB trigger for Azure Functions Create a free account (Azure) Connect Scott Hanselman | Twitter: @shanselman Matias Quaranta | Twitter: @ealsur Azure Friday | Twitter: @azurefriday

Kavitha Gowda joins Scott Hanselman to discuss and demo Azure Red Hat OpenShift, which is jointly engineered, operated, and supported by Microsoft and Red Hat to provide an integrated support experience. There are no virtual machines to operate, and no patching is required. Master, infrastructure, and application nodes are patched, updated, and monitored on your behalf by Microsoft and Red Hat. Your Azure Red Hat OpenShift clusters are deployed into your Azure subscription and are included on your Azure bill. Chapters 00:00 - Introduction 01:12 - Overview 07:15 - Cluster creation 12:38 - Cluster connection and exploration 15:35 - Creating a new MachineSet 19:42 - AAD integration with Group Sync Operator 20:26 - Install Azure resources with Azure Service Operator 21:30 - Azure Arc integration 22:18 - GitOps 23:09 - Monitoring 24:38 - Wrap-up Recommended resources Azure Red Hat OpenShift (Azure.com) Microsoft Azure Red Hat OpenShift (RedHat.com) Azure Red Hat OpenShift docs Overview of responsibilities for Azure Red Hat OpenShift Create a free account (Azure) Connect Scott Hanselman | Twitter: @shanselman Kavitha Gowda | Twitter: @KavithaJPGowda Azure Friday | Twitter: @AzureFriday

Simona Cotin shows Scott Hanselman how Azure Static Web Apps enterprise-grade edge powered by Azure Front Door enables faster page loads, enhanced security, and increased reliability for your global apps with no configuration or additional code required. Chapters 00:00 - Intro 01:38 - Overview 02:45 - Enabling enterprise-grade edge 04:03 - Reducing latency with points of presence 06:03 - Powered by Azure Front Door 08:05 - "Back in the old days..." 09:42 - Observing the performance impact 13:40 - Manually configure Azure Front Door 14:51 - Wrap-up Recommended resources In Preview Announcement blog post What is Azure Static Web Apps? Enterprise-grade edge (Preview) Build Fast, Secure and Globally Distributed Web Apps webinar Tutorial: Manually configure Azure Front Door for Azure Static Web Apps Connect Scott Hanselman | Twitter: @shanselman Simona Cotin | Twitter: @simona_cotin Azure Friday | Twitter: @AzureFriday

April Edwards joins Scott Hanselman to show how delivering apps in a DevOps world also means shifting security left. To securely deliver our apps, organizations must harden their dev environments, while leveraging tooling to scan and proactively protect their repositories, ensuring continuous delivery is secure. Azure Friday Quiz Sweepstakes Watch the episode to the end and then submit your answers to our five-question quiz about the info April covered with Scott. Eligible participants who answer all five questions correctly will be entered into a Sweepstakes with a chance to be one of ten lucky winners to win a box of Microsoft swag! The Azure Friday Quiz Sweepstakes ends at 11:59pm PT on February 12, 2022. Take the quiz! | Terms and conditions | Privacy statement Chapters 00:00 - Introduction 01:14 - GitHub Codespaces 04:17 - GitHub Code Security (Dependabot, CodeQL, and Secret scanning) 05:51 - Environment workflows 06:38 - Microsoft Defender for Cloud 07:47 - Relationship between Dependabot and Microsoft Defender for Cloud 09:01 - Wrap-up Recommended resources GitHub Codespaces GitHub Code Security GitHub CodeQL Understand security in the Pipeline Identify vulnerable container images in your CI/CD workflows Connect Scott Hanselman | Twitter: @shanselman April Edwards | Twitter: @TheAprilEdwards Azure Friday | Twitter: @AzureFriday

Over 77% of transaction revenue in the world touches an SAP system, and more SAP systems are running in the cloud each year. The SAP platform provides a foundation for innovation for many companies and can handle various workloads natively. Holger Bruchelt joins Scott Hanselman to show how you can combine Microsoft Cloud with SAP on Azure to extend with Power Platform, integrate with Azure APIM and Logic Apps, and more. Chapters 00:00 - Introduction 03:50 - SAP on Azure overview 04:55 - Demo: Azure Bastion to connect to a VM running SAP 05:43 - Demo: Azure Active Directory for SSO with SAP Fiori UI 10:15 - Demo: Power Automate and Azure API Management from Excel 14:48 - Demo: Calling Azure Logic Apps from Word 19:36 - Demo: Azure Bot Service 23:00 - Demo: Trigger workflows from Outlook 25:01 - Wrap-up Recommended resources SAP on Azure YouTube channel SAP on Azure Podcast SAP on Azure solution SAP certified offerings for Azure SAP on Azure GitHub

Azure Chaos Studio is a is a fully managed chaos engineering experimentation platform for accelerating discovery of hard-to-find problems, from late-stage development through production. John Engel-Kemnetz joins Scott Hanselman to show how you can disrupt your apps intentionally to identify gaps and plan mitigations before your customers are impacted by a problem. 00:00 - Introduction 0:41 - Chaos engineering 3:58 - Demo context 4:49 - Demo of a chaos experiment 15:22 - Wrap-up Resources: What is Azure Chaos Studio preview Create a chaos experiment Azure Chaos Studio overview Understanding chaos engineering and resilience Create a free account (Azure)

The Azure App Service Environment is an Azure App Service feature that provides a fully isolated and dedicated environment for securely running App Service apps at high scale. Christina Compy joins Scott Hanselman to introduce ASE v3. 00:00 - Introduction 04:26 - Demo 08:39 - Resources 09:48 - ASEv3 vs ASEv2 13:19 - Wrap-up Resources: App Service Environment overview Create an App Service Environment Using an App Service Environment Securing web workloads with App Service Environments Create a free account (Azure)

Justin Yoo joins Scott Hanselman to demonstrate an extension he developed for adding OpenAPI capabilities to Azure Functions apps. See how easy it is to get HTTP-triggered .NET functions with OpenAPI support and deploy an Azure Functions app with Azure API Management from Visual Studio.═══════════════Watch the episode to the end and then submit your answers to our five-question quiz about the info Scott and Justin covered. Eligible participants who answer all five questions correctly will be entered into a Sweepstakes with a chance to be one of ten lucky winners to win a box of Microsoft swag! The Azure Friday Quiz Sweepstakes ends on Dec 10, 2021.Take the quiz! Terms and conditions Privacy statement═══════════════[0:00:00]– Intro[0:03:15]– Create[0:09:20]– Publish[0:12:56]– Consume[0:22:48]– Wrap-upCreate serverless APIs in Visual Studio using Azure Functions and API Management integration (preview)Azure Functions OpenAPI ExtensionCreate a free account (Azure)

Justin Yoo joins Scott Hanselman to demonstrate an extension he developed for adding OpenAPI capabilities to Azure Functions apps. See how easy it is to get HTTP-triggered .NET functions with OpenAPI support and deploy an Azure Functions app with Azure API Management from Visual Studio. Chapters 00:00 - Intro 03:15 - Create 09:20 - Publish 12:56 - Consume 22:48 - Wrap-up Recommended resources Create serverless APIs in Visual Studio using Azure Functions and API Management integration (preview) Azure Functions OpenAPI Extension Create a free account (Azure)