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

The Side Project

by Tim Mitchell

Tim Mitchell

When I first started working as a technologist some 17 years ago, I was doing fairly low-level stuff: moving and...

2017-01-11 (first published: 2017-01-04)

1,362 reads

Why Data Warehouse Projects Fail

by Tim Mitchell

Tim Mitchell

Data warehouse projects are among the most visible and expensive initiatives an organization can undertake. Sadly, they are also among...

2017-01-10

1,103 reads

KPIs in SSRS 2016

by Tim Mitchell

Tim Mitchell

Key performance indicators, or KPIs, are at-a-glance metrics for simple insight into the business. These are each designed to provide...

2016-12-30 (first published: 2016-12-22)

1,748 reads

ETL Error Handling

by Tim Mitchell

Tim Mitchell

In designing a proper ETL architecture, there are two key questions that must be answered. The first is, “What should...

2016-12-28

773 reads

Survey Results: Skipping the Holidays

by Tim Mitchell

Tim Mitchell

Last week I posted a brief survey about working the holiday. To those who normally are not required to work...

2016-12-27

388 reads

Survey: Skipping the Holidays?

by Tim Mitchell

Tim Mitchell

For a little pre-holiday fun, I’ve got a simple scenario to present to you, and I am interested in your...

2016-12-23

381 reads

SSIS Custom Logging Levels

by Tim Mitchell

Tim Mitchell

In my ongoing series on ETL best practices, I recently wrote about the importance of logging in extract-transform-load processes. For...

2016-12-22

487 reads

On Being Disruptive

by Tim Mitchell

Tim Mitchell

Being disruptive is a powerful way to conduct business. Steve Jobs and Bill Gates insisted that computers belonged not just...

2016-12-20 (first published: 2016-12-05)

1,734 reads

Report Portal in SSRS 2016

by Tim Mitchell

Tim Mitchell

SQL Server Reporting Services benefits from a major update in SQL Server 2016, which is obvious from the first interaction...

2016-12-20

574 reads

The Trails We Leave

by Tim Mitchell

Tim Mitchell

Over the weekend I got an email from have i been pwned, a website that tracks data breaches and notifies...

2016-12-19

350 reads

Blogs

T-SQL Snapshot Backups on Availability Group Secondary Replicas

By Andrew Pruski

One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....

The Book of Redgate: Hours

I have said and written this many times: Redgate Software is the type of...

How to Check TDE Progress and Elapsed Time in SQL Server

How to Check TDE Progress and Elapsed Time in SQL Server ...

Read the latest Blogs

Forums

Squared Values

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Squared Values

I Don't Want To Do XX

By Steve Jones - SSC Editor

Comments posted to this topic are about the item I Don't Want To Do...

Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server

Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...

Visit the forum

Question of the Day

Squared Values

What happens when I run this code in SQL Server 2022?

SELECT SQUARE('12')

See possible answers