Digest for October 2022

Digest for October 2022

News

So where did October go? One internal project we completed was the migration of endjin.com over to Azure Static Web Apps (SWA); as we're getting over 750,000 page views per year, we needed a platform that could easily handle the demands of a global readership who ??reading the 1000s of blog posts we've published over the last 12 years. It was a straightforward process, that enabled us to move our DevOps process for publishing content over to GitHub Actions, and the end result improved our Google PageSpeed Insight score to 97 (mobile) / 100 (desktop).

Charlotte Gayton, who was part of our internship 2021 cohort, has rejoined us for a year in industry placement, and has kicked off a programme to make our 50+ open source projects OpenChain compliant. More on this over the course of the next year.

We were also busy preparing for our Modern Data DevOps with Azure Synapse Analytics workshop, which was scheduled for the first week of November. More on this in next month's newsletter!

Blog Posts

We've had a busy month, publishing at least one new post per day.

Azure Synapse Analytics, Power BI & Power Platform

What is a Lake Database in Azure Synapse Analytics?

Lake Databases in Azure Synapse Analytics are just great. If you're starting on a new Synapse Analytics project, chances are you can benefit from Lake Databases. Whether you need to analyze business data from Dataverse, share your Spark tables of data with SQL Serverless, or use Database Templates to visually design and define your standardized/semantic analytical data model, there's a use-case for you. This blog post explores what Lake Databases are, why they're useful, and what you need to watch-out for when using them.

Customizing Lake Databases in Azure Synapse Analytics

Custom Objects in Lake Databases allow you to create VIEWs, Stored Procedures, USERs (amongst other objects) in what used to be a read-only database. This article explores the customization options and how it can help you organize your reporting data in Azure Synapse Analytics.

Insight Discovery (part 5) – Deliver insights incrementally with data

How to deliver incremental insights using a data pipeline-based architecture to build data projections that feed your semantic model

Insight Discovery (part 6) – How to define business requirements for a successful cloud data & analytics project

In the final part of this series on running successful data analytics project, we delve into the techniques we use such as the "double diamond" approach to create a prioritised backlog of insights.

5 lessons learnt from using Power Automate

We've just completed a project which pushed the limits of what's achievable modelling real-world business processes with "low code / no code" tooling. Here are our top 5 lessons from using Power Automate.

EVALUATEANDLOG in DAX

This post explores an exciting, hidden new feature in DAX - the EVALUATEANDLOG function, which brings debugging capability to Power BI.

What are Synapse Analytics Database Templates and why should you use them?

In this blog series we explore the newly released Azure Synapse Analytics Database Templates. We put them into action to understand how they can be leveraged as part of a modern data pipeline.

How to create a semantic model using Synapse Analytics Database Templates

In part 2 of the series about Azure Synapse?database templates, focuses on how you use them to create semantic models, by providing a step-by-step guide.

DevOps, Cloud Native & Azure

Bye bye Azure Functions, Hello Azure Container Apps: Build and deployment pipelines, and our first big problem

Part 3 of the series deals with setting up a CI/CD process, building docker container images and hitting our first big problem.

Bye bye Azure Functions, Hello Azure Container Apps: Authentication and CORS issues

Part 4 in this series covers Authentication & CORS issues encountered migrating from Azure Functions to Azure Container Apps.

.NET

High Performance UriTemplate resolution with low-allocation C#

Learn how to use high-performance code constructs like ReadOnlySpan<T> to parse and create UriTemplates for C# developers.

IT Strategy

How to calculate the total cost of ownership (TCO)

Understanding the total cost of ownership is key to making informed decisions about technology investments

Putting total cost of ownership (TCO) into action

In this third and final blog in the series on TCO, we explore how TCO can be used to drive action throughout the lifecycle of a digital asset.

My first year as an Apprentice Engineer

Eli Gascon shares her retrospective of the first year in her journey of going from a Maths Graduate to a Software Engineer.

Newsletters

We publish two free weekly email newsletters: Azure Weekly on a Sunday, and Power BI Weekly on a Tuesday. Here's your chance to catch up with all the updates and announcements!

Azure Weekly

Issue 389: 2nd October 2022

  • Azure Cost Optimisation
  • Demystifying Data Explorer
  • Monitor Microservices App using Azure Managed Grafana
  • Publishing Scripts to the PowerShell Gallery
  • Continuous Integration with GitHub Actions
  • Remove Azure Secrets committed to GitHub
  • Partition Key Best Practices in Cosmos DB
  • Introducing AI-generated voices for Azure neural text to speech service.

Issue 390: 9th October 2022

  • Azure Firewall Basic now in preview
  • Advancing anomaly detection with AIOps - introducing AiDice
  • How to work with Python in Azure Data Studio
  • Learn Data Science and Machine Learning in 30 Days

Issue 391: 16th October 2022

  • Microsoft Ignite 2022 Book of News
  • Making cloud native easier: Architecting the next-gen Azure PaaS
  • Automated cloud application testing with Azure and Playwright
  • Hidden gems and live coding with .NET 7
  • Ask the Experts: Introducing Microsoft Syntex – Content AI for the Microsoft Cloud
  • Deep dive into Dapr.io and Cloud Native Architectures
  • Inside Azure Innovations with Mark Russinovich

Issue 392: 23rd October 2022

  • Leverage SFTP support for Azure Blob Storage
  • Microsoft Takes Kubernetes to the Edge with AKS lite
  • Understanding container images - The fundamentals
  • Background Workers in Azure Container Apps with KEDA

Issue 393: 30th October 2022

  • Farmer for Azure Deployments
  • Introducing Vision Studio
  • Techniques for populating a Synapse Analytics Database Template
  • Customizing Lake Databases in Azure Synapse Analytics
  • Handling UK Bank Holidays in Azure Data Factory & Synapse
  • Create dashboards in Azure Data Explorer
  • Deploy from GitHub to Azure without any secrets using managed identities
  • Use managed identity instead of AzureWebJobsStorage to connect a function app to a storage account
  • Estimating Azure Diagnostics Cost
  • Forrester Total Economic Impact study: Azure Arc delivers 206 percent ROI over 3 years

Power BI Weekly

Issue 177: 4th October 2022

  • RANKX in DAX
  • Everything you need to know about Bookmarks in Power BI
  • Row Level Security, Object Level Security, Data Masking and their Business Use Cases

Issue 178: 11th October 2022

  • Deployment pipelines – announcing "Deployment History" feature and "Azure DevOps extension" GA
  • Power BI Workspace Strategy for Self Service within Premium Capacities
  • Power BI Pacman.

Issue 179: 18th October 2022

  • Microsoft Ignite 2022: Do more with enterprise self-service business intelligence
  • Cross-tenant Power BI Dataset Sharing
  • Office 365 meet Power BI Desktop
  • Power Query SDK for Visual Studio Code – Public Preview
  • New DAX Functions in Excel Data Models and Power Pivot
  • No More Auto Aggregations in Dimension Tables

Issue 180: 24th October 2022

  • Power BI October 2022 Feature Summary
  • Quick measure suggestions
  • Relationship editing in the properties pane
  • DAX formula bar support for Desktop model view
  • Download a PBIX from the Power BI Service for more scenarios
  • Submetric roll ups in Power BI Metrics

要查看或添加评论,请登录

endjin的更多文章

社区洞察

其他会员也浏览了