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

Azure SQL Database: Columnstore indexes

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

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 Cosmos DB: The database for your AI apps

Join Stefan Wernli and Scott Hanselman as they unveil the full capabilities of the Azure Quantum Development Kit 1.0. This latest update revolutionizes quantum coding with a Rust-based core, ensuring speed, portability, and direct browser accessibility. Dive into the Azure Quantum portal, now enhanced with Copilot guidance, and transition seamlessly to web-based VS Code. Here, you can craft quantum algorithms, simulate, and refine your Q# creations, dispatch them to quantum processors, and leverage the Azure Quantum Resource Estimator to gauge the scalability of your quantum solutions. Start your quantum journey today, from novice exploration to expert innovation. Chapters  00:00 - Introduction 01:56 - Getting started 07:20 - Continue coding in vscode.dev 11:40 - Debugging quantum code 16:22 - Running code on a quantum machine 21:12 - Resource estimation 26:11 - Wrap-up  Recommended resources  Azure Quantum What's New in the Modern QDK Exploring space-time tradeoffs with Azure Quantum Resource Estimator GitHub - microsoft/qsharp Create a Pay-as-You-Go account (Azure) Try Azure Cosmos DB for free  Connect  Scott Hanselman | Twitter/X: @SHanselman Azure Friday | Twitter/X: @AzureFriday Azure | Twitter/X: @Azure

Azure SQL Database: Columnstore indexes

Download our free app to listen on your phone