-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Tim Mitchell

Tim Mitchell is a business intelligence consultant, author, trainer, and Microsoft Data Platform MVP with over thirteen years of data management experience. He is the founder and principal of 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 coauthor of the book SSIS Design Patterns, and is a contributing author on MVP Deep Dives 2.

You can visit his website and blog at TimMitchell.net or follow him on Twitter at @Tim_Mitchell.

Why I’m Breaking Up with Facebook

I have been in a serious relationship for more than 12 years. My partner in this relationship has brought me joy through the years, but lately, I feel like I’m giving to this relationship far more than I’m getting out of it. The relationship no longer brings me the joy… Read more

8 comments, 3,154 reads

Posted in Tim Mitchell on 1 January 2019

A Better Way to Clean Up the SSIS Catalog Database

Earlier this week, I blogged about the automatic cleanup process that purges old data from the SSIS catalog logging tables. This nightly process removes data for operations that are older than 365 days. While this is useful, many SSIS admins have complained that this process is very slow and contentious… Read more

6 comments, 196 reads

Posted in Tim Mitchell on 30 December 2018

Personal Touch: An Argument Against Automation

At the far end of an out-of-the-way aging strip shopping center in southern Louisiana, there stands a small and modest sushi restaurant. The exterior could be described as tasteful minimalistic: there are no big signs, no flashy advertising, and the word “fancy” would never be used to describe it. Inside,… Read more

1 comments, 196 reads

Posted in Tim Mitchell on 20 December 2018

SSIS Catalog Automatic Log Cleanup

Built into the SSIS catalog is a mechanism that can automatically purge log data after a set period of time. In this post, I’ll show you how to set up and manage that functionality. SSIS catalog automatic log cleanup The SQL Server Integration Services catalog database – SSISDB – has… Read more

3 comments, 2,043 reads

Posted in Tim Mitchell on 19 December 2018

SSIS Catalog Execution Parameter Values

When doing any new development or major overhaul of existing SSIS architecture, I almost always recommend to clients that they deploy those packages to the SSIS catalog. Using the catalog to store and execute SSIS packages takes a lot of the manual work out of development and maintenance, particularly when… Read more

2 comments, 243 reads

Posted in Tim Mitchell on 18 December 2018

Processing Multiple Files in SSIS with the Foreach Loop

Yesterday I wrote about the little-known but still useful multiple flat file connection manager. In this post, I will briefly show a more commonly used alternative approach for processing multiple data files: the foreach loop container. The SSIS foreach loop container The foreach loop container is used to iterate through… Read more

2 comments, 127 reads

Posted in Tim Mitchell on 17 December 2018

Using the SSIS Multiple Flat Files Connection Manager

When building an ETL pipeline to import data from a text file, it’s very common to have the incoming data spread across multiple files. For example, if you are ingesting files generated on a periodic basis (per day, per hour, etc.), you could have dozens or hundreds of files with… Read more

2 comments, 284 reads

Posted in Tim Mitchell on 15 December 2018

Extract the File Name in SSIS Data Flows using the FileNameColumnName Property

When extracting data from a flat file, it is handy to have the name of the file from which the data was retrieved. Whether you capture this information for auditing purposes, or you include it directly in the output table, the odds are good that you’ll want to have that… Read more

4 comments, 264 reads

Posted in Tim Mitchell on 15 December 2018

Change Tracking Inserts Require SELECT Permission

I’ve been writing about change tracking in SQL Server for some time now, but I recently came across a permissions issue on a change tracking table that I’d never encountered before. When attempting to insert data into a change tracking-enabled table using an account with no select permissions, I learned… Read more

2 comments, 159 reads

Posted in Tim Mitchell on 13 December 2018

Naming Convention Hall of Shame

Call me pedantic, but I can be a stickler for standardized naming conventions. Whether it’s application code, database objects, documentation, or other digital assets, I find a tremendous amount of value in establishing a set pattern for naming and formatting. Especially for organizations with a large digital landscape, having a… Read more

6 comments, 169 reads

Posted in Tim Mitchell on 13 December 2018

The Eleven Days of Festivus 2018

It’s that time again! My Eleven Days of Festivus blogging extravaganza is now in its third year, and I’m happy to share one blog post per day with you for the 11 days between now and Festivus Eve (December 22nd). As before, I’ll link all of the posts from this… Read more

0 comments, 149 reads

Posted in Tim Mitchell on 13 December 2018

PASS Summit 2018 – Keynote Day 2 Live Blog

It’s keynote time again! The second full day of the conference starts now, and like yesterday, I’ll be live-blogging during the keynote announcements. Our community Wendy Pastrick starts us off by sharing a bit of the softer side of the Summit – some of the stories, the networking opportunities, and… Read more

0 comments, 170 reads

Posted in Tim Mitchell on 8 November 2018

PASS Summit 2018 – Keynote Day 1 Live Blog

Today is the first full day of the PASS Summit in Seattle, Washington. This is the 20th year of the Summit, which brings together several thousand data professionals for a week of learning and networking. This morning, I will be live-blogging the keynote. This post will be updated periodically through… Read more

1 comments, 284 reads

Posted in Tim Mitchell on 7 November 2018

Where Are Your Data Leaks?

It has been almost impossible to avoid reading about the numerous large-scale data breaches reported on a seemingly daily basis. Stories of bad actors getting their hands on personal data are terrifying and always result in bad press for the breached company. However, not all data exposure scenarios make the… Read more

0 comments, 1,910 reads

Posted in Tim Mitchell on 25 September 2018

Speaking at PASS Summit 2018

I am honored to have been selected to be a presenter at this year’s PASS Summit coming up this November. I will be presenting a half-day talk entitled Build a Metadata-Driven ETL Repository with Biml and SSIS: Your boss tells you that a new field will be added to one… Read more

4 comments, 264 reads

Posted in Tim Mitchell on 6 June 2018

Temp Tables in SSIS

Temp tables are very handy when you have the need to store and manipulate an interim result set during ETL or other data processing operations. However, if you use SQL Server Integration Services as your ETL tool, you may find some challenges when trying to work with temp tables in… Read more

8 comments, 421 reads

Posted in Tim Mitchell on 29 May 2018

Managing Business Logic

Encapsulating business logic into data movement and presentation is a critical part of a stable information management strategy. Too often, though, business logic is built and added late in the process, forcing it into whatever nooks and crannies are available. While this duct-tape approach sometimes works, it makes the resulting… Read more

1 comments, 278 reads

Posted in Tim Mitchell on 17 May 2018

Trading Data For Convenience

If data is the new oil, then the web is the world’s biggest gas station. Every day a few billion people visit this marketplace and trade some of their personal data for convenience. We tell Google Maps or Waze where we are and where we intend to go. We share… Read more

0 comments, 249 reads

Posted in Tim Mitchell on 8 May 2018

Using SQL Server Management Studio Projects

One of the most underutilized assets in SQL Server Management Studio is the SSMS project. Within Management Studio, one can create code projects that make organizing SQL scripts much simpler, and more easily integrate with source control systems. In this brief post, I’ll show the essentials of using SQL Server… Read more

3 comments, 509 reads

Posted in Tim Mitchell on 22 December 2017

A Business Lesson from an Oil Change

When I first moved to the city where I now live, I found an oil change place just a couple of miles from my house. The location was convenient and I never had any major issues with the service there, so it became my go-to shop for automotive oil changes… Read more

1 comments, 357 reads

Posted in Tim Mitchell on 21 December 2017

Older posts