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

All authors

SQL Saturday Tampa

by Tim Mitchell

Tim Mitchell

I’m sitting in the Tampa airport waiting for a flight back home from SQL Saturday 10 in Tampa. There was...

2009-01-25

1,670 reads

We Are Microsoft charity challenge

by Tim Mitchell

Tim Mitchell

I got the opportunity to participate in the We Are Microsoft Charity Challenge (under the umbrella of GiveCamp) in Dallas...

2009-01-19

692 reads

Goals for 2009

by Tim Mitchell

Tim Mitchell

I don’t do resolutions - they’re cliché, overdone, and rarely stick. However, I’m a believer in setting goals and periodic progress...

2009-01-09

1,039 reads

Presenting at SQL Saturday Tampa

by Tim Mitchell

Tim Mitchell

I received word earlier today that I’ll be presenting at the upcoming SQL Saturday event in Tampa, Florida on January...

2009-01-07

963 reads

We Are Microsoft Charity Event 2009

by Tim Mitchell

Tim Mitchell

I received notification a few days ago that I was selected again to participate in the We Are Microsoft charity...

2009-01-06

912 reads

When Data Mining Goes Too Far

by Tim Mitchell

Tim Mitchell

Data mining is commonly used to find otherwise undetectable patterns in related sets of data. However, sometimes these patterns provide...

2008-12-26

1,517 reads

Auditing Changes in ETL with SSIS

by Tim Mitchell

SQLServerCentral.com

Integration Services (SSIS)

This article briefly demonstrates a methodology for auditing changes made to data flows during the ETL process.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4 (7)

You rated this post out of 5. Change rating

2008-12-23

7,243 reads

Discuss

SQL Quiz: Two Mistakes

by Tim Mitchell

Tim Mitchell

I was tagged by Gail Shaw to post two big mistakes made during my professional career. The only challenge here...

2008-12-18

825 reads

SQL Server 2005 SP3

by Tim Mitchell

Tim Mitchell

… has arrived: http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en
It’s obviously hot off the presses because the “What’s New document” is 404.

2008-12-15

670 reads

SQL Quiz Part 2: Career Challenges

by Tim Mitchell

Tim Mitchell

I’ve read a number of responses from Chris Shaw’s first DBA networking quiz. I missed out on the first one,...

2008-12-10

1,254 reads

All authors

Tim Mitchell

SQL Saturday Tampa

We Are Microsoft charity challenge

Goals for 2009

Presenting at SQL Saturday Tampa

We Are Microsoft Charity Event 2009

When Data Mining Goes Too Far

Auditing Changes in ETL with SSIS

SQL Quiz: Two Mistakes

SQL Server 2005 SP3

SQL Quiz Part 2: Career Challenges

Blogs

Using Flyway Prepare for State-Based Deployments

How I Migrated to Azure PostgreSQL Flex from Single Server

Have a Plan for Your Personal Downtime

Forums

WHERE condition using ='value' returns different results that using IN('value')

Complex Query (Multiple Tables & Joins) - Need to Restrict to Max Date

Unknown Token Received From SQL Server

Question of the Day

Hash Joins IV