Azure Weekly
Issue #406 - 19th February 2023
There are a number of analytics based announcements this week. First off, the General Availability of Azure SSIS Integration Runtime in Azure Synapse Analytics, there's also an interesting article about Spatial analysis in Azure Synapse Analytics with ArcGIS GeoAnalytics Engine (I love this topic), there's also Native Support of Delta Lake in Azure Stream Analytics and you can now Use Azure Databricks in VS Code with the new Databricks extension.
Back on the topic of FinOps and Cloud Spend Reduction, there's a interesting post about Codename Project Bose: Calculate Azure Cost of an Enterprise by cost centers, divisions, projects, which provides a way to model you cloud spend in a way that reflects your org structure, and there's also a useful deep dive into Understanding Azure Savings Plans for Compute.
Finally, James Dawson has started a series charting our endeavour to migrate from Azure DevOps to GitHub Actions in Adventures in GitHub Actions: Episode 1 - Goodbye Azure DevOps, Hello GitHub Actions.
⚙️ AI + Machine Learning
- Melissa Ma talks about Speech Service Update - Pronunciation Assessment is Generally Available and Hierarchical Transformer for Pronunciation Assessment
- Jeff Teper explains how to AI, roadmap, community, and more at the Microsoft 365 Conference
- Matteo Pagani walks through Bringing OpenAI into an Outlook add-in: a business mail generator
- On the Azure Medium blog, Valentina Alto blogs about Querying structured data with Azure OpenAI
- On episode 321 of the Microsoft Cloud IT Pro Podcast, Scott Hoag and Ben Stegink (@msclouditpro) discuss ChapGPT comes to Bing
🔎 Analytics
- Chunhua Gu writes about General availability of Azure-SSIS Integration Runtime in Azure Synapse Analytics
- Praveen Kumar Sreeram (@PrawinSreeram) covers Azure Data Factory – Return value from a Child Pipeline to a Parent Pipeline
- Zac Hall writes about Spatial analysis in Azure Synapse Analytics with ArcGIS GeoAnalytics Engine
- Bhaskar Sharma covers Azure Synapse analytics dedicated SQL pool data modelling best practices
- On the Microsoft BI Tools blog, Joost van Rossum (@ssisjoost) describes how to Show dataset parameters in Azure Synapse Dataflow
- Kasun Indrasiri covers Azure Event Hubs Dedicated Self-Serve Scalable Clusters GA for Mission-Critical Streaming Workloads
- David Abu blogs presents a video series on how to use Power BI to analyse data: Enterprise Power BI Series
- Emma An writes about Native Support of Delta Lake in Azure Stream Analytics
- Tanmaya Panda explains how to Ingest Azure Databricks logs into Azure Data Explorer using Log4j2-ADX connector
- Katie Cummiskey describes how to Use Azure Databricks in VS Code with the new Databricks extension
- Mark Kromer (@kromerbigdata) announces You can now customize the return value from your pipeline
🖥️ Compute
- The Azure Updates Team announces the General Availablity of: Availability zones support for Azure Functions in new regions, and Azure Functions support for Python 3.10, and Durable Functions support for .NET isolated model and Azure Functions Linux Elastic Premium plan increased maximum scale-out limits
- The Azure Updates Team announces the Public Preview of: New General-Purpose VMs - Dlsv5 and Dldsv5, and SDK Functions type bindings and Functions Python 3.10 Support
- Gerasimos Alexiou describes how to do Azure batch run task with container image through az cli and json rest api
- Denver Brittain blogs about Getting Started with MongoDB Atlas and Azure Functions using .NET and C#
- Olesya Melnichenko describes RNA sequencing analysis on Azure using Nextflow: configuration files and benchmarking.
- Fletcher Kelly explains how to Configure LDAPS within Azure VMware Solution
🚢 Containers
- The Azure Updates Team announces Public preview: Upgrade scheduler and the Public Preview of Caching for ACR
- Jose Moreno (@erjosito) explains how to Are you following Azure best practices? Sure?
- Vinod Soni explains how to Create Azure Container Registry
🗄️ Databases
- The Azure Updates Team announces the Public Preview of: Serverless Hyperscale in Azure SQL Database, and VBS enclaves for Always Encrypted in Azure SQL Database, and Major version upgrade in Azure Database for PostgreSQL – Flexible Server and Cluster key index in Azure Cosmos DB for Apache Cassandra
- The Azure Updates Team announces the General Availability of Improved geo-replication for Azure Cache for Redis and Encryption using CMK for Azure Database for PostgreSQL – Flexible Server
- Pieter Vanhove describes VBS enclaves for Always Encrypted in Azure SQL Database – preview
- David Engel talks about OLE DB Driver 19.3 for SQL Server Released
- David Engel describes ODBC Driver 18.2 for SQL Server Released
- The Azure Updates Team talks about Azure SQL - General availability updates for mid-February 2023
- Kanchan Bharati writes about Major Version Upgrade in Azure PostgreSQL Flexible Server - Public Preview
- Harvey Mora blogs about Security Update for SQL Server 2016 SP3 Azure Connect Feature Pack GDR
- On episode 6 of thr Cosmos Down Under podcast, Greg Low (@greglow) talks with guest Vincent-Philippe Lauzon
- Morgan Oslake announces Automatic compute scaling with serverless for Hyperscale in Azure SQL Database
- Tanayankar Chakraborty covers Common Data Sync Errors received in Azure SQL DBDSS03513535Invalid Records
- Kevin Chant talks about T-SQL Tuesday 159 – Azure Synapse Link and certifications
- Kevin Chant walks through Deploying a dacpac to a serverless SQL pool
- On the Microsoft Mecanics show, Jeremy Chapman (@deployjeremy) talks about SQL Server 2022 updates for query performance and databasefailover
- Edwin Sarmiento (@EdwinMSarmiento) describes Running SQL Server Best Practices Check with Azure Data Studio to Assess your SQL Servers
- On the Data Exposed show, Anna Hoffman (@AnalyticAnna) and Bob Ward (@AnalyticAnna) talk about SQL Server 2022: Security, scalability, availability Ep. 4
🛠️ Developer Tools
- On the Premier Developer blog, Developer Support delves into Developer Support and MSDN/Visual Studio Subscription Benefits
- Anthony Bartolo (@WirelessLife) covers GitHub Copilot Update: New AI Model That Also Filters Out Security Vulnerabilities
- On the Visual Studio blog, Peter Groenewegen (@pgroene) writes about Visual Studio AI-Assistance: A Developers Best Friend
- Drew Skwiers-Koballa writes about Recently released: Updates to DacFx and Microsoft.Build.Sql
- Bryan Hogan describes how to Cache your SQL queries with Redis in C#
🔩 DevOps
- On the endjin blog, James Dawson (@James_Dawson) presents Adventures in GitHub Actions: Episode 1 - Goodbye Azure DevOps, Hello GitHub Actions
- Freek Berson (@fberson) writes about 5 fun and easy ways to transition to Bicep and save time
- Panu Oksala describes How to Access Restricted Azure Key Vault from Azure DevOps
- On the Premier Developer blog, John Folberth covers Azure DevOps Pipelines: If Expressions and Conditions
- Steven Ma explains how to Terraform on Azure February 2023 Update
- Gloridel Morales describes February patches for Azure DevOps Server
- Safeena Begum Lepakshi talks about Defender for DevOps - Configuration of DevOps Pipeline Classic and YAML method
- Vinod Soni covers Importing Business Requirements from Microsoft Word into Azure DevOps
🎭 Identity
- The Azure Updates Team announces General availability: Azure Active Directory for Azure Database for PostgreSQL – Flexible Server
- David Giard (@DavidGiard) describes Security Defaults in Azure Active Directory
🔌 Integration
- The Azure Updates Team blogs about Public Preview: Azure Communication Services Chat for Bot Framework
- Sunitha Muthukrishna talks about Azure Database for MySQL - Flexible Server connector for Power Automate and Logic Apps PREVIEW
- Kent Weare presents Part 4: BizTalk Server Migration to Azure Integration Services - Ask the Experts with Daniel Probert
- Mike Resnick blogs about Accessing Microsoft Graph Data with Powershell
- On BizTalk Gurus, Sandro Pereira (@sandro_asp) discusses Logic App/Power Automate Action Name to Code Translator Tool, and Logic App/Power Automate Action Name to Code Translator Tool .NET Framework and Logic App Consumption: Run after settings disabled and settings are missing
- Mark Brimble (@BrimbleMark) blogs about Logic App Management
- On episode 173 of the Ctrl+Alt+Azure podcast, Tobias Zimmergren and Jussi Roine are joined by Antti Pajunen to talk about Understanding Power Platform for Azure professionals
- David de Matheu explains how to Build a conversational SMS bot with Azure Communication Services and Azure OpenAI
- Julia Muiruri writes Access advancements in AI directly within the Power Platform
- Julia Kasper writes Build next-gen apps with OpenAI and Microsoft Power Platform
💡 Internet of Things
- The Azure Updates Team announces the Public Preview of: Import Jobs API Support in Azure Digital Twins, and Jobs API to support bulk import in Azure Digital Twins and Azure Digital Twins connector for Microsoft Power Platform
- The Azure Updates Team discusses GA: 50K relationships per twin support in Azure Digital Twins
- John Lian (@jlian) walks through Automatic IoT Edge Certificate Management with GlobalSign EST
📚 Learning
- On the Azure Developer Community Blog, Adam Jackson blogs about Upcoming Developer & Technical Events in the UK - Updated for 2023
- Lee Stott (@lee_stott) blogs about Microsoft Hack Together: Microsoft Graph and .NET 1st - 15th March
- On the Azure blog, David Dennis writes about 7 reasons to join us at Azure Open Source Day
- On The New Stack, Loraine Lawson writes about 3 Lessons Cheryl Hung Learned Working at CNCF
- Danny Guillory providesn a Skilling snack: Migrating from on premises to the cloud
⚖️ Management and Governance
- The Azure Updates Team announces the Public Preview: Azure Monitor container insights offers customizable cost optimization settings
- Nikita Bajaj blogs about Azure Automation Run As accounts retiring on 30 September 2023
- Lara Goldstein covers the different way of Consuming Microsoft Defender for Cloud Data
- Sravani Saluru discusses User Managed Identity support for Auditing Azure SQL Database is in Public Preview Now.
- On episode 232 of the Azure DevOps Podcast, Jeffrey Palermo (@jeffreypalermo) is joined by Lars Klint to discuss Microsoft Azure State of the Art
- Vlad Rodriguez explains how to Enable IT personnel to monitor SQL health and performance while reducing the insider risk
- Melissa Palmer (@vmiss33) explains how to Protect Your Data in Azure to Be Ready to Recover
- Pranab Paul talks about Codename Project Bose: Calculate Azure Cost of an Enterprise by cost centers, divisions, projects
- Dharshini Preethu lists the Top 5 Azure Cost Optimization Tools in 2023
- Sarah Lean (@TechieLass) talks about Understanding Azure Savings Plans for Compute
🚌 Migration
- On the SQL Server Blog, Rashida Hodge writes about Easily migrate SQL Server applications to the cloud with Azure
- Hiram Fleitas explains How to handle data updates in Azure Data Explorer
- Thomas Maurer (@thomasmaurer) writes about 5 Reasons to Use Azure Landing Zones for Your Cloud Migration
📱 Mobile
- On the Xamarin blog, James Montemagno (@JamesMontemagno) provides Tips & Tricks on Upgrading Xamarin.iOS & Xamarin.Android to .NET for iOS & Android
- Junior Saravia discusses Adding a New Android Permission in a Xamarin App
🌐 Networking
- Cary Roys explains What is an Azure Load Balancer
- Matt Lowe discusses Designs for Accomplishing Microsoft Sentinel Scalable Ingestion
- Patrick van Kleef (@patkleef) describes how to Design multi-cloud DNS architecture with Azure Private DNS Resolver
- Travis Roberts (@Ciraltos) describes How to Use Azure DNS Private Resolver and Inbound Endpoints
- Aidan Finn (@joe_elway) writes about Cannot Remove Subnet Because of App Service VNet Integration
- On episode 3 of the Wired for Hybrid show, Pierre Roman (@pierreroman) and Michael Bender discuss What's New in Azure Networking
🔐 Security
- Shawn Hernan discusses Microsoft Azure Security expands variant hunting capacity at a cloud tempo
- On the Azure blog, Dave Burkhardt talks about DDoS Mitigation with Microsoft Azure Front Door
- Charbel Nemnom (@charbelnemnom) describes Differences Between Microsoft 365 Defender And Microsoft Sentinel Discover Here
- Sean Wesonga covers Performing a Successful Proof of Concept PoC
- Wim Matthyssen (@wmatthyssen) describes how to Onboard an Azure subscription in Microsoft Defender for Cloud using an Azure PowerShell script
- On The New Stack, Loraine Lawson writes Too Much Access Is Your Kubernetes Achilles Heel
📦 Storage
- Edi Wang explains How to Automatically Move Blobs to Cool or Archive Tier After a Period of Time
- Koen Verbeeck (@Ko_Ver) explains how to Read an Excel File From Azure Blob Storage with an Azure Function
- Praveen Kumar Sreeram (@PrawinSreeram) walks through Securing Azure Storage Accounts – Restrict Users from Creating Public Blob Access with Azure Policy
- Geert van Teylingen describes Using Azure NetApp Files AVG for SAP HANA to deploy HANA with multiple partitions MP
- Sravani Saluru walks through Compressing Audit log files on Azure Blob Storage using ADF Pipeline for Azure SQL Database
🔗 Web
- Thomas Thornton (@tamstar1234) provides his Azure Load Testing Managed Service First Thoughts