Articles by Tim Mitchell

On Being Disruptive

On Being Disruptive

Being disruptive is a powerful way to conduct business. Steve Jobs and Bill Gates insisted that computers belonged not just in business offices but in the homes of regular joes, and built businesses around a need that had not fully manifested itself. Twitter disrupted the social media space by bringing to market a medium for short, frequent, and publicly visible…


Execute SSIS Packages with T-SQL

A Better Way to Execute SSIS Packages with T-SQL

There are several ways to execute SSIS packages that have been deployed to the SSIS catalog, and my favorite way of performing this task is to execute SSIS packages with T-SQL. There are a couple of challenges that come up when executing catalog-deployed packages using the default settings in T-SQL, but I have workaround for those issues which I’ll cover…


SQL Server Change Tracking

Video: Introduction to SQL Server Change Tracking

SQL Server change tracking is a lightweight and synchronous mechanism for detecting inserts, updates, and deletes in tracked tables. For those of us who spend a lot of time in ETL, change tracking is a useful tool for defining what data has changed to make the extract-transform-load process more efficient. SQL Server Change Tracking In this 30-minute video, I introduce…


SQL Server 2016 SP1

SQL Server 2016 Service Pack 1 Changes Everything

Earlier today, Microsoft announced the release of Service Pack 1 (SP1) for SQL Server 2016. Pay close attention to this announcement, because this is not a typical update. Service Pack 1 unlocks most all of the programmability features found in Enterprise Edition, making them available in lower-cost (and even free) editions of SQL Server. Folks, this is a huge change…


SSIS Catalog Project Versioning

SSIS Catalog Project Versioning

If you’ve spent much time working with the SSIS catalog, you likely already know that the catalog is where all assets related to package storage, configuration, and execution are stored: all of the projects and their associated packages, configuration environments, and execution logs are all stored in the SSISDB database used by the SSIS catalog. When deploying a new package…


ETL Atomicity

ETL Atomicity

I still remember the first real ETL process I developed. I was working for a hospital at the time, going through a major system implementation as we replaced a 17-year-old UNIX-based system with a more modern healthcare application suite with a SQL Server back end. I was tasked with building, testing, and executing the ETL processes for this conversion. While…


Data Warehouse

Webinar on Change Tracking for Data Warehouse Loads

Join me online on Tuesday, November 15th at 1:00PM as I host a webinar entitled “Managing Data Warehouse Incremental Loads with SQL Server Change Tracking”. In this webinar, I’ll discuss the essentials of incremental loads, and will introduce SQL Server change tracking. I’ll talk about how change tracking can be used in data warehouse load scenarios, and will show several…


SQL PASS Summit

PASS Summit 2016 Recap

It has been a fantastic week here in Seattle at the annual PASS Summit. I’ve spent the last five days hanging out with 4,000 or so of my closest friends while teaching and learning more about SQL Server and data management. Although my schedule kept me busy – I delivered 3 sessions including a half-day on Biml – but I…


PASS Keynote Day 2

PASS Summit 2016: Day 2 Keynote

This week I’m attending the SQL PASS Summit in Seattle. I’ll be live blogging each of the keynote presentations on Wednesday and Thursday morning. This post will be updated throughout the duration of the Day 2 keynote. It’s the second full day of the PASS Summit and we’re back for another keynote. Today we’ll hear from the always-popular David DeWitt,…


SQL PASS Summit 2016

PASS Summit 2016: Day 1 Keynote

This week I’m attending the SQL PASS Summit in Seattle. I’ll be live blogging each of the keynote presentations on Wednesday and Thursday morning. This post will be updated throughout the duration of the Day 1 keynote. Introduction We’re off and running! PASS president Adam Jorgensen starts us off with some opening remarks about PASS, Microsoft. Adam shares that PASS…