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
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.
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.
How to deliver incremental insights using a data pipeline-based architecture to build data projections that feed your semantic model
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.
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.
This post explores an exciting, hidden new feature in DAX - the EVALUATEANDLOG function, which brings debugging capability to Power BI.
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.
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
Part 3 of the series deals with setting up a CI/CD process, building docker container images and hitting our first big problem.
Part 4 in this series covers Authentication & CORS issues encountered migrating from Azure Functions to Azure Container Apps.
.NET
领英推荐
Learn how to use high-performance code constructs like ReadOnlySpan<T> to parse and create UriTemplates for C# developers.
IT Strategy
Understanding the total cost of ownership is key to making informed decisions about technology investments
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.
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
Power BI Weekly