Azure Friday

Manoj Raheja joins Lara Rubbelke (@sqlgal) to demonstrate Azure Data Explorer (ADX) and provide an overview of the service from provisioning to querying. ADX is a fast, fully managed data analytics service for real-time analysis on large volumes of streaming data. It brings together a highly performant and scalable cloud analytics service with an intuitive query language to deliver near-instant insights.Jump To: [02:10] Demo Start Azure Data Explorer overviewAzure Data Explorer docsAzure Data Explorer pricingCreate a free account (Azure)Follow @sqlgal Follow @AzDataExplorerNever miss an episode: Follow @AzureFriday

Learn about the new code-free visual data transformation capabilities in Azure Data Factory as Gaurav Malhotra joins Lara Rubbelke (@sqlgal) to demonstrate how you can visually design, build, and manage data transformation processes without learning Spark or having a deep understanding of the distributed infrastructure.Jump To: [02:45] Demo Start Azure Data Factory mapping data flowsAzure Data Factory overviewAzure Data Factory docsAzure Data Factory pricingCreate a free account (Azure)Follow @sqlgal Follow @DataAzureNever miss an episode: Follow @AzureFriday

Gaurav Malhotra and Scott Hanselman (@shanselman) explore tagging support and enhanced monitoring capabilities, including dashboards and improved debugging support in Azure Data Factory. Data integration is complex and the ability to monitor your data factory pipelines is a key requirement for dev ops personnel inside an enterprise.Now, you can tag/annotate your data factory pipelines to monitor all the pipeline executions with that particular tag. In addition, Data Factory visual tools provide dashboards to monitor your pipelines and an ability to monitor your pipeline execution by the Integration Runtime (IR) upon which the activities execute.Jump To: [01:45] Demo Start Alert and Monitor data factories using Azure MonitorAzure Data Factory overviewAzure Data Factory docsAzure Data Factory pricingCreate a free account (Azure)Follow @SHanselman Follow @DataAzureDon't miss an episode: Follow @AzureFriday

Steve Steuart from Astadia joins Scott Hanselman to show how a mainframe reference architecture based on Azure enables you to deploy your mainframe assets to a native Azure environment. You can the leverage all the available Azure services with your new mainframe in the cloud, including AI, Power BI, IoT, and Machine Learning.Jump To: [04:40] Demo Start Mainframe Migration - Azure Migration CenterIBM Mainframe to Microsoft Azure Reference Architecture (Astadia whitepaper)Moving COBOL Workload to Microsoft Azure (Astadia webinar)Shifting Unisys Mainframe to Microsoft Azure (Astadia webinar)Shifting IBM Mainframe to Microsoft Azure (Astadia webinar)Supporting cost saving and improved performance at WorkSafe (Astadia video)Create a free account (Azure)Follow @SHanselman Follow @AstadiaInc Follow @SteveAstadiaDon't miss an episode Follow @AzureFriday

Chris Anderson (@crandycodes) joins Donovan Brown (@donovanbrown) to discuss Azure Cosmos DB JavaScript SDK 2.0, which adds support for multi-region writes, a new fluent-style object model—making it easier to reference Azure Cosmos DB resources without an explicit URL—and support for promises and other modern JavaScript features. It is also written in TypeScript and supports the latest TypeScript 3.0.Jump To: [00:42] Demo Start Azure Cosmos DB JavaScript SDK 2.0 now generally available (blog post)JavaScript and Node.js library for Azure Cosmos DB (GitHub)Azure Cosmos DB: Build a Node.js app using JavaScript SDK to manage Azure Cosmos DB SQL API data (docs)Azure Cosmos DB (overview)Azure Cosmos DB (pricing)Create a free account (Azure)Follow @donovanbrown Follow @azurecosmosdb Follow @crandycodesDon't miss an episode: Follow @AzureFriday

