A Fine Slice Of SQL Server
Olivier Van Steenlandt troubleshoots an issue:
When setting up database mirroring from Azure SQL to Microsoft Fabric for one of my demo databases, I ran into an issue while trying to connect to my Azure SQL database.
As you can see in the screenshot above, it seems that a setting on my logical SQL Server in Azure is misconfigured. Let’s resolve that in a couple of steps.
Click through for the screenshot, the specific error, and how Olivier was able to get things working.
Leave a CommentJon Lunn digs into a somewhat-new feature:
So first off, what are they? They are basically a table object that is based on a query. (Yes I know they are called ‘Views’… more on that later) So like a view, it is defined by a SQL query, but it doesn’t just sit over tables and runs that SQL when you query that view. What it does do is take the ‘View’ SQL query that defines the Materialised Lake Views, runs it and stores the query result data into a delta table. So when you query that view, you get the data from that object, and not the underlying tables. Neat! Save a bit on computing query time!
Read on to learn more about what they are, how they work, and when they can be useful.
Leave a CommentPankaj Arora announces a new preview feature:
Until now, surge protection applied only at the capacity level—meaning all workspaces shared the same rules.
What’s new: workspace-level surge protection
We’re taking surge protection to the next level with workspace-level controls. This update gives you more granular management of compute usage across your organization.
Read on to see what this means for organizations using Microsoft Fabric.
Leave a CommentLaura Graham-Brown continues a series on variable libraries in Microsoft Fabric:
Lakehouse shortcuts are a popular addition to the Fabric set of tools to access data easily without copying it. Using a variable library in lakehouse shortcuts means its easy to point shortcuts to an alternative location. This great for ALM using development, test and production workspaces.
Read on to see how it all works.
Leave a CommentAaron Merrill announces a new preview offering:
Microsoft Fabric continues to expand the OneLake security surface with new granular REST API support for role management, giving developers and platform teams far more control over how security policies are created, retrieved, and managed programmatically. In addition to the existing batch role API, Fabric now offers discrete Create, Get, and Delete role APIs, making it easier to build incremental, automation-friendly security workflows that align with modern DevOps and governance practices.
Click through for a quick explanation of how things did work and how they will work going forward.
Comments closedMichal Bar makes an announcement:
Performance matters—especially when you’re exploring live data and making decisions in real time. We have released a set of improvements, all aiming to make Real-Time Dashboards faster, smoother, and more responsive, based directly on what our customers and community told us.
Read on to see what has changed.
What hasn’t changed is my complaint about the term “real-time.” But let’s be honest: I realize it’s a war I’m not going to win.
Comments closedThis update introduces several enhancements to native incremental copy and change data capture (CDC) capabilities in Copy job, including support for additional data source stores for incremental copy, expanded CDC support for SAP Datasphere Outbound for Amazon S3 and Google Cloud Storage (in addition to Microsoft Cloud Storage), and Column Mapping support for CDC in Copy job.
Click through to see what has changed in the copy job.
Comments closedLaura Graham-Brown makes use of a variable library:
You’ve set up your variable pipeline with WorkspaceIDs and LakehouseIDs etc etc Now you want to use that variable library in a data pipeline so we can use the common values and they will behave in a deployment pipeline.
Read on to see how it all works.
Comments closedPaul Turley describes a job role:
Analytics Engineer – The DP-600 exam contains elements of both data analytics and data engineering with a business focus. It is the fence-sitter between the disciplined worlds of data engineering and the abstract creativity of analytics. An Analytics Engineer bridges data engineering and analytics by building enterprise-ready solutions in Microsoft Fabric. Combines skills in SQL, DAX, and KQL with expertise in data modeling and performance optimization. They design and manage dataflows, create semantic models, optimize datasets, and ensure governance to deliver curated, analytics-ready data assets for reporting and analysis.
Read on to see how this role fits and some of the things a person performing this role should know and be able to do.
Comments closedAndy Brownsword deploys an app:
When using Power BI or Fabric workspaces to browse reports, we’re greeted with a list of items and their attributes. While attention is given to report visuals such as bars, pies, candles, and RAG highlights, the surrounding experience is neglected. When it comes to consumption, the standard interface falls short.
Apps fill this gap. They’ve been around in Power BI for a while, but with the additional layers that come with Fabric, the need for a clean way to present content is increasingly valuable.
Read on to learn about more functionality around apps and how you can set them up in Fabric/Power BI.
Comments closed