Press "Enter" to skip to content

Category: Cloud

Sending E-Mails from Data Factory Pipelines

Published 2025-12-05 by Kevin Feasel

Andy Brownsword glues together a few resources:

Not all pipelines in Azure have native options for sending emails. The lucky Fabric folks have an Office 365 connection ready to rock. Data Factory and Synapse don’t have email capability built-in and need another option to send messages. So for everyone who wants more emails for their inbox rules to handle (delete), we’ll build and call a Logic App.

For this example we’ll have basic email parameters – To, Subject, Body – along with an optional attachment from a storage account. Also note that I’ve left all actions with their default names – if you change them make sure to update expressions accordingly.

Read on to see how it all works.

Leave a Comment

Access S3 Buckets in VPCs in Fabric via Entra Integration

Published 2025-12-03 by Kevin Feasel

Premal Shah announces new functionality in preview:

When we first introduced Amazon S3 shortcut integration with Microsoft Entra ID, customers gained a powerful new way to connect S3 data to Microsoft Fabric — without storing or rotating AWS access keys. Using OpenID Connect (OIDC), Fabric authenticates directly with AWS Identity and Access Management (IAM), enabling secure, identity-based access to cloud storage.

However, many enterprises keep their S3 buckets locked down inside Virtual Private Clouds (VPCs) or behind corporate firewalls. In these environments, Entra OIDC can authenticate identities, but it cannot provide network access — so Fabric still cannot reach the S3 endpoint. That changes today.

Read on to see what has changed, how you can enable this functionality, and current limitations.

Leave a Comment

Using the Microsoft Fabric Copy Job with Data in Dataverse

Published 2025-12-02 by Kevin Feasel

Laura Graham-Brown loads some data:

Dataverse is the data store behind parts of Dynamics and lots of Power Platform projects. So Dataverse can contain vital business data that will be needed for reporting. In this post we are going to look at one method which is using copy job with Dataverse to copy across data in Microsoft Fabric.

Click through to see how, including incremental data loads.

Leave a Comment

Copy Job in Fabric Data Factory Pipelines now GA

Published 2025-11-25 by Kevin Feasel

Jianlei Shen makes an announcement:

Copy Job Activity allows you to run Copy jobs as native activities inside Data Factory pipelines.

Copy jobs are created and managed independently in Data Factory for quick data movement between supported sources and destinations. With Copy job Activity, that same fast, lightweight experience is now embedded within pipelines, making it easier to automate, schedule, and chain Copy jobs as part of broader data workflows.

Read on for an overview of what’s in the activity and a few links on how to get started with it.

Leave a Comment

SQL Database in Fabric now GA

Published 2025-11-19 by Kevin Feasel

Anna Hoffman and Idris Motiwala make an announcement:

SQL is everywhere and Microsoft is innovating to deliver a unified experience across on-premises, cloud, and SaaS. One SQL unifies your data estate, bringing platform consistency, performance at scale, advanced security, and AI-ready tools together in one seamless experience, and SQL database in Fabric is no exception to that. At Microsoft Ignite, we’re thrilled to announce SQL database in Microsoft Fabric is officially Generally Available!

This is definitely a fluffy post, though Anna does have some linked videos that go into more detail.

Leave a Comment

Cutting Costs of Azure Self-Hosted Integration Runtimes

Published 2025-11-13 by Kevin Feasel

Andy Brownsword saves some quid:

If you have a Self-Hosted Integration Runtime (SHIR, or IR for short here) on an Azure Virtual Machine (VM), there’s a cost to keep it online. When used intermittently – for example during batch processes – this is inefficient for costs as you’re paying for the compute you don’t need. One way to alleviate this is by controlling uptime of the environment manually, only bringing it online for as long as needed.

Read on to see how to do this.

Comments closed

Optimized Locking and Change Event Streaming in SQL Server 2025

Published 2025-11-12 by Kevin Feasel

Deb Melkin is looking forward to a pair of features:

When I look at this release, I feel like I’ve been more tuned into what’s coming out than any other. I’m still not sure how that happened. But I think overall it’s a good thing because there really is a lot being packed into this release. If you’re just trying to figure out now, you’re already behind.

There are really 2 features that I’m really excited about:

Read on to learn more about both of them.

Comments closed

Microsoft Fabric Warehouse Snapshots now GA

Published 2025-11-11 by Kevin Feasel

Twinkle Cyril makes an announcement:

Managing data consistency during ETL has always been a challenge for our customers. Dashboards break, KPIs fluctuate, and compliance audits become painful when reporting hits ‘half-loaded’ data. With Warehouse Snapshots, Microsoft Fabric solves this by giving you a stable, read-only view of your warehouse at a specific point in time and now, this capability is Generally Available! Think of this as a true time travel database, an industry-first capability that sets us apart.

I wonder how much they differ from the database snapshots available in SQL Server.

Comments closed

An Overview of Azure Managed Cassandra’s Architecture

Published 2025-11-10 by Kevin Feasel

Amy Abel describes an architecture:

I’ve been learning about Azure Managed Cassandra recently, and it’s very different from the usual relational SQL Server database. The documentation and tutorials can seem confusing at first, but once I broke things down it was easier to understand basic concepts.

Read on for a warning about different flavors of Cassandra, as well as how Microsoft has organized things in their implementation of Cassandra.

Comments closed

Business Continuity Options in Azure

Published 2025-11-10 by Kevin Feasel

Aleksey Vitsko enumerates available options:

You may be familiar with high availability (HA) and disaster recovery (DR) features that are available in SQL Server and have experience configuring and managing them. But you have ever heard of or tried Azure high availability or Azure disaster recovery features. How can I learn more about what Azure brings in terms of HA and DR for Azure SQL offerings – including SQL VMs?

Read on for a variety of options depending upon whether you’re using SQL Server on a VM, Azure SQL Database, or Azure SQL Managed Instance.

Comments closed