Bite Size Data Tales | Olivier Van Steenlandt
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 […]
I attended quite some conferences in the first 6 months of 2024. When I get the chance, and there is an SSDT (SQL Server Data Tools) session on the schedule, I go to the session to learn something new. Lately, at Data Saturday Croatia, I had the chance to attend an advanced session about SSDT […]
It’s time to take the first steps into Database Unit Testing. As mentioned in my previous blog post, I will use tSQLt, an open-source unit testing framework for databases. Since I’m a big fan of SSDT (SQL Server Data Tools), we will use a Database Project to set up the tSQLt framework. Recipe Overview Preparation […]
In the past few years, I learned much about collaborative data warehouse development and deployment automatization by using Database Projects (SSDT) and Azure DevOps (and other tools). I had my fair share of learning curves, making mistakes, and having great learning opportunities. Lately, I started my next journey to learn about Unit Testing for data […]
