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

Upcoming Speaking Engagements for Q4

by Tim Mitchell

Tim Mitchell

In the next few months, I’ll be giving a couple of talks on SQL Server business intelligence. For October, I...

2009-09-18

836 reads

Skipping Items in a Foreach Loop

by Tim Mitchell

Tim Mitchell

Recently, my friend Jack Corbett asked a question on Twitter:

In a nutshell, the SSIS foreach loop will enumerate a given...

2009-09-16

5,784 reads

Getting Into the Biz, Part 3

by Tim Mitchell

Tim Mitchell

In a couple of previous posts (Part One and Part Two), I shared some thoughts about starting a career path...

2009-09-14

1,372 reads

North Texas SQL Server User Group Meeting on Thursday

by Tim Mitchell

Tim Mitchell

The monthly North Texas SQL Server User Group (NTSSUG) meeting will be held this Thursday, September 17, at 7:00pm at...

2009-09-14

762 reads

SQL Saturday Dallas Update

by Tim Mitchell

Tim Mitchell

Just a quick update on the SQL Saturday event we are planning for the Dallas area next year. Late last...

2009-09-13

671 reads

Updating Existing Data with SSIS

by Tim Mitchell

Tim Mitchell

I see a lot of questions on the forums about updating existing data in SSIS. When the update is dynamic...

2009-09-10

22,369 reads

SpeakerRate – Need Your Feedback

by Tim Mitchell

Tim Mitchell

Everybody loves a compliment. Not everyone enjoys criticism, even if it’s constructive and politely delivered, but the fact is that...

2009-09-08

771 reads

24 Hours of PASS - Recap

by Tim Mitchell

Tim Mitchell

At times it felt like a party, it had enough content to be a mini-conference, and we learned that some...

2009-09-03

880 reads

Keeping a Low Profile

by Tim Mitchell

Tim Mitchell

I’ve been mostly offline for the last ten days or so, cutting back on blogging and forum participation and mostly...

2009-09-01

567 reads

Pass Board of Directors

by Tim Mitchell

Tim Mitchell

As you’ve no doubt heard or read, the call for nominations for the PASS Board of Directors is open until...

2009-08-27

594 reads

Blogs

10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives

By Meagan Longoria

Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...

The Book of Redgate: Evidence

We aren’t the only company that does this, but Redgate Software does try to...

When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?

Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....

Read the latest Blogs

Forums

The New World Of AI Robots

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The New World Of AI...

Logic question in a WHERE clause using IIF?

Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...

Execute as failure

Security has long been a problem for me. Every time I think I understand...

Visit the forum

Question of the Day

BIT_COUNT() V

What does this return on SQL Server 2025?

select bit_count(null)

See possible answers