Azure Weekly

Issue #209 - 27th January 2019

Some highlights from endjin: @MikeLarah describes How to run a script on an existing Azure Virtual Machine and @Carmel_Eve has written part 3 in her blog series about the inner workings of Rx LINQ operators - "Rx operators deep dive Part 3: Re-grouping our thoughts".

This week there were a few updates on the newly available Visual Studio 2019 Preview 2:

And here are the other announcements and updates for the last week:

⚙️ AI + Machine Learning

On the Azure blog, Greg Clark announces that Azure Cognitive Services adds important certifications, greater availability, and new unified key
Also on Channel 9, Noelle Lacharite (@NoelleLaCharite) presents Learn by Doing: A Look at Samples
Also on MSDN, Pete Laker covers Azure Speech Service: Example project for custom voices, transcribe videos & generate subtitles

🔎 Analytics

Chris Webb (@cwebb_bi) blogs about The Is Nullable Column Property In Power BI and describes the Power BI Roadmap Announcements In The April 2019 Release Notes
On the MSSQL Tips site, Koen Verbeeck (@Ko_Ver) explains how to Automate the Azure-SSIS Integration Runtime Start-up and Shutdown (Part 1)
On Geeks with Blogs, Darren Gosbell discusses: DAX Studio 2.8.0 Released
Also on the MSSQL Tips site, Gauri Mahajan blogs about Import data dynamically using R and Python in Power BI Desktop and Siddharth Mehta explains how to Generate visualizations in Power BI using Python Scripts
On MSDN, the SQL Server Engineering Team announces the release of SSRS2017+ Management Pack with Power BI Reporting Server Support 7.0.12.0
On TechNet, the Exchange Team walks through Monitoring Exchange Online User Client Access and Usage with Graph, PowerShell and Power BI
On the Power BI blog, Ranin Salameh announces a New monetization option for Power BI Custom Visuals through AppSource and Amanda Cofsky announces the Power BI Report Server Update &8211 January 2019
Also on the Azure blog, Manoj Raheja explains how to Analyze data in Azure Data Explorer using KQL magic for Jupyter Notebook
On MSDN, Adel Ghabboun writes: 'Recommendations API is retired Here is what you can do.'
On the Revolution Analytics blog, David Smith (@revodavid) announces RStudio Server on Azure

🖥️ Compute

Jason Roberts (@robertsjason) covers Dealing With Unprocessed Storage Queue Poison Messages in Azure Functions
On the endjin blog, Mike Larah (@MikeLarah) describes How to run a script on an existing Azure Virtual Machine
Peter Rombouts (@prombouts) blogs about Managing Virtual Machines in Azure with C#
On the Azure blog, Cale Teeter (@Windozer) announces that Hyperledger Fabric updates are now available
On Channel 9, Cale Teeter (@Windozer) talks about Hyperledger Fabric on Azure Block Talk
On MSDN, Vijetha Marinagammanavar explains how to Set up IIS on Windows Virtual Machine
Also on MSDN, The AzureCAT team announces a New E-Book: Install TmaxSoft OpenFrame on Azure
On Code Project, Tom Ling discusses Azure Functions 2.0 HTTP Routing Options
On Code Project, Apriorit discusses Hooking Linux Kernel Functions, Part 3: What Are the Main Pros and Cons of Ftrace and writes about Silently Installing a Service on a Virtual Machine Using Libguestfs
Steve Buchanan (@buchatech) talks about Azure Blockchain Workbench Whitepaper
Also on MSDN, The AzureCAT team writes about High Performance Computing on Azure – Portal
the Azure updates team writes about General availability: Azure Guest OS Family 6 Windows Server 2019

🚢 Containers

