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

All authors

Blog Post

Why Before How

I’ve spent a lot of time browsing and participating in online technical forums. In my early years in the industry...

2017-03-28 (first published: )

1,888 reads

Blog Post

Managing Bad Data

In the last post in my ongoing series about ETL best practices, I discussed the importance of error handling in ETL...

2017-02-21 (first published: )

2,205 reads

Blog Post

What is ETL?

In my ongoing series on ETL Best Practices, I am illustrating a collection of extract-transform-load design patterns that have proven...

2017-01-16 (first published: )

2,506 reads

All authors

Blogs

Data Céilí 2026 Call for Speakers!

By

Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...

Streamlining Azure VM Moves Into Availability Zones

By

One of the more frustrating aspects about creating an Azure virtual machine is that...

Monday Monitor Tips: Native Replication Monitoring

By

Redgate Monitor has been able to monitor replication for a long term, but it...

Read the latest Blogs

Forums

Think LSNs Are Unique? Think Again - Preventing Data Loss in CDC ETL

By utsav

Comments posted to this topic are about the item Think LSNs Are Unique? Think...

A Big PK

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Big PK

The AI Bubble and the Weak Foundation Beam

By dbakevlar

Comments posted to this topic are about the item The AI Bubble and the...

Visit the forum

Question of the Day

A Big PK

In SQL Server 2025, how many columns can be included in a Primary  Key constraint?

See possible answers