The SSIS Object Variable and Multiple Result Sets
In my most recent post in this series, I talked about how to use the SSIS object variable as an...
2015-04-27
4,829 reads
Tim Mitchell
Somebody Doesn’t Like You, and That’s Good
Everybody wants to be liked, to some extent. Being disliked by others feels like a deficiency, a shortcoming in oneself...
2015-04-24
568 reads
Using the SSIS Object Variable as a Data Flow Source
Object variables in SSIS are incredibly versatile, allowing the storage of almost any type of data (even .NET objects). In...
2015-04-30 (first published: 2015-04-20)
12,217 reads
Handling Mixed Format Data Files in SSIS
Some time back I wrote about how to use the script component to parse out ragged data files in SSIS....
2015-04-22 (first published: 2015-04-13)
6,000 reads
A full day with me, SSIS, and Edgar Allan Poe
When I think about Baltimore, I think about Edgar Allan Poe. Baltimore was Poe’s one-time home, and in fact there...
2015-04-10
619 reads
On Failure: On Being a Screw-Up
“He’s a screw-up. Always trying things that don’t work.”
I’ll be honest: I used to be afraid of being the person...
2015-04-17 (first published: 2015-04-09)
5,688 reads
Null, empty string, or zero?
The answer: It Depends.
One of the more common problems I encounter when managing data quality, especially in an ETL process,...
2015-04-15 (first published: 2015-04-06)
7,571 reads
Best of PASS Summit 2014: Building Bullet-Resistant SSIS Packages
This week, PASS announced the Best of PASS Summit 2014, a collection of the 10 highest-rated sessions from last fall’s...
2015-04-13 (first published: 2015-04-04)
5,944 reads
Finally, a Universal Data Integration Utility
Earlier today, the fine folks at the F. Oobar Corporation released a revolutionary product: a universal data integration utility. This...
2015-04-01
735 reads
Why I Want to Have Coffee With You
Yesterday I read an article entitled “Why I Don’t Want to Have Coffee With You”, in which the author writes...
2015-04-10 (first published: 2015-03-31)
7,883 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers