Murali Krishnaprasad joins Lara Rubbelke to discuss Interactive Query (also called Hive LLAP, or Low Latency Analytical Processing, or Live Long and Process), which is an Azure HDInsight cluster type. Interactive Query supports in-memory caching, which makes Hive queries super-fast and interactive. See how to use HDInsight Interactive Query to analyze extremely large datasets (~100TB) in common file formats such as ORC and CSV using common BI/SQL tools including Zeppelin notebooks and VS Code.Jump To: [04:12] Demo Start For more information, see:Use Interactive Query with HDInsight (docs)HDInsight overviewHDInsight pricing detailsCreate a free account (Azure)Follow @sqlgal Follow @AzureFriday Follow @AzureHDInsight

Kylie Liang joins Lara Rubbelke to demo how to use Ansible, an open-source, simple IT automation engine for automating cloud provisioning, configuration management and application deployments on Azure. Kylie also shares the roadmap for Ansible on Azure.Jump To:[00:15]  Demo Start For more information:Ansible in Azure Documentation (docs)Ansible Playbook Samples for Azure (GitHub)Ansible modules (GitHub)Microsoft Azure Guide on Ansible (docs)Ansible on Azure RoadmapAnsible Visual Studio Code Extension on Visual Studio MarketplaceAzure Preview Modules on AnsibleCreate a free account (Azure)Follow @sqlgal Follow @AzureFriday Follow @LiangKylie

Jean-Sébastien Brunner joins Lara Rubbelke to discuss new features that enable you to implement the intelligent cloud, intelligent edge vision for streaming analytics: Stream Analytics running real-time analytics with custom code on IoT Edge. We also discuss substreams, which is a new time management feature for independently processing the timeline of each device (very useful for an IoT scenario), and the recently announced Session Window.Jump To:[01:12] Demo Start For more information:Azure Stream Analytics (product info)Azure Stream Analytics now available on IoT Edge (Azure blog)4 new features now available in Azure Stream Analytics (Azure blog)Announcing real-time Geospatial Analytics in Azure Stream Analytics (Azure blog)Azure Stream Analytics DocumentationCreate a free account (Azure)Follow @sqlgal Follow @AzureFriday Follow @AzureStreaming

Steve Lasker joins Lara Rubbelke to discuss ACR Build, a cloud-native container build solution enabling pre-check, git commit and base image update docker builds for OS and framework patching.  Jump To:[03:18] Demo Start For more information:  Automate OS and framework patching with ACR Build (docs)Demo 42 sample (GitHub)Azure Container Registry (product info)Azure Container Registry (pricing)Azure Container Registry Roadmap (GitHub)Create a free account (Azure)Follow @sqlgal Follow @AzureFriday Follow @stevelasker

Gaurav Malhotra joins Scott Hanselman to discuss Event-driven architecture (EDA), which is a common data integration pattern that involves production, detection, consumption, and reaction to events. Learn how you can do event-based data integration using Azure Data Factory.Jump To:[01:53] Demo Start For more information:Event trigger-based data integration with Azure Data Factory (blog post)Create a trigger that runs a pipeline in response to an event (docs)Azure Data Factory product infoAzure Data Factory pricingCreate a free account (Azure)Follow @SHanselman Follow @AzureFriday

Justin Luk joins Scott Hanselman to show the new Azure Cloud Shell editor. Since its launch, Cloud Shell included a variety of editors (vi, emacs, and nano) for editing files. In collaboration with the Visual Studio Code team and their open-source Monaco project, the same web standards-based editor that powers Visual Studio Code is now integrated directly into Cloud Shell.Jump To:[02:05] Demo StartFor more informationCloud Shell documentationCloud Shell feature pageCloud Shell pricingMonaco project (GitHub repo)Announcing the Azure Cloud Shell editor in collaboration with Visual Studio Code (blog post)Create a free account (Azure)Follow @SHanselman Follow @AzureFriday Follow @whosjluk

Chacko Daniel joins Scott Hanselman to discuss Azure Service Fabric Mesh, which offers the same reliability, mission-critical performance and scale customers get with Service Fabric, but no more overhead of cluster management and patching operations. Service Fabric Mesh supports both Windows and Linux containers allowing you to develop with any programming language and framework of your choice.Jump Tp:[04:35] Demo StartFor more information:Azure Service Fabric Mesh documentationAzure Service Fabric Mesh samplesAzure Service Fabric Mesh pricingCreate a free account (Azure)Follow @SHanselman Follow @AzureFriday Follow @chackod

Yashesvi Sharma joins Scott Hanselman to discuss how to significantly reduce costs up to 72 percent compared to pay-as-you-go prices with one-year or three-year terms on Windows and Linux virtual machines (VMs). When you combine the cost savings gained from Azure RIs with the added value of the Azure Hybrid Benefit, you can save even more.Jump To:[04:59] Demo Start For more information:Prepay for Virtual Machines with Azure Reserved VM Instances (docs)Azure Reserved VM Instances (RIs)Azure Virtual Machine pricingAzure Hybrid BenefitGet Reserved Instance purchase recommendations based on usage pattern (blog)Create a free account (Azure)Follow @SHanselman Follow @AzureFriday Follow @AzureBilling

Xiaokai He joins Scott Hanselman to discuss Azure SignalR Service. See how easy it is to start building your real-time web application without setting up your own SignalR server.Jump To: [01:05] Demo Start For more information, see:Azure SignalR Service product pageAzure SignalR samples (GitHub)ASP.NET SignalRWhat is Azure SignalR Service (docs)Azure SignalR Service pricingCreate a free account (Azure)Follow @SHanselman Follow @AzureFriday Follow @XiaokaiHe Follow @signalr

Kiran Madnani chats with Scott Hanselman about Azure Monitor, where you can set up alerts to monitor the metrics and log data for the entire stack across your infrastructure, application, and Azure platform. Learn about the next generation of alerts in Azure, which provides a new consolidated alerts experience in Azure Monitor. Plus, new metrics-based alerts platform that is faster and leveraged by other Azure services.Jump To:[02:15] - Demo Start For more information, see:Unified alerts in Azure Monitor (docs)Azure Monitor product pageAzure Monitor pricing pageThe next generation of Azure Alerts has arrived (blog post)Create a free account (Azure)Follow @SHanselman Follow @AzureFriday Follow @Kmadnani