SSIS Data Flow "Sequence Containers" are Here!
Wooo!OK - maybe too much of a celebration... and I do have meatier topics in the article pipeline. However, I just stumbled across a feature in SSIS that I...
2016-12-01
93 reads
Todd McDermid's Blog
SSIS Data Flow "Sequence Containers" are Here!
Wooo!
OK - maybe too much of a celebration... and I do have meatier topics in the article pipeline. However, I just...
2016-12-08 (first published: 2016-12-01)
1,551 reads
Reading a SharePoint 2007 List from SSIS 2016
It's been a while, but since I now get to play with SQL 2016 full time, I have new things to talk about! One of major difficulties that any technology...
2016-10-24
21 reads
Reading a SharePoint 2007 List from SSIS 2016
It's been a while, but since I now get to play with SQL 2016 full time, I have new things...
2016-10-24
723 reads
Control Flow Package Parts in SSIS 2016
Control Flow Package Parts are a new feature in Microsoft SQL Server 2016 that attempts to enable code reuse within SQL Server Integration Services packages. The intent is great, but like...
2016-10-14
164 reads
Control Flow Package Parts in SSIS 2016
Control Flow Package Parts are a new feature in Microsoft SQL Server 2016 that attempts to enable code reuse within SQL Server...
2016-10-20 (first published: 2016-10-14)
3,538 reads
Consolidating Multiple Data Marts
One of the challenges that I've worked on in the past months involved adapting our technical architecture to address issues exposed by business re-engineering. The BI group at CHC used to assign specific...
2015-08-03
35 reads
Consolidating Multiple Data Marts
One of the challenges that I've worked on in the past months involved adapting our technical architecture to address issues exposed by business re-engineering. ...
2015-08-03
609 reads
Data Flow Optimization - Collapse Sparse Buffers
I'll warn you straight off that this is an advanced technique for a fairly small use case - it is NOT a "try this for all data flow performance...
2012-10-22
58 reads
Data Flow Optimization - Collapse Sparse Buffers
I'll warn you straight off that this is an advanced technique for a fairly small use case - it is NOT...
2012-10-22
1,425 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers