Bite Size Data Tales | Olivier Van Steenlandt
As I mentioned in one of my previous data recipes, I’m currently exploring Fabric RTI. During this learning experience, I’m using my own Fabric capacity, which is an F4. To minimize unnecessary costs, I’m suspending and resuming my capacity at the appropriate moments. Problem statement To continue the development of my mobile app, whose core […]
Over the past few weeks, I have been creating a mobile app that allows me to scan consumable articles’ barcodes an searches for product information. And, I have been playing around with Microsoft Fabric for a while, but until now, I never played around with RTI (RTI = RealTime Intelligence). Recipe OverviewPreparation time: 10 minutes […]
Over the past few weeks, I have been doing some experimenting with Azure SQL mirroring to Microsoft Fabric. In the process, I ran into a couple of issues and challenges. In this data recipe, I will be going through one of my challenges when I got Azure SQL mirroring to Microsoft Fabric setup and running. […]
Over the past few weeks, I have been experimenting with some Microsoft Fabric features that I haven’t used in practice yet. For this data recipe, I’m looking at a specific issue where I ran into when I was looking closer into Azure SQL Mirroring into Microsoft Fabric. Problem statement When setting up database mirroring from […]
Lately, I have been playing around with Notebooks, Data lakehouses, and Warehouses. When I didn’t have very much experience with notebooks in Microsoft Fabric, I ran into a specific issue, which I will be describing in this data recipe. Introduction As mentioned earlier, I have been playing around with Microsoft Fabric intensively in the past […]
In the previous data recipe, tSQLt for Data Warehousing, test your Stored Procedure, we created our first Unit Test to validate our SQL Server Stored Procedures. In this data recipe, we will dive into the process of Database Unit Testing automation with Azure DevOps. Recipe Overview Recipe Overview Preparation time: 15 minutes Ingredients Why? Before […]
In December, when days are getting shorter, I always like to take the time to review the year. Last year, I took you on my journey of 2023. This year will be more of the same with new experiences. Don’t worry, this post won’t be very elaborate even though I had a very busy and […]
Microsoft Ignite came to an end and no need to say that a lot of great announcements have been shared. For me, the biggest announcement was, as the title of this post already mentions, the public preview of databases in Microsoft Fabric. Because I had the pleasure of learning about the brand-new functionality firsthand, I […]
In the previous data recipe, Create a Test Class & First Unit Test with tSQLt, we created our very first T-SQL Unit Test to test the database collation. In this data recipe, we will test the execution of a Stored Procedure. Specifically, we will validate what happens when a new User is added to the […]
We have set up our tSQLt Database Project in the previous data recipe, Create a SSDT Project Template based on your Database Project. Now it’s time to dive into the wonderful world of tSQLt Unit Testing. In the meantime, I have added my data warehouse to my SSDT Solution and added this project as a […]
