tSQLt for Data Warehousing, test your Stored Procedure
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 […]
Create a Test Class & First Unit Test with tSQLt
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 […]
Create a SSDT Project Template based on your Database Project
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 […]
Getting started with tSQLt
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 […]
Unit Testing for Data Warehousing / Database Development
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 […]
Resume & Suspend a Microsoft Fabric Capacity
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 […]
New content coming soon!
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!
Database Projects – Committed to the wrong branch, now what?
In the past couple of months, I’ve been doing a lot of different things at the same time. Because of that, it is no exception that I have quite some branches for my Database Projects that I’m working on simultaneously. Because of this, another issue arises as well, it happens now and then that I’m […]
Create a Fabric Data Warehouse and connect via Azure Data Studio
In this data recipe series, Microsoft Fabric – Data Warehouse will be explored. As a starting point, a blank Fabric workspace is used. You can sign up for a free Fabric trial by using the following URL: Data Analytics | Microsoft Fabric In this data recipe, we will create a brand-new Data Warehouse in Fabric. Once […]
What a year, 2023 review
We have had the first winter snowfall (at least 1 day), and days are getting shorter and colder. This reminds me that it’s time to review the past year. Last year, I concluded that I had reached a couple of professional milestones. I ramped up speaking engagements, finished my first blog post series, and met […]