SQL Server

Home - Archive by category: SQL Server

SQL Server in Windows Containers

SQL Server is sinds versie 2017 niet meer voorbehouden aan standaard Windows-installaties: ook op Linux-omgevingen en Mac OS kun je SQL Server draaien – en de standaardwijze is om dit binnen een Docker container te doen. Wist je dat je SQL Server ook binnen een Windows container kunt draaien? Andy Leonard heeft op zijn blog beschreven[...]
Read More

SQL Server op Linux – en waarom het ertoe doet

SQL Server 2017 is inmiddels al een tijdje op de markt, en zoals je wellicht al weet was één van de grote features de beschikbaarheid op Linux. Deze week kwam ik een bijzonder interessant artikel tegen van Ovum, waarin nog eens werd uitgelicht waarom dit zo interessant is: Beneath the headlines, the fact that with[...]
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

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

Automated Deployments using Visual Studio

In my earlier post “Automated Testing for the Data Warehouse“, I sketched the outlines of what would be needed in order to achieve automated testing for your Data Warehouse solutions. Today, I want to look at the first step: build & deploy. Between the previous post and the current one, some useful content about this has been written already[...]
Read More

Automated Testing for the Data Warehouse

Case: we’ve integrated two sources of customers. We want to add a third source. Q: How do we at the same time know that our current integration and solutions will continue to work while at the same time integrating the new sources? A: Test it. Q: How do we get faster deployments and more stability? A: Automate the tests, so[...]
Read More

Calculating commute distance using SSIS and the GoogleMaps API

Last week, I had an interesting question from one of my clients about estimates of planned commute distances. For example: What is the distance I travel when I, living at Kalverstraat 7 (Amsterdam) commute five days a week to my customer in Paris (1, rue Victor Cousin)? By the way: it should be calculated for all employees, for[...]
Read More

Latest Posts

Categories