Tim Mitchell

Tim Mitchell is a business intelligence consultant, author, and trainer. He has been building data solutions for over 20 years, and is a 13-time recipient of the Microsoft Data Platform MVP award (2010-2022). He is the founder and principal data architect at Tyleris Data Solutions.

Tim has spoken at international and local events including the SQL PASS Summit, SQLBits, SQL Connections, along with dozens of tech fests, code camps, and SQL Saturday events. He is the author of the book The SSIS Catalog: Install, Manage, Secure, and Monitor your Enterprise ETL Infrastructure, coauthor of the book SSIS Design Patterns, and is a contributing author on the charity book project MVP Deep Dives Vol 2.

You can visit his website and blog at TimMitchell.net or follow him on Bluesky at https://bsky.app/profile/tmitch.net.

Interests: SQL Server, Data Warehousing, ETL, Data Architecture, Python, Dbt

Website: https://www.TimMitchell.net
Bluesky: tmitch.net

Dear Vendor: Keep My Information Secure

by Tim Mitchell

Tim Mitchell

Dear vendor:
Dear Vendor: Keep My Information Secure
If you’re reading this, we have done business together, either directly or indirectly. You...

2015-05-08 (first published: 2015-04-27)

5,914 reads

Using the SSIS Object Variable as a Data Flow Source

by Tim Mitchell

Tim Mitchell

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,153 reads

The SSIS Object Variable and Multiple Result Sets

by Tim Mitchell

Tim Mitchell

In my most recent post in this series, I talked about how to use the SSIS object variable as an...

2015-04-27

4,613 reads

Somebody Doesn’t Like You, and That’s Good

by Tim Mitchell

Tim Mitchell

Everybody wants to be liked, to some extent. Being disliked by others feels like a deficiency, a shortcoming in oneself...

2015-04-24

561 reads

Handling Mixed Format Data Files in SSIS

by Tim Mitchell

Tim Mitchell

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)

5,993 reads

On Failure: On Being a Screw-Up

by Tim Mitchell

Tim Mitchell

“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,685 reads

Null, empty string, or zero?

by Tim Mitchell

Tim Mitchell

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,562 reads

Best of PASS Summit 2014: Building Bullet-Resistant SSIS Packages

by Tim Mitchell

Tim Mitchell

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,941 reads

A full day with me, SSIS, and Edgar Allan Poe

by Tim Mitchell

Tim Mitchell

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

613 reads

Why I Want to Have Coffee With You

by Tim Mitchell

Tim Mitchell

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,880 reads

Blogs

Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution

For decades, enterprises have approached data management with the same mindset as someone stuffing...

Truncate Table Pitfalls

By Peter Skoglund

Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....

dataMinds Connect 2025 – Slides & Scripts

By Koen Verbeeck

You can find all the session materials for the presentation “Indexing for Dummies” that...

Read the latest Blogs

Forums

Technological Dinosaurs or Social Dinosaurs?

By Grant Fritchey

Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?

DBCC CHECKIDENT

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DBCC CHECKIDENT

Distributed Availability Group Health: T-SQL and Zabbix

By Pablo Echeverria

Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...

Visit the forum

Question of the Day

DBCC CHECKIDENT

What is returned as a result set when I run this command without a new seed value?

See possible answers