Azure Friday

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