Finally, a Universal Data Integration Utility
Earlier today, a revolutionary product was released: a universal data integration utility.
2015-04-01
6,687 reads
Tim Mitchell
- Interests: SQL Server, Data Warehousing, ETL, Data Architecture, Python, Dbt
- Website: https://www.TimMitchell.net
- Bluesky: tmitch.net
SQL Saturday 52 Recap
I spent this past weekend traveling to and attending SQL Saturday Colorado in the outskirts of Denver. This was the...
2010-10-01
2,608 reads
SSIS: Conditional File Processing in a ForEach Loop
I’ve fielded a number of requests recently asking how to interrogate a file within SSIS and change the processing rules...
2010-08-26
11,640 reads
An Un-CATCHable Error?
I've been using the scripting tools in SSIS for some time, but I came across something today that I can't...
2010-03-29
2,895 reads
SSIS Alpha Splits using the CODEPOINT() Function
A relatively common requirement in ETL processing is to break records into disparate outputs based on an alphabetical split on...
2010-02-12
1,423 reads
Goals for 2010
So I’d planned to already have this done and published before the new year rolled around, but life got in...
2010-01-12
929 reads
Electronic Health Records – What’s the Big Deal? (Part 3)
In the previous post in this series, I discussed the obstacles to implementing electronic health data systems. Because of these...
2009-12-08
1,264 reads
Electronic Health Records – What’s the Big Deal? (Part 2)
In the first installment of this discussion, I talked about the challenges facing database professionals and others with respect to...
2009-11-02
2,304 reads
Electronic Health Records – What’s the Big Deal? (Part 1)
Last week, I had lunch with an old friend who is, by his own definition, technologically ignorant. While we caught up, he asked me to explain in terms he could understand what I do for a living. I went through one of my spiels (the one usually..
2009-10-21
1,724 reads
Eliminating Empty Output Files in SSIS
So you’ve got some packages that regularly extract data to one or more text files, but you know that from...
2009-10-05
4,542 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