I am sure my readers have a very good understanding of how SSIS Data Flow Task “Slow Changing Dimension” works. The point of this blog is not to...
Recently I realised working with quite a few data teams across UK and US that many of these data teams still using VM hosted SQL Server and manually...
Many DevOps engineers will hate me for saying these, but I believe, that having a background in data and from the experience of working with DevOps...
Installing DBT using SQL server is extremely simple. I had many clients coming to me and asking if they could use DBT with SQL Server on-prem or...
By the time you finish this tutorial, you will become one of the best POWER BI Wizards. You'll find yourself becoming quite the adept POWER BI RegEx...
Challenges: Building Dynamic Data Pipeline: Processing multiple files with different column names; Need a dynamic pipeline that can handle varying...
