With work life being building a new data hub in AWS S3 and Athena when my skills were focused on SSIS and SQL for the on-premises SQL Server based hub,...

Good to see a post highlighting the basics for those newer to SQL Server.

Server registration was a life saver back in 2004-2015 when I was DBA for many SQL Servers...

I'm not a DBA. I have been officially a DBA and before that I started as a developer who had to be the DBA because no-one else would. Recently I've...

Is it a modern thing to require homework for an interview? In forty years in the software industry, the only interview that has asked me to prepare and present anything...

Reading these posts makes me feel better about only having SQL Server 2016 (and an exit plan for it) and procrastinating over upgrading my Windows 8.1 tablet because it works...

Check the schedule on the SQL agent job to make sure it isn't running repeatedly.

Check the advanced settings for the job step and make sure that the job is set...

I've never been across the pond to the USA but I hate pubs here in the UK where the music is too loud and everyone is having to talk loudly...

As a data engineer currently involved in a pilot for migrating an on-premises SQL Server corporate data store to a cloud AWS data lake with S3 storage and Athena querying,...

You set which version of SQL Server you are deploying the package to in the project properties.

Open SSIS solution in visual studio and right click the project name and select...

I had to do this recently in SQL Server 2016 and used STRING_SPLIT which was far simpler and seems to keep the order anyway.

It's another day when I think SQL Server Central must have been spying on us, producing such on-topic editorials, as here I am, old enough to claim my UK state...

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...