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!
Category: Introduction
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
An introduction to integers and floating point numbers
Integers on a computer are simple and behave in predictable ways. Floating point numbers are not and don’t always respectively – I’ll explain what they are and why below. Working with floating point numbers is also slightly like cleaning up after my dogs, which I will also explain below. Integers Integers are a bit like … Continue reading An introduction to integers and floating point numbers
Introduction to testing your website with Selenium and SpecFlow
This article is in a short series about testing your website with Selenium and SpecFlow: Introduction Why bother? Basic plumbing Page objects The engineering behind decent Gherkin files The combination of Selenium and SpecFlow lets you do two useful things: Test your website in the way that a user would Base these tests on acceptance … Continue reading Introduction to testing your website with Selenium and SpecFlow
Data modelling for programmers
This article is for anyone, but is mostly aimed at people who have done some programming and now want to tackle data modelling - things like designing tables in a database. When you start data modelling, you eventually hit the unavoidable problem that real life is big and messy. I have found two tactics to … Continue reading Data modelling for programmers
Guest slot on Boagworld podcast
Have you ever wondered what regular expressions are? Do you have trouble falling asleep? Paul Boag runs the excellent podcast Boagworld (plus a UX and digital transformation consultancy), and opened up the podcast for a season to anyone and everyone. The idea was about 10 minutes of stuff per person, and he and his co-host … Continue reading Guest slot on Boagworld podcast
An introduction to Behaviour-Driven Testing with Cucumber / SpecFlow
BDD (Behaviour-Driven Development) evolved out of TDD (Test-Driven Development), and is an approach to testing and development in general. I have found it has benefits even if you just use it as a way of doing testing, rather than having tests drive what you develop. There are a few different frameworks that allow you to … Continue reading An introduction to Behaviour-Driven Testing with Cucumber / SpecFlow
Random Tech Thoughts 