Azure Weekly
Issue #312 - 21st February 2021
This week, the updates team announces that Application Insights work item integration for Azure DevOps & GitHub is in public preview. That Azure role-based access control RBAC for Azure Key Vault data plane authorization is now GA, and that API Management Diagnostics is now available in public preview.
Anuj Chaudhary provides a PowerShell sample for Privileged Identity Management (PIM). Leo Li runs through how to analyze root cause and impact using ADF ETL lineage in Azure Purview. Zeinab Mokhtarian Koorabbasloo describes how to apply M365 Sensitivity Labels across your data assets in Azure Purview.
After two years of open source development Dapr has reached v1.0 - congratulations to the team & contributors 👏👏👏
Finally, we end with an interesting open source project called Bellhop, to easily "turn down" Managed services in Dev/Test environments, particularly when referring to scaling between the available service tiers. It's serverless and built using Azure Functions.
⚙️ AI + Machine Learning
- On Microsoft + Open Source, Sarah Bird, Besmira Nushi and Mehrnoosh Sameki discuss Enabling responsible AI development with new open source capabilities
- The Azure Updates Team announces that Azure Machine Learning updates for native terminal are generally available
- Krishna Doss highlights that Translator announces Document Translation (Preview)
🔎 Analytics
- On the MSSQL Tips site, Fikrat Azizov explains how to Analyze data skew issues with Azure Synapse Analytics
- Also on the MSSQL Tips site, Ron L'Esteve writes about Incrementally Upsert data using Azure Data Factory's Mapping Data Flows
- On the Hanu blog, Dave Sasson describes How to Succeed with Big Data and Microsoft Azure in 2021
- Meagan Longoria (@mmarie) discusses Azure Data Factory Activity Failures and Pipeline Outcomes
- On Tech Community blog, Charl Roux (@charl0204) explains Spark Table to Serverless Pool Metadata Sync
- On the Microsoft BI Tools blog, Joost van Rossum (@ssisjoost) walks through Scaling Azure Analysis Services with ADF only
- The Azure updates team announces that .NET Core support for Analysis Services client libraries is generally available
- Luis Soares delves into Azure Synapse SQL Pools Auto DR
🖥️ Compute
- The Azure Updates Team announces that Automatic Azure VM extension upgrade capabilities are now in public preview, Azure Dav4-series VMs are available in Azure HDInsight and that Cross Region Restore of Azure VMs are now generally available
- Andrew Coughlin covers how to Upload Custom Linux Hyper-V Image for Gen 2 VM in Azure
🚢 Containers
- On the Dapr Blog, the Dapr Maintainers (@daprdev) are excited to Announce Dapr v1.0 - this is a fantastic project for anyone looking to build distributed (micro-service) applications on-prem and in any cloud. Congratulations Team! 👏👏👏
- Robert Smit (@Clustermvp) explains how to Distributed Application Runtime Dapr version 1.0
- On the Microsoft DevOps blog, Jay Gordon (@jaydestro) discusses Dapr on Azure
- The Azure Updates Team announces that Azure Red Hat OpenShift support for OpenShift 4.6 is generally available
- Srini Padala blogs about Container Image builds on Kubernetes clusters with Containerd and Azure DevOps self-hosted agents
- Peter Groenewegen (@pgroene) walks through Getting memory dump from .Net core Linux container on AKS
- Peter Pogorski highlights the Service Fabric managed clusters 2021-01-01-preview release
- Peter Pogorski talks about Azure Service Fabric Sixth Refresh Release
- Michael Crump (@mbcrump) walks through How to use Deployment Slots in Azure App Service for Containers
🗄️ Databases
- The Azure Updates Team announces that More ways to use composite indexes in Azure Cosmos DB are now generally available and and Azure Database for PostgreSQL – Hyperscale Citus audit logging via pgAudit now in public preview
- Dandan Zhang blogs about Investigating connection issues with Azure Database for MySQL
- On Channel 9, Silvano Coriani (@scoriani) explains How Azure SQL Enables Real-time Operational Analytics (HTAP)
- On the Azure blog, Rahul Ajmera highlights that the Apache Spark Connector for SQL Server and Azure SQL now compatible with Spark 3.0
- On the DEV site, Davide Mauri (@mauridb) talks about The insert if not exists challenge: a solution
- Liliam Leme discusses Troubleshooting Performance on SQL On-demand or Serverless
🛠️ Developer Tools
- On Channel 9, Brigit Murtaugh (@BrigitMurtaugh) talks about Remote dev with Containers & Codespaces
- Lomis Chen writes about the Latest improvements to the Azure CLI experience
- Luise Freese describes How to send Adaptive Cards with CLI Microsoft 365
- Maxime Rouiller (@MaximRouiller) writes: From classic Command Prompt to fully customizable Terminal
- Pascal Naber (@pascalnaber) explains why you should Stop using ARM templates! Use the Azure CLI instead
🔩 DevOps
- The Azure Updates Team announces that Application Insights work item integration for Azure DevOps & GitHub is in public preview
- Carter Socha discusses the Updated Work Item Integration
- On the Microsoft DevOps blog, Vijay Machiraju highlights a Change in Azure Pipelines Grant for Public Projects
- On the Microsoft BI Tools blog, Joost van Rossum (@ssisjoost) provides a quick intro to the Keyboard Shortcuts YAML editor
- Thomas Thornton (@tamstar1234) blogs about how to Remove the need to hard-code in Azure DevOps Pipelines
- Kevin Chant runs through some Experiments to use Azure DevOps with Azure Synapse Analytics SQL Pools
- Angel Wong highlights that Billing and Token Management events are now available in Auditing
- On the DEV site, Abel Wang (@abelsquidhead) discusses Agile Development
- Steve Buchanan (@buchatech) talks about Cloud Native, DevOps, GitOps, Kubernetes, and Azure
🧬 Hybrid
- Thomas Maurer (@thomasmaurer) discusses Secure Hybrid Cloud with Azure Arc
- On Azure Friday, Scott Hanselman (@shanselman) talks about Building modern hybrid applications with Azure Arc and Azure Stack
- On the Azure blog, Jaspreet Kaur runs through Azure Automation 2020 recap and whats new
- Vijay Kumar covers how Customers unify hybrid and multicloud IT operations with Azure Arc
- The Azure Updates Team announces Machine Learning on Azure SQL Managed Instance now available and Log Replay Service for Azure SQL Managed Instance in public preview
- Jose M Jurado (@jmjuradodiaz) writes: Cannot show requested dialog obtaining properties database in Managed Instance
- Thomas Maurer (@thomasmaurer) explains how to Manage Certificates on your Hybrid Servers using Azure Arc Key Vault Extension
🎭 Identity
- Anuj Chaudhary provides a PowerShell sample for Privileged Identity Management (PIM)
- Vlad Dancescu discusses Restricting API Management access to users through AAD
- On the Codit blog, Gonçalo Chaves describes OAuth1.0 Authentication for Azure Functions with RestSharp
- Damien Bowden (@damien_bod) describes Adding ASP.NET Core authorization for an Azure Blob Storage and Azure AD users using role assignments
🔌 Integration
- Ashish Chhabria announces general availability for Java Message Service JMS 2.0 API on Azure Service Bus Premium.
- Paul Lee explains How to send messages to or receive from Service Bus/Event Hub with Service Bus Explorer
- Gregor Suttie (@gregor_suttie) describes Azure Durable Functions – Support Caller
💡 Internet of Things
- The Azure Updates Team announces that the Azure IoT Edge 1.1.0 release is now generally available and that the Azure Sphere OS version 21.02 is now available for evaluation
📚 Learning
- On the Azure Developer Community Blog, Nitya Narasimhan (@ntiya) provides A Visual Introduction To Azure Fundamentals
- Joe Carlyle (@wedoAzure) provides an AZ-500 (Microsoft Azure Security Technologies) Study Guide
- Charbel Nemnom (@charbelnemnom) provides a AZ-140 Exam Study Guide: Configuring and Operating Windows Virtual Desktop on Microsoft Azure
⚖️ Management and Governance
- The Azure Updates Team has made a few announcements:
Azure Cost Management now available for Azure Government Pay-As-You-Go subscriptions,
Public preview: Azure Cost Management + Billings cost allocation now available in Azure Government,
Azure Purview available in public preview in South Central US and Canada Central,
Application Insights availability troubleshooting report for URL tests,
Generally available: Application Insights synthetic monitoring SLA report template,
Public preview: Application Insights auto-instrumentation for .NET5 App Services
and New disk burning metrics in Azure Monitor - Carter Socha writes about how to Easily calculate SLA, downtime, and outages of your App Insights Availability Webtests
- Halaa Menasy discusses Azure Logging and Monitoring for ISVs
- On SQL Server Central, Johan Hln writes about Getting Started with Azure Purview
- Also on SQL Server Central, Ron L'Esteve runs through Azure Data Factory Pipeline Logging Error Details
- Leo Li explains how to Analyze root cause and impact using ADF ETL lineage in Azure Purview
- Zeinab Mokhtarian Koorabbasloo explains how to Apply M365 Sensitivity Labels across your data assets in Azure Purview
- Goran Condric explains how to Optimize your Azure Costs by Automating SAP System Start – Stop
- Sarah Lean (@TechieLass) highlights the One Ops Question Video Series
- Sarah Lean (@TechieLass) covers Azure Policy
- Dave Ruijter (@daveruijter) describes How to colorize each Azure Databricks workspace differently
- Srihari Senthil disusses the Top 3 approaches to monitor the health status of Azure Event Hubs
- On The Azure Podcast, Matthew Garrett and Tyler Peterson talk about Bellhop
- Itay Podhajcer (@ItayPodhajcer) walks through a Simple Terraform Wrapper Module for Deploying an Azure Blockchain Service
🚌 Migration
- Radu Vunvulea (@RaduVunvulea) writes about SQL migration to Azure with near-zero downtime
- On Channel 9, Matt Basile, Jobi George and Thomas Ganka discuss Ingesting and migrating data the DataOps way
- Also on Channel 9, Sarah Lean (@TechieLass) talks about Azure Migrate
- Simon Timms (@stimms) discusses Microservices Architecture
- On the Microsoft DevOps blog, Steven Murawski (@StevenMurawski) discusses On Prem To The Cloud: Getting Started
- Danimir Ljepava (@danimir) explains how to Migrate databases from SQL Server to SQL Managed Instance using Log Replay Service
📱 Mobile
- On Channel 9, Steven Thewissen (@devnl) talks about MultiConverter & VariableMultiValueConverter
🌐 Networking
- On the Azure blog, Eliran Azulai highlights: Azure Firewall Premium now in preview
- The Azure Updates Team announces that Standard Load Balancer and IP addresses metadata are now available through Azure Instance Metadata Service IMDS and that Azure Firewall Premium is now in public preview
- On Channel 9, Christian Kuhtz (@ckuhtz) talks about How to get better outbound connectivity using Azure NAT Gateway
- Akihiro Nishikawa (@Logico_jp) discusses an issue: Unable to access SQL Database connected via Service Endpoint after database failover occurs
- Jithin Jose discusses Accelerated Networking on HB, HC, HBv2 and NDv2
- Yousef Khalidi (@YousefkAzure) writes about how to Future-proof your network with Azure for Operators
🔐 Security
- The Azure Updates Team announces that Azure role-based access control RBAC for Azure Key Vault data plane authorization is now generally available
- Charbel Nemnom (@charbelnemnom) explains how to Get Azure Overall Secure Score from REST API
- Or Serok-Jeppa runs through how to Continuously Export Secure Score for Over-Time Tracking and Reporting (Preview)
- On Azure Sentinel blog, Lia Tlishaa covers The Toolkit for Data-Driven SOCs
- Also on Azure Sentinel blog, Rijuta Kapoor covers how to Use Microsoft Azure Sentinel and Anomali Match for actionable threat detection
- On the DEV site, Justin Yoo (@justinchronicle) talks about KeyVault Secrets Rotation Management in Bulk
- On the Azure blog, Amit Srivastava talks about how Azure Front Door enhances secure cloud CDN with intelligent threat protection
📦 Storage
- The Azure Updates Team announces a Volume hard quota change in Azure NetApp Files
🔗 Web
- The Azure Updates Team announces that API Management Diagnostics now available in public preview
- Joe Lurie highlights Endpoint management deep dives + Q&A in March
💻 Windows Virtual Desktop
- Robert Smit (@Clustermvp) highlights that Windows Virtual Desktop metadata is now available in West Europe
- Nicole Haugen covers Choosing Between Azure Lab Services and Windows Virtual Desktop for Your Educational Scenarios