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,554 reads
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
96 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
724 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
22 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,547 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
166 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
612 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
37 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,426 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
60 reads
Blogs
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Generate Embeddings in SQL with Aurora and Bedrock
Most embedding pipelines on AWS have the same shape: a job reads rows out...
Resolving SQL Server Transaction Log Issues Efficiently
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Forums
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers