This article is part of a series: From Excel to SSIS Getting started File Save As (a kind of Hello, World! program for SSIS) Filtering rows Grouping and calculating Joining streams of data 0. Introduction Over the articles in the series, we have been gradually working our way towards useful and interesting SSIS code. So far we … Continue reading From Excel to SSIS, Part 4: Grouping and calculating
From Excel to SSIS, Part 3: Filtering rows
This article is part of a series: From Excel to SSIS Getting started File Save As (a kind of Hello, World! program for SSIS) Filtering rows Gouping and calculating Joining streams of data 0. Introduction This is the first article in the series where we will do something with the data as it flows through SSIS, rather … Continue reading From Excel to SSIS, Part 3: Filtering rows
From Excel to SSIS, Part 2: Hello, World!
This article is part of a series: From Excel to SSIS Getting started File Save As (a kind of Hello, World! program for SSIS) Filtering rows Gouping and calculating Joining streams of data 0. Introduction In the previous post I introduced SSIS and how to install it. In this post I will take you through … Continue reading From Excel to SSIS, Part 2: Hello, World!
From Excel to SSIS, Part 1: Getting started
This is the first in a series of posts introducing SSIS by showing how you can get it to do things that you probably already know how to do in Excel. Getting started File Save As (a kind of Hello, World! program for SSIS) Filtering rows Gouping and calculating Joining streams of data I won't … Continue reading From Excel to SSIS, Part 1: Getting started
Single Responsibility Principle for Automated Tests
I was writing some unit tests last week for a controller in an MVC application. As part of this I had to create a view model to pass to it, and inside the controller this was used to create a model. I had previously spent a bit of time writing unit tests for the conversion … Continue reading Single Responsibility Principle for Automated Tests
Automated testing of a website: Dealing with the database
This article proposes an approach to handling the fine-grained parts of the database parts of an automated system test of something like a website. You would need other things for the remaining jobs: To orchestrate the test, something like SpecFlow; To interact with the website, something like Selenium; To do the bulk updates to the … Continue reading Automated testing of a website: Dealing with the database
SpecFlow: To defer or not to defer
Introduction In a previous post on how to allow Gherkin authors flexibility to write the lines of a scenario in whatever order made sense to them, I suggested deferring things as a mechanism for making this happen. The costs of doing this have become more apparent to me since I wrote that, so I think … Continue reading SpecFlow: To defer or not to defer
A German being funny and instructive about microservices
No posts for ages - sorry. I thought this was excellent in many ways: https://www.youtube.com/watch?v=X0tjziAQfNQ
Analysing a pack of Top Trumps
This is a bit of detail behind my previous post - Visualising a pack of Top Trumps. It has the Excel stuff behind the main graph, so if Excel isn't your thing I suggest you skip this and look at something else. Step 0 - data entry The first step was just creating a sheet … Continue reading Analysing a pack of Top Trumps
Visualising a pack of Top Trumps
Introduction In this post I analyse a pack of Top Trumps. I've long had an itch in my brain that it would be interesting to do this. Playing with several different packs as child, I built up an impression that there was a general pattern in the packs, and I wanted to see if this … Continue reading Visualising a pack of Top Trumps
Random Tech Thoughts 