The Idea Book
How many times have you said to yourself, “Someone should build an application that does [x]…”, or “Wouldn’t it be...
2015-03-25
775 reads
Tim Mitchell
Fix Inconsistent Line Terminators in SSIS
There is a flat file processing issue I’ve run into a number of times over the years, and it’s come...
2015-03-23
2,291 reads
Iterating Through Excel Worksheets with Biml
Wrangling large or complex Excel workbooks in SSIS can be a challenge. From managing data types (more about that in...
2015-03-25 (first published: 2015-03-16)
7,746 reads
On Failure: Getting Up
In my continuing series entitled “On Failure”, I want to talk about skiing.
I’m not a great skier. It would probably...
2015-02-16 (first published: 2015-02-06)
5,951 reads
Advanced SSIS Training in Dallas
I’m very excited to offer a new course entitled “Advanced SSIS” in the Dallas area this spring. My friend and...
2015-01-21
719 reads
On Failure
The first rule of blogging is that you should write about topics you know a lot about. And I know...
2015-01-09
688 reads
Six practical tips for social media success in 2015
Social media is the new résumé. In many ways, it’s even better than a résumé – a person’s social media stream...
2015-01-09 (first published: 2015-01-02)
6,044 reads
[OT] Blog is in maintenance mode
I’m spending part of this holiday break repaying some technical debt on my website. Among other things, I am importing...
2014-12-21
645 reads
On Perspective
Perspective can make or break a career. Maintaining a proper perspective is very often the differentiating factor between a good...
2014-12-10 (first published: 2014-12-03)
5,655 reads
SSIS Parent-Child Architecture in Catalog Deployment Mode
This is the third in a series of posts about SSIS parent-child architecture. You can find the index page here.
In...
2014-12-05 (first published: 2014-12-01)
7,336 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
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
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...
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