We're almost used to SQL Server Management Studio (SSMS) 21, and now 22 is already in preview. So, let's see where it's available for download, install it and see what's different. Download and release notes. The most important part, of course, is the download of the binaries. Click here for the download. Click here for … Continue reading SSMS 22 preview 1 first impressions
When Microsoft Fabric was introduced in May 2023, one of its major promoted components was the Real-time Analytics part. We (that is, my coworkers and I from Axians) focused mainly on the batch processing of data. With the introduction of the DP-700 exam, I started to focus more on the real-time part of Microsoft Fabric. … Continue reading Mastering Real-Time Analytics with Microsoft Fabric
Let's dig into something that's quite simple to implement: workspace monitoring. Whenever someone calls out that "something is simple to implement", your first response should be "Oh really?". Because simplicity is always in the eyes of the beholder. And sometimes the easiest solutions carry the most consequences. Or cost. Or both. Wording can be complicated, … Continue reading DP-700 training: Workspace logging
Let me set the scene quickly for you. You're working for an organisation where Fabric is in the process of being adopted or it's already fully in use. Regardless of the number of capacities, workspaces, etc, you're interested in what's going on in your Fabric environment. You have questions like "Who is using the reports?", … Continue reading Streamline Fabric Monitoring and Administration Using FUAM
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
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
When we create a data solution for our company or clients, we create the best, right? Sure, we do. But still, monitoring the solution is something you should never forget. Your solution can be stable, but the data usually isn't. And it just feels good to know all the data has been processed correctly. So, … Continue reading DP-700 Training: Monitor hub
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
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
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
Reitse's blog 