Articles by Tim Mitchell

The future of SQL Server business intelligence

PASS Summit 2015 Keynote – Day 2

Today is the second day of the SQL PASS Summit in Seattle, Washington. I’ll be live blogging today’s keynote address. This post will be updated throughout the keynote. Don’t forget you can watch the live stream on PASS TV. Adam Jorgensen, current EVP of finance (and future president) of PASS shares about the financial status of the organization. Revenue has…

The future of SQL Server business intelligence

PASS Summit 2015 Keynote – Day 1

Today, I’ll be live blogging the SQL PASS 2015 keynote. Today is the third day of the PASS Summit, and the first day with regular sessions. Everything shown in the keynote will also be streamed on PASS TV. As a logistical note, I’ll be updating this post throughout the keynote. PASS president Tom LaRock kicks things off by recognizing existing…

SSIS 2016

Kicking the Tires on SSIS 2016

Last week I hosted a webinar in which I reviewed some of the coming changes for SQL Server Integration Services in SQL Server 2016. The current beta of SSIS 2016 has some exciting new features that I think you’ll like. The recording of that webinar is below. Enjoy!

Advanced SSIS Training

Advanced SSIS Training Course Preview

If you are looking for some end-of-year training before the new budget year rolls around, consider joining Andy Leonard and me in the Washington, DC area for our 4-day Advanced SSIS classroom training course. This course will be held December 7-10 in Reston, VA (just outside of DC). I’ve recorded a brief intro below to give you a glimpse into…

SSIS 2016

Webinar: Kicking the Tires on SSIS 2016

The next version of SSIS is on the horizon. Are you ready? In next Tuesday’s webinar, I’ll be reviewing and demonstrating the new features of SQL Server Integration Services. Microsoft recently released the CTP bits for SQL Server and SQL Server Data Tools, both of which show several useful changes to SSIS. Registration is now open for this webinar.


Ryan Adams for SQL PASS Board

It’s election season! No, I’m not talking about The Donald, The Clinton, The Neurosurgeon, The Veep, or any of those folks. It’s time for the annual SQL PASS board elections. If you’re not familiar with the SQL PASS organization, I encourage you to check out what all they have to offer. This is an international organization that seeks to educate…


Webinar: Change Tracking for Data Warehouse Loads

For data warehouse professionals, change detection is critical. Accurately detecting new, changed, and deleted records means the difference between doing an expensive truncate-and-reload operation versus a smaller, faster incremental load. This is especially important as the volume of information stored in data warehouses continues to grow. SQL Server change tracking, a feature first introduced in SQL Server 2008, allows detection…

Balancing balls Newton's cradle on grey background

Building Better SSIS Packages Class in Dallas

I’m happy to announce a new, full-day class in the Dallas area next month. I’ll be presenting my Building Better SSIS Packages course on Friday, October 2nd at the Microsoft campus in Irving, Texas. This course is a preconference seminar for SQL Saturday Dallas, which will be held in Arlington, Texas the following day (October 3). Registration is open for…


Sixty Days to Summit–Are You Ready?

In just two short months – exactly sixty days from today – the SQL PASS Summit will begin. Although it’s still a couple of months away, this is a great time to start making preparations to ensure that you get the most out of your Summit experience. Download and install the latest SQL Server 2016 CTP bits. Even if you’re…


Above All, Good Judgment

What is permissible is not always honorable. – Marcus Tullius Cicero Rules. Best practices. Guidelines. Design patterns. Policies. All are good and necessary, and you’ll rarely find anyone who will argue against the need to establish boundaries and set expectations. But can adherence to rules and design patterns be taken too far? I believe it can. The Rules Gone Amok:…