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
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,726 reads
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
769 reads
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
1,860 reads
Measuring Career Growth
A guest editorial from Tim Mitchell today looks at keeping track of what we have done in our careers, and the value that it gives us.
2015-03-05 (first published: 2010-10-01)
431 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,945 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
713 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
683 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,042 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
637 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
WHERE condition using ='value' returns different results that using IN('value')
Have an interesting scenario - user found a discrepancy with rows returned when running...
Complex Query (Multiple Tables & Joins) - Need to Restrict to Max Date
I am using the query listed below. USE GAGETRAK_26237 SELECT G.Gage_ID 'ID', G.Model_No 'Model',...
Unknown Token Received From SQL Server
I have an issue when a stored procedure is executed from the SQL Server...