For quite some time now, there’s been the possibility to lift-and-shift your on-premises SSIS project to Azure Data Factory. There, they run in an Integration Runtime, a cluster of...
2020-11-10 (first published: 2020-11-03)
543 reads
A small blog post for anyone who stumbles across this issue (and for my future self, should I forget the solution). I was working on some tables in SSDT...
2020-10-16 (first published: 2020-10-08)
216 reads
Sometimes when you’ve created a SSIS catalog, along with folders, environments and environment variables, you want this content on another server. Unfortunately, you can only script out these objects...
2020-10-14 (first published: 2020-10-06)
439 reads
I was in a need of converting some datetime values (of which I know the actual timezone) to UTC dates. A quick Google search showed me that most results...
2020-09-28 (first published: 2020-09-22)
965 reads
I had a curious performance issue today. An inline table-valued function (iTVF) was performing poorly for some parameter sets, and quite fast for other parameter values. In short, this...
2020-09-24 (first published: 2020-09-17)
469 reads
I’m delighted to announce I’m speaking at the virtual SQLSaturday Denmark at the 26th of September 2020. I’ll be speaking about the cloud datawarehouse Snowflake and its integration with...
2020-09-09
9 reads
There’s been an update of the SSIS extension for Visual Studio 2019. There are some bug fixes and deployments are blocked to Azure-SSIS if the target server version is...
2020-09-10 (first published: 2020-09-02)
524 reads
I’m delighted to announce I’ll be speaking again at DataMinds Connect this year, one of the greatest and best Microsoft Data Platform conferences on the European mainland. Due to...
2020-08-04
9 reads
I wanted to manually start an Azure-SSIS Integration Runtime in ADF, so I went to the edit section and then to connections. But instead of showing me my linked...
2020-06-25 (first published: 2020-06-11)
245 reads
I’m excited to announce I’ll be speaking at the virtual GroupBy conference this year. Thanks everyone who voted! I’ll be speaking at the European day on May 12th at...
2020-05-06
11 reads
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
After writing several posts about a neat feature in Azure SQL called system-versioned ledger...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I...
I work on sql server 2012 i need to get featurekey and feature value...
Hi I have a very large database (600GB) that I am looking at creating. ...
Ask SSC