Data Integration is complex and helps organizations to combine data and complex business processes in hybrid data environments. The increase in volume, variety and velocity of data has led to delays in monitoring and reacting to issues. Organizations want to reduce the risk of data integration activity failures and the impact to other downstream processes.Manual approaches to monitoring data integration projects are inefficient and time consuming. As a result, organizations want to have automated processes to monitor and manage data integration projects to remove inefficiencies and catch issues before they affect the entire system.In this episode, Gaurav Malhotra joins Scott Hanselman to show how organizations can now improve operational productivity by creating alerts on data integration events (success/failure) and proactively monitor their Azure Data Factories.Jump To: [01:32] Demo Start Visually monitor Azure data factories - Alerts (docs)Create alerts to proactively monitor your data factory pipelines (blog post)Azure Data Factory documentationAzure Data Factory pricingCreate a free account (Azure)Follow @SHanselman Follow @AzureFriday Follow @DataAzure

HashiCorp Consul is a distributed service mesh to connect, secure, and configure services across any runtime platform and public or private cloud. In this episode, Scott Hanselman is joined by HashiCorp's Geoffrey Grossenbach who uses Helm to install a Consul server to Azure Kubernetes Service (AKS) cluster. Next, he deploys and secures a pair of microservices with Consul.Jump To: [00:50] Demo Start Consul Curriculum - HashiCorp LearnConsul by HashiCorpAzure Kubernetes Services (AKS)Intro to Service Meshes: Data Planes, Control Planes, and More | The Open Source ShowUse case: Modern service discovery with Consul on Azure (Part 1)Use case: Modern Service Mesh with Consul on Azure (Part 2)Create a free account (Azure)Follow @SHanselman Follow @AzureFriday Follow @HashiCorp

Azure Functions is a serverless compute service that enables you to run code on-demand without having to explicitly provision or manage infrastructure. Using Azure Functions, you can run a script or piece of code in response to a variety of events. Azure Data Factory (ADF) is a managed data integration service in Azure that enables you to iteratively build, orchestrate, and monitor your Extract Transform Load (ETL) workflows. Azure Functions is now integrated with ADF, enabling you to run an Azure function as a step in your data factory pipelines.Jump To: [01:30] Demo Start Azure Function activity in Azure Data Factory (docs)Azure Functions now supported as a step in Azure Data Factory pipelines (blog post)Azure Data Factory (docs)Azure Data Factory (overview)Azure Data Factory pricingCreate a free account (Azure)Follow @SHanselman Follow @AzureFriday Follow @DataAzure

Chris Anderson joins Donovan Brown to discuss how to use Azure Cosmos DB and other great Azure services to build a highly-scalable, real-time, collaborative application. You'll see techniques for using the Azure Cosmos DB change feed in both Azure Functions and SignalR applications. We also briefly touch on how custom authentication works with Azure Functions.Jump To: [06:15] Demo Start For more information:Configure multiple write regions in Azure Cosmos DBHave fun and draw awesome on the cosmic scale Azure #CosmosDB #PxDraw canvas today! (Build 2018 post)Azure Cosmos DB overviewPXDraw on GitHub (chrisanderson/pxdraw)Create a free account (Azure)Follow @donovanbrown Follow @AzureCosmosDB Follow @crandycodesDon't miss an episode - Follow @AzureFriday

What is it like to intern at Microsoft? Scott Hanselman meets with three interns from the Microsoft Explorer Program (a cross-discipline internship designed for college freshmen and sophomores) to talk about their experience working on the Azure Container Registry and their contribution of ACR Build and Task capabilities to the Visual Studio Code Docker Extension.Interns on this project:Jackson Stokes (University of Washington)Rutu Samai (California Polytechnic State University - San Luis Obisbo)Esteban Rey (Stanford University)Julia Lieberman (University of California - Santa Clara)For more information:Explore Microsoft ProgramDocker Extension for Visual Studio CodeAutomate OS and framework patching with ACR Tasks (docs)Azure Container RegistryDocker Support for Visual Studio CodeWorking with Docker (Visual Studio Code docs)Create a free account (Azure)Follow @SHanselman Follow @AzureFriday Follow @azure