Continuous X

Home - Archive by category: Continuous X

Azure DevOps: Inrichten van DW/BI repositories

Poster Image
Ik heb een tweede video opgenomen over CI en CD met Azure DevOps (voormalig VSTS) het Microsoft Data Platform. Hierin ga ik in op het inrichten van je Azure DevOps repositories en mappenstructuur. Ik ben erg benieuwd wat je ervan vindt, dus laat even een bericht achter hieronder!
Read More

Introductie Azure DevOps voor BI

Poster Image
Momenteel ben ik bezig met het opnemen van enkele video’s waarin ik meer uitleg over het werken met CI en CD binnen Azure DevOps (voormalig VSTS) – specifiek voor projecten op het Microsoft Data Platform. De eerste video – Introductie Azure DevOps voor BI – vind je vanaf vandaag op YouTube:   Ik ben erg[...]
Read More

Setting up DWH Test Automation: Design & Arch

With Continuous Integration working for my Data Warehousing solution (SQL Server, SSAS Tabular, SSIS), it’s time to step forward. Before moving to Continuous Deployment, I want to have a rigorous and automated testing on my EDW. But how to get there?
Read More

3 Important Lessons about Test Automation in Business Intelligence

As you might know, I’m keeping an eye on how I can automate my Data Warehousing testing. In “Automated Testing for the Data Warehouse” my observation was In essence, testing a Data Warehouse isn’t that complex It turns out I’m not the only one thinking about this (really? 😉 ). Some time ago I listened to[...]
Read More

VSTS Continuous MSBuild for DWH / BI

Wait, didn’t I post this already several weeks ago? Well, almost. A few weeks ago, I showed how to set up a build agent using devenv.com. Unfortunately, I ran into some problems like failing builds not reporting failure and SSAS Tabular projects not building correctly[ref]There’s also some mentions about SSDT 2015 projects not being supported,[...]
Read More

VSTS Continuous Build for DWH / BI

In my earlier post “Automated Deployments using Visual Studio” I metioned that the method described was a workaround because I hadn’t figured out how to do a continuous build in VSTS (Visual Studio Team Services) yet. With hindsight, that workaround was not really needed: VSTS build turns out to be só easy, that it’s ridiculous[...]
Read More

Looking for intern / grad student: Continuous Integration for BI

As you might’ve noticed, I’m keeping an eye on Continuous Integration for Business Intelligence. Currently, I’m looking for a grad student to help me implement CI inside BI in his/her internship. As we’re located in Holland, speaking Dutch is a prerequisite – but as a bonus, you’ll be able to share your findings in English[...]
Read More

Synchronizing SQL Server environments

When deploying changes through DTAP, you might need to sync your environments. For example, I sync my Acceptance environment before deploying a new increment, so I can easily see the effects of my new software on production data. To be honest, I’m not very good in these database management tasks[ref]I’ve worked once in an environment[...]
Read More

Latest Posts

Categories