Jose Moreno (@erjosito) provides A Day in the Life of a Packet in Azure Kubernetes Service part 1: Azure CNI
The Azure updates team highlights Azure Container Instances Memory Duration and vCPU Duration GUID migration
On MSDN, Matt Cooper (@vtbassmatt) blogs about Using containerized services in your pipeline
Daniel Neumann (@neumanndaniel) describes Running Azure Functions on Kubernetes like on Azure in the consumption plan
On the Microsoft Cloud IT Pro Podcast, Ben and Scott present Episode 109 – Fitness Trackers for Work
Trevor Sullivan (@pcgeek86) explains how to Build Docker Container for PowerShell on Raspberry Pi

🗄️ Databases

The Azure Updates Team announce Public preview: Read replicas in Azure Database for PostgreSQL
On Channel 9, Donovan Brown Rob Caron talks about An intro to Azure Cosmos DB JavaScript SDK 2.0 Azure Friday
On MSDN, Jose M Jurado (@jmjuradodiaz) says It is possible to create Linked Server in Azure SQL Managed Instance, describes Using Cross Database Queries in Azure SQL Managed Instance, and Using Partition Option in Azure SQL Managed Instance, and talks about Azure SQL Database – Using Read Scale Out option, Azure SQL Database – The type xml is not supported with external tables for sharded data., Azure SQL Database – SSH, VNET and Firewall and Azure Database – SQL Connectivity Checker
Also on MSDN, Jovan Popovic (@jocapc) explains how to Recreate dropped database on Azure SQL Managed Instance
Also on MSDN, Julio Calderón explains How to auto-scale an Azure Database for MySQL/PostgreSQL instance with Azure run books and Python
On Channel 9, Jasmine Greenaway (@paladique) covers Five Reasons Why You Should Check Out Cosmos DB
Also on MSDN, Jose M Jurado (@jmjuradodiaz) covers Using Schemas in Azure SQL Managed Instance
On the Azure podcast, John Kozell describes Operationalizing Cosmos DB
On MSDN, Jovan Popovic (@jocapc) delves into Getting started with Azure SQL Managed Instance

🛠️ Developer Tools

Richard M. Hicks (@richardhicks) writes about Always On VPN ProfileXML Editing and Formatting with Visual Studio Code
Scott Hanselman (@shanselman) explains How to use Windows 10's built-in OpenSSH to automatically SSH into a remote Linux machine and describes NuGet's fancy older sibling FuGet gives you a whole new view of the .NET packaging ecosystem
On the Azure blog, Jenny Jiang announces that HDInsight Tools for Visual Studio Code now generally available
Ravikanth Chaganti (@ravikanth) describes Azure at the command line (Experts Live India)
Scott Hanselman (@shanselman) writes about Remote debugging with VS Code on Windows to a Raspberry Pi using .NET Core on ARM and describes How to use Windows 10's built-in OpenSSH to automatically SSH into a remote Linux machine
Thuan Soldier (@nnthuan) blogs about how to Query private IP Address using Azure CLI
The Azure Updates Team announces that HDInsight Tooling has new capabilities
On TechNet, Syed Shanu (@syedshanu3) writes about Image Processing Bot using MS Bot Framework and Computer Vision SDK
On Channel 9, Christina Warren (@film_girl) talks about Alexa Azure DevOps Skills, Hacking Your Career, ML.NET 0.9, 6502 Assembly in VS Code, and more...
Also on Channel 9, Sayed Hashimi (@sayedihashimi) presents Visual Studio for Mac: Build Your First App Visual Studio Toolbox
Also on Channel 9, Ramya Achutha Rao (@ramyanexus) asks Is VSCode only good for JavaScript?
On Visual Studio Magazine - Columns, Terrence Dorsey writes about 21 New Tools and Extensions for Visual Studio 2017
On Microsoft Cloud Blogs, Brad Anderson (@Anderson), Microsoft's Corporate VP for Enterprise Mobility, describes Simplifying device management for schools with Microsoft Intune and Windows Autopilot
Sam Cogan (@samcogan) explains how to Announcing: Azure Snippets Series

🔩 DevOps

