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

PASS Data Summit 2025 Recap

Last week, I attended the annual PASS Data Summit in Seattle. This was the fourth year of the event since Red Gate took over stewardship of PASS after that...

2025-12-05 (first published: )

22 reads

Blog Post

Using Python Code in SSIS

SQL Server Integration Services (SSIS) is a mature, proven tool for ETL orchestration and data movement. In recent years, Python has exploded in popularity as a data movement and...

2025-09-01 (first published: )

368 reads

Blog Post

My Office Setup

At the PASS Summit a few weeks ago, I had a great chat with some folks about our home office setups. More and more of us are working from...

2022-12-16 (first published: )

288 reads

Blog Post

Returning to PASS Summit

In just a couple of weeks, the PASS Summit will return to Seattle, Washington. This one will be extra special, since it’s going to be the first in-person Summit...

2022-10-31

12 reads

Blog Post

Creating a Generic SSRS Report

Creating useful reports is part art and part science. On one end of the spectrum, you have visually appealing and highly customized reports and dashboards that are truly works...

2022-04-13 (first published: )

444 reads

All authors

Blogs

Learning from Mistakes: T-SQL Tuesday #194

By

We’re a week late, once again my fault. I was still coming out of...

Stupid Things I Did With AI: ASCII Art

By

I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...

Simple Talks Podcasting in 2026

By

I’m in the UK today, having arrived this morning in London. Hopefully, by this...

Read the latest Blogs

Forums

Learning From Breakage

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Learning From Breakage

Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy

By sabyda

Comments posted to this topic are about the item Python in Action to Auto-Generate...

Adding and Dropping Columns I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding and Dropping Columns I

Visit the forum

Question of the Day

Adding and Dropping Columns I

I have this table in my SQL Server 2022 database: 

CREATE TABLE [dbo].[CityList]
(
[CityNameID] [int] NOT NULL IDENTITY(1, 1),
[CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
I decide to add two new columns for the StateProvince and Country. What code should I use?

See possible answers