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

Azure SQL Database: A developer's best friend

Join Scott Hanselman every Friday as he engages one-on-one with the engineers who build the services that power Microsoft Azure as they demo capabilities, answer Scott's questions, and share their insights. Follow us at: friday.azure.com.

Technology

Tech News

Podcasting

Gadgets

Software How-To

Hanna Endrias joins Scott Hanselman to discuss Microsoft Copilot for Azure integration in Azure App Service. App Service has over sixty troubleshooting tools, which can make it difficult to know where to look when an issue arises. With Azure Copilot, you can describe a problem and navigate to the perfect diagnostics, whether it's related to high CPU usage, networking issues, getting a memory dump, or more. Chapters  00:00 - Introduction 00:40 - Requesting access to Microsoft Copilot for Azure preview 01:10 - Demo: Copilot experience in Azure App Service 11:15 - Key words 13:50 - Wrap-up  Recommended resources  Troubleshoot your apps faster with App Service using Microsoft Copilot for Azure (preview) What is Microsoft Copilot for Azure (preview)? Limited access to Microsoft Copilot for Azure (preview) Register to use Microsoft Copilot for Azure (preview) Create a Pay-as-You-Go account (Azure) Create a free account (Azure)  Connect  Scott Hanselman | Twitter/X: @SHanselman Azure App Service | Twitter/X: @AzAppService Azure Friday | Twitter/X: @AzureFriday Azure | Twitter/X: @Azure

Troubleshoot your apps faster with App Service using Microsoft Copilot for Azure

Join Scott Hanselman and James Codella to learn how you can turn your natural language questions about your data into Azure Cosmos DB NoSQL queries to find the right data to power your applications more easily. Chapters  00:00 - Introduction 00:55 - Copilot for Azure in Cosmos DB 02:40 - Demo 08:30 - Discussion 10:20 - Wrap-up  Recommended resources  Microsoft Copilot for Azure enables natural language queries for Azure Cosmos DB data Generate NoSQL queries with Microsoft Copilot for Azure in Cosmos DB Frequently asked questions about Microsoft Copilot for Azure in Cosmos DB Create a Pay-as-You-Go account (Azure) Create a free account (Azure)  Connect  Scott Hanselman | Twitter/X: @SHanselman James Codella | Twitter/X: @JamesCodella Azure Cosmos DB | Twitter/X: @AzureCosmosDB Azure Friday | Twitter/X: @AzureFriday Azure | Twitter/X: @Azure

Generate NoSQL queries with Microsoft Copilot for Azure in Cosmos DB

Steve Buchanan and Rajat Shrivastava join Scott Hanselman to explore the functionality of Azure Kubernetes Service backup in safeguarding containerized apps and their data. Learn the importance of backing up your containers, even when they are mostly stateless. See why safeguarding containers is crucial and provides insights into the workings of AKS backup in ensuring the protection of workloads running on AKS. Chapters  00:00 - Introduction 00:30 - Why AKS backup? 05:26 - Demo: Creating backups 16:10 - Demo: Restoring backups 22:35 - Wrap-up  Recommended resources  Backup for AKS: Cloud native, Enterprise ready, Kubernetes aware backup What is Azure Kubernetes Service backup? Cluster extensions Prerequisites for Azure Kubernetes Service backup using Azure Backup Create a Pay-as-You-Go account (Azure) Create a free account (Azure)  Connect  Scott Hanselman | Twitter/X: @SHanselman Steve Buchanan | Twitter/X: @BuchaTech Rajat Shrivastava | Twitter/X: @rajat-shrivastava Azure Backup | Twitter/X: @AzureBackup The AKS Community | Twitter/X: @theakscommunity Azure Friday | Twitter/X: @AzureFriday Azure | Twitter/X: @Azure

Safeguard your containerized workloads using AKS backup

Scott Hanselman and Mahip Deora explore the Azure cross-region Load Balancer, a global OSI Model Layer 4 load balancing solution. Now you can distribute traffic across multiple regions with ultra-low latency and high performance. Chapters  00:00 - Introduction 02:00 - Load balancing options 03:24 - Request routing 06:55 - Global load balancing 15:34 - Demo in the Azure portal 19:17 - Wrap-up  Recommended resources  Cross-region Load Balancer Global distribution solutions with Microsoft Azure Tutorial: Create a cross-region load balancer Create a Pay-as-You-Go account (Azure) Create a free account (Azure)  Connect  Scott Hanselman | Twitter/X: @SHanselman Azure Networking | Twitter/X: @AzNetEng Azure Friday | Twitter/X: @AzureFriday Azure | Twitter/X: @Azure

Build scalable applications with Azure cross-region Load Balancer

Join Scott Hanselman, Kirill Gavrylyuk, and James Codella to learn about Azure Cosmos DB's built-in vector search capabilities, how customers are using it in their AI apps, and how you can easily get started today. Chapters  00:00 - Introduction 02:05 - Overview with Kirill Gavrylyuk 06:46 - Real world example: Asos 09:12 - Retrieval Augmented Generation (RAG) 11:57 - Demo setup with James Codella 15:00 - Deploy to Azure 16:53 - Azure OpenAI Studio 26:19 - Graduating from the Chat Playground 29:13 - Wrap-up  Recommended resources  Vector database - Azure Cosmos DB Azure OpenAI On Your Data Azure / Vector-Search-AI-Assistant-MongoDBvCore Try Azure Cosmos DB for free Introducing the General Availability of Vector Search in Azure Cosmos DB for MongoDB vCore! Create a Pay-as-You-Go account (Azure) Create a free account (Azure)  Connect  Scott Hanselman | Twitter/X: @SHanselman Azure Cosmos DB | Twitter/X: @AzureCosmosDB Azure Friday | Twitter/X: @AzureFriday Azure | Twitter/X: @Azure

Azure SQL Database: A developer's best friend

Download our free app to listen on your phone