Bite Size Data Tales | Olivier Van Steenlandt
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 […]
With Microsoft Fabric becoming GA in November last year (2023), I wanted to start and explore this new shiny Software-as-a-service (SaaS) solution as well. With only a limited budget for exploring and testing new tools, I had to figure out how to use my budget efficiently. Therefore, before making any decisions, I looked at the […]
2024 has been challenging, a very busy speaking schedule, learning new things, combined with some health challenges made me unable to keep my data blog up-to-date with frequent blog posts or data recipes as I like to call them. I hope to start publishing new content starting in July 2024. Keep you posted!
