Azure Friday Scott Hanselman

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