DP-700 training: Implement mirroring

If you come from an SQL Server background, mirroring will be familiar to you. It may be good or bad, but hopefully not at a nightmare level. Whatever your association with database mirroring, it is also available within Microsoft Fabric. What is mirroring If you're not coming from a SQL Server background, or any data … Continue reading DP-700 training: Implement mirroring

DP-700 training: create and manage shortcuts to data

Storage is cheap, so we don't have to worry about data storage costs. Though this might be true, at some point, a lot of data will start to cost a lot of money. And, like many of you, dear readers who are in business intelligence, we like to duplicate data. A lot. We ingest it, … Continue reading DP-700 training: create and manage shortcuts to data

DP-700 training: Item Level Access

In the previous blog post, I wrote about workspace-level Access. With the four levels of access that can be defined, this wasn't too hard. Let's make it a little harder and see if we can prevent mishaps in the different items within our workspace. In other words, let's regulate access to the different items because … Continue reading DP-700 training: Item Level Access

DP-700 training: Workspace access level controls

When you're working with Microsoft Fabric, some people are allowed to do everything in your workspace, other people are less privileged and should have less permissions. There are a lot of ways to make sure people don't ruin your weekend, the best one being no access at all. But that also means that you're always … Continue reading DP-700 training: Workspace access level controls

DP-700 training: data masking

Data security is the most important part of our job as data engineers and data architects. There are very few use cases where people need to see all the data in full detail. I know, customers take a different view on this but in reality, do they really need every single detail? No, they do … Continue reading DP-700 training: data masking

DP-700 Training: Choose an appropriate data store

The best place to store your data is in a SQL Server database that no living being can ever access. The end. No, I'm kidding, of course. But there's an atom of truth in this joke. Because for years we, in the structured data industry, have always been convinced that a database is the best … Continue reading DP-700 Training: Choose an appropriate data store

Mastering your Fabric Capacity Metrics App

This weekend, attending Data Saturday Denmark, I joined a session presented by Benni de Jagere. Benni works for Microsoft as a member of the CAT team but is also very active in the community as an organiser and speaker. In general, when Benni starts speaking and sharing knowledge, it's well worth it to listen and … Continue reading Mastering your Fabric Capacity Metrics App

DP-700 Training: endorse, promote and certify your items

Now that's a long title! Luckily, this concept isn't really hard so you should be in for a smooth ride today. What is this easy thing? Well, to put it quite simple, you can add three labels to items in your Fabric workspace:- Promoted- Certified- Master Data In my view, there's an order to these … Continue reading DP-700 Training: endorse, promote and certify your items

DP-700 training: exploring event streams

Microsoft Fabric really is a Swiss army knife when it comes to its possibilities. Not only capable of hosting your BI information which is usually loaded at night and analysed during working hours but it can also process real time information. Let's dig into that some more! Data Fabric architecture Before we go all nerdy … Continue reading DP-700 training: exploring event streams

DP-700 training: Create and configure deployment pipelines

In one of the earlier blogs, the topic revolved around everything Git. Git is a version control system where you can leverage CI/CD. I love Git, even though it has a habit of biting me severely in the parts I use to sit on. If you're not well versed in Git or have no option … Continue reading DP-700 training: Create and configure deployment pipelines