When this post was first published I was commuting two hours each way to contract work in a city with an hour of that on the train. My train time...

This doesn't float my boat because I'm a fan of the MERGE statement and use it extensively in our data warehouse loading. So extensively that I have written a script...

I generally parameterise Connection String and Password and set up environment variables to match. That keeps down the number of parameters.

And yes they do overwrite whatever is in the package.

But...

I use portable hard drives for my personal systems because the internet is not truly global and I go to many places where it is not possible to get a...

This article assumes data is defined and dropped for us. Most of the time we have to fetch it for ourselves, whether from direct database access or via API connectivity....

You can right click and export a project from the SSISDB catalog and save it as a .ispac file. Then you can open visual studio and File, new Project, Import...

Like Jeff I love working remotely and I now find it very difficult to concentrate and do any individual work in an office environment. With the return to office working,...

I use MySQL for web sites because it is free, open source and the chosen standard to work with php and wordpress and is fine for small stuff such as...

• This reply was modified 2 years, 7 months ago by  P Jones.

Whilst my little brother was playing with Sinclair and Atari products, I'd graduated and was using DEC PDP 11 daily.

DEC were huge back then, with all sorts of PDP 11...

Apologies in advance for the rant but I'm fed up with developers who go to great lengths to re-invent the wheel simply because they don't know how to do something...

Age is just a number and learning keeps the mind active and to demonstrate that my number's got to the mid-sixties and I'm getting into learning Azure to create a...

Just get the act together and brand as "DataSaturday incorporating SQLSaturday" and you get the best of both worlds.

• This reply was modified 3 years, 9 months ago by  P Jones.

Today's tip: Look at photos from a time with happy memories

My screensaver is a slideshow of favourite personal photos of places we've been and ranges from Malmo to Barcelona, Mizen...

I found Bitbucket, with SourceTree installed on the local pc as the interface, is a much more understandable version of Git and never needs a command line. I like the...

More likely they are not working in the office so have other things to sidetrack to whilst working from home.