Jakob Ehn (@jakobehn) talks about Creating a Windows Container Build Agent for Azure Pipelines
Jeremy Lindsay (@jeremylindsayni) walks through Setting up relationships between work witems on Azure DevOps boards, and using .NET to read these relationships
On MSDN, Herald Gjura (@Herald_Gjura) talks about Hosting Python packages in Azure DevOps
Also on MSDN, Edward Thomson (@ethomson) lists the Top Stories from the Microsoft DevOps Community
Also on MSDN, Erin Dormier announces that Azure DevOps Server 2019 RC2 now available
On Channel 9, Houssem Dellai (@HoussemDellai) talks about Verifying your Database Deployment with Azure DevOps

🎭 Identity

On MSDN, Jose M Jurado (@jmjuradodiaz) blogs about Azure Active Directory – Universal with MFA authentication – Output Window Trace Level
On TechNet, Jasmine Perez (@jaszjp) describes Azure AD Application Proxy Cookie Settings
Also on TechNet, Taehee Lee describes Workplace Join/Device Registration to Azure AD for Local Domain joined Windows 7 and 2012
On MSDN, Nicola Delfino (@NicolTwit) describes Cross micro services authentication with Azure B2C

🔌 Integration

On the Planet Geek blog, Daniel Marbach (@danielmarbach) discusses Azure Service Bus Topologies of NServiceBus
On the Codit blog, Tom Kerkhove (@TomKerkhove) describes Accepting Azure Event Grid events with Azure API Management
On the Azure blog, Ashish Chhabria (@ashishc1) announces that Azure Service Bus and Azure Event Hubs expand availability
On the Kloud blog, Robbie Vidler discusses Azure Automation MS Flow Hybrid Workers SharePoint List upload CSV output
On TechNet, Amanda Buchholz brings us: Learn how to extend Azure on-premises and build innovative hybrid applications
the Azure updates team covers Azure API Management update January 25

💡 Internet of Things

On the Azure blog, Peter Provost (@pprovost) talks about Connecting Node-RED to Azure IoT Central
On the Azure blog, Reza Sherafat writes: Introducing IoT Hub device streams in public preview
On MSDN, Jeff Chilberto (@JChilberto) presents Azure Content Spotlight – Cognitive Services
On Channel 9, Olivier Bloch (@obloch) talks about how to Export data from your IoT Central app to Azure Event Hubs and Azure Service Bus and Reza Sherafat covers Azure IoT Hub Device Streams
Also on the Azure blog, Vivian Liu announces that you can now Export data in near real-time from Azure IoT Central

⚖️ Management and Governance

On the Azure podcast, Sujit D'Mello presents a Partner Spotlight - Aqua Security
On the Catapult Systems blog, David Vanderslice delves into Azure Resource Manager Templates – Part One – VM Extensions
the Azure updates team covers Azure Monitor for containers: January updates and covers Public preview: Azure Monitor for containers support for AKS-engine
On the Azure blog, Rob Caron (@RobCaronMSFT) delivers Azure.Source - Volume 66
On MSDN, Azure Monitoring Services Health Status blogs about Experiencing Data Gaps issue in Azure Portal for Public Preview Custom Metrics from MDM – 01/25 – Investigating, blogs about Experiencing Data Gaps issue in Azure Portal for Public Preview Custom Metrics from MDM – 01/25 – Resolved and covers Experiencing Data Gaps issue in Azure Portal Custom Metrics from MDM – 01/27 – Investigating
Daniel Örneling (@DanielOrneling) highlights that The OMS portal is retired
On MSDN, Adel Ghabboun explains how to get Alerts based on Analytics query using Custom log search and describes Customizing Alert notification email in Azure monitoring
Robert Smit (@Clustermvp) writes about Secure DevOps Kit for Azure AzSK With Security Monitoring
On Channel 9, Gaurav Malhotra (@GauravMalhot12) talks about how to Monitor your Azure Data Factory pipelines proactively with alerts
Vincent-Philippe Lauzon (@vplauzon) discusses the Azure Application Insights Role Name Nuget Package
Also on Code Project, The Intel Corporation (@intel) describes Deploying Multiple Intel Distribution of OpenVINO Toolkit Workloads with Microsoft Azure on the IEI Tank AIoT Developer Kit
On MSDN, Raiyan Alam (@RaiyanAlam5) walks through Automating Releases in GitHub through Azure Pipelines
Thomas Janetscheck (@azureandbeyond) describes How to securely deploy Azure infrastructures with Terraform
On the endjin blog, Mike Larah (@MikeLarah) walks through How to run a script on an existing Azure Virtual Machine

