Alternative to WiFi for Home Networking

During the COVID-19 lockdown the number of people working from home and using the UK’s broadband network has soared.  Where people are using laptops, which I suspect is a significant majority of users, we’re all relying on a strong, stable Wi-Fi signal coming from our home broadband router/cable modem, and ... More

Creating Configurable and Portable SSIS Packages Part 3

In this article I’ll conclude my set of articles into SSIS configuration. This article will be slightly more verbose than the previous two, but I hope I clearly convey the logic behind my method. If you haven’t yet done so, please read Part 1 and Part 2 of the series. The Portability problem In my first forays... More

Creating Configurable and Portable SSIS Packages Part 2

In Part 1 I showed how a simple SSIS package could be created using variables and expressions as a basis for deployable configuration. When I first started working with SSIS I assumed naively that during deployment, a wizard or a configuration file would allow the variables and expressions to be readily editable. Speaking o... More

Creating Configurable and Portable SSIS Packages Part 1

This is the first part of a two-part post about creating and deploying a simple SSIS package. When I first started this I was a complete novice as regards SSIS. I thought it was 'something like' DTS, which I had used quite frequently in SQL Server 2000. To make matters worse, I never actually got round to learning it even w... More

Get a comma-delimited list of columns

One of the things I've been doing recently has been writing lots of SQL inserts in which I've had to specify the columns. For example: INSERT INTO tblMyTable () SELECT FROM tblMySourceTable The most tedious part was writing the column names in a comma-separated list. It would be good if I could automagically create... More