Viewing 15 posts - 1 through 15 (of 588 total)
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,...
March 20, 2024 at 8:59 am
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...
March 13, 2024 at 11:04 am
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.
October 11, 2023 at 7:51 am
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...
September 25, 2023 at 10:27 am
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...
September 11, 2023 at 6:54 am
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...
February 20, 2023 at 8:22 am
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...
February 10, 2023 at 8:22 am
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...
December 16, 2022 at 8:11 am
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....
November 17, 2022 at 5:11 pm
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...
October 19, 2022 at 11:18 am
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,...
June 27, 2022 at 8:15 am
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...
April 17, 2022 at 7:38 am
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...
December 21, 2021 at 7:48 am
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...
August 19, 2021 at 7:32 am
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...
May 14, 2021 at 10:55 am
Viewing 15 posts - 1 through 15 (of 588 total)