⚙️ Microsoft Azure Stack

Stefan Roth (@stefanroth_net) discusses how to Use Function To Generate SAS Token For Blob Content (Azure Stack)
Charbel Nemnom (@charbelnemnom) explains how to Deploy Remote Desktop Services RDS On Azure Stack

🚌 Migration

On The SQL Blog, Sergio Govoni (@segovoni) covers SQL Server Data Migration: Tools and Services
On the Azure blog, Taylor Cox announces that HDInsight Metastore Migration Tool open source release is now available
the Azure updates team announces Support for Amazon RDS for SQL Server to Azure SQL Database online migrations, Support for Amazon RDS for PostgreSQL to Azure Database for PostgreSQL online migrations and Support for Amazon RDS for MySQL to Azure Database for MySQL online migrations
On TechNet, Chris Walden describes How to prepare for a move to Azure with Azure Migrate
Also on MSDN, Karina Homme (@karinalhomme) writes - Join us: Accelerating Gov Cloud in a Cloud Smart World

📱 Mobile

On the Tech Radar site, Matt Hanson presents Windows 10 ARM shown running on an old Lumia 950 XL
On Channel 9, James Montemagno (@JamesMontemagno) presents: Battery (Xamarin.Essentials API of the Week)
On Code Project, Chandru BK gives us: Xamarin Forms - Validations made simple
Also on Code Project, Harshit Gindra discusses Xamarin Forms Integration with Google Admob
On the Xamarin blog, Matt Soucoup (@CodeMillMatt) presents the Visual Studio Mobile Developer Podcast: New Year – New Pod
On the Xamarin blog, Pierce Boggan (@pierceboggan) highlights Whats New for Xamarin Developers in Visual Studio 2019 Preview 2

🌐 Networking

James van Den Berg (@JamesvandenBerg) explains how to Learn more about the Azure Monitor – Insights – Network Watcher Video Azure Analytics Insights Azuremonitor

🔐 Security

On the MSSQL Tips site, John Miner (@JohnMiner3) blogs about Microsoft Azure Key Vault for Password Management for SQL Server Applications
On the Azure blog, Ronit Reger announces that Regulatory compliance dashboard in Azure Security Center is now available
On Microsoft Cloud Blogs, Kim Kischel (@KimKischel) writes: Microsoft Cloud App Security and Windows Defender ATP - better together
On TechNet, Stanislav Belov gives us Infrastructure + Security: Noteworthy News January, 2019
James van Den Berg (@JamesvandenBerg) explains how to Optimize Security and Compliancy with Azure Security Center

📦 Storage

On the MSSQL Tips site, Ron L'Esteve explains how to Write Federated U-SQL Queries to Join Azure Data Lake Store Files to Azure SQL DB and John Martin explains how to Install DBATools with Azure VM Custom Script Extension - Azure Blob Storage
On the Azure blog, Vishnu Charan announces that Azure Backup now supports PowerShell and ACLs for Azure Files
The Azure Updates Team announces the Azure FXT Edge Filer Avere Update
On TechNet, Richard Spitz (@richardespitz) writes about how to Synchronously copy all managed disks of an Azure Virtual Machine to Azure Storage Accounts in multiple Azure regions

🔗 Web

On the Azure blog, Mike Budzynski announces the preview of OpenAPI Specification v3 support in Azure API Management
On TechNet, the Cloud Platform Team discusses the Cloud Release Announcements for January 23, 2019
On Code Project, a member discusses Google AppEngine WebApp with Datastore and Firebase using Nodejs