Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Tim Mitchell

Tim Mitchell is a business intelligence consultant, author, trainer, and SQL Server MVP with over a decade of experience. Tim is the principal of Tyleris Data Solutions and is a Linchpin People teammate. Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBits, SQL Connections, SQL Saturday events, and various user groups and webcasts. He is a board member at the North Texas SQL Server User Group in the Dallas area. Tim 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 twitter.com/Tim_Mitchell.

Business Intelligence Projects now supported in Visual Studio 2012

Since the release of Visual Studio 2012, business intelligence developers have been limited in how much they could use this tool due to the fact that it did not support BI project types (SSIS, SSAS, and SSRS).  Today, that limitation is now gone with the release by Microsoft of SQL… Read more

2 comments, 787 reads

Posted in Tim Mitchell on 6 March 2013

Using Object Typed Variables in SSIS

Note: This will be the first post in a short series on using Object typed variables in SQL Server Integration Services.

When defining variables in SSIS, the ETL developer has several data type options to choose from depending on the information to be stored in each variable.  Included in the… Read more

1 comments, 919 reads

Posted in Tim Mitchell on 4 March 2013

Dust Off That Resume

Since I started regularly attending SQL Saturday events some five years ago, I’ve sat in on a number of professional development sessions by Andy Warren, Buck Woody, Don Gabor, and others.  Each one offered different bits of advice based on his or her own experience, but there… Read more

0 comments, 1,973 reads

Posted in Tim Mitchell on 28 February 2013

Erin Welker joins Artis Consulting

Earlier this week, my employer, Artis Consulting, welcomed a new addition to our team.  Technical expert Erin Welker (b|t), a very well known and experienced business intelligence professional, has joined the BI practice here at Artis.  Erin brings a great deal to the table –… Read more

1 comments, 346 reads

Posted in Tim Mitchell on 8 February 2013

Fish and Chips, Robin Hood, SSIS, and Me

I’m going to Nottingham, England, fabled home of Robin Hood, where I’m going to eat fish and chips and talk about SSIS.  How’s that for tying seemingly unrelated topics together?

I’m happy to report that in addition to my full-day preconference seminar at SQLBits, I’ll also be delivering a… Read more

1 comments, 514 reads

Posted in Tim Mitchell on 30 January 2013

Join me at SQLBits for a day of SSIS

I’m happy to announce that I’ve been selected to deliver a full day of training at the upcoming SQLBits conference in Nottingham, England.  This will be my first time taking part in SQLBits (in fact, it will be my first trip to the U.K.) and I’m very much looking forward… Read more

6 comments, 379 reads

Posted in Tim Mitchell on 15 January 2013

Want to see me break SSIS this Thursday?

OK, I’m not really going to break it.  I’m just going to beat it up a little bit.

This Thursday evening, I’ll be working my home turf at the North Texas SQL Server User Group monthly meeting, presenting “When ETL Goes Bad: Handling Errors and Anomalies in SSIS” at 6:15… Read more

0 comments, 394 reads

Posted in Tim Mitchell on 15 January 2013

Ragged Flat File Processing in SSIS

Frequently I am asked how to properly use SQL Server Integration Services to handle ragged flat files, an example of which is shown below.  In this small sample file, you can see that we are dealing with medical data that has an inconsistent format.  As shown, the rows in the… Read more

7 comments, 801 reads

Posted in Tim Mitchell on 15 January 2013

2012 in Review

With the year 2012 now in the rear view mirror, and while I’m still in the midst of my holiday vacation (two whole weeks! Feels very strange…) , I thought I’d take stock of my tasks and accomplishments of the past year.

Sharing knowledge

I must sound like a broken… Read more

0 comments, 450 reads

Posted in Tim Mitchell on 4 January 2013

I Need Your Vote!

Do your civic duty, and vote today! 

Voting is now open for SQLBits, to be held in Nottingham, UK this May.  This event is probably the best-known SQL Server event outside of the US, and unlike most other such events, they use a popular-vote model for general session selection.  I’ve… Read more

0 comments, 730 reads

Posted in Tim Mitchell on 3 January 2013

The Great Blog Move of 2013

For at least a year, I’ve been considering changing blog platforms.  I set up my blog on TimMitchell.net using BlogEngine.NET several years back, a decision I made based primarily on the fact that this tool was built on ASP.NET and SQL Server as opposed to the LAMP platform used by… Read more

2 comments, 493 reads

Posted in Tim Mitchell on 3 January 2013

Re-awarded MVP status for 2013

I received notification that I have received the Microsoft MVP award for 2013, my fourth consecutive year to receive this distinction.

As always, I am grateful to my friends at Microsoft, the MVP program in particular, as well as my many friends and acquaintances in the SQL Server community.  It’s… Read more

4 comments, 260 reads

Posted in Tim Mitchell on 1 January 2013

Re-awarded MVP status for 2013

I received notification that I have received the Microsoft MVP award for 2013, my fourth consecutive year to receive this distinction. As always, I am grateful to my friends at Microsoft, the MVP program in particular, as well as my many friends and acquaintances in the SQL Server community.  It’s…

Read more

2 comments, 350 reads

Posted in Tim Mitchell on 1 January 2013

SQL PASS Summit 2012 in Review

I’m back home after a long week attending and presenting at the SQL PASS Summit in Seattle.  This was the best event yet, in my opinion, and for me it was certainly the busiest.  For the second year in a row, our SSIS Design Patterns team was invited to deliver… Read more

0 comments, 994 reads

Posted in Tim Mitchell on 11 November 2012

SQL PASS Summit 2012 in Review

I’m back home after a long week attending and presenting at the SQL PASS Summit in Seattle.  This was the best event yet, in my opinion, and for me it was certainly the busiest.  For the second year in a row, our SSIS Design Patterns team was invited to deliver… Read more

0 comments, 233 reads

Posted in Tim Mitchell on 11 November 2012

“It’s Alive” - SSIS Design Patterns

I’m happy to announce that the book I’ve been working on for the past two years is complete and has been released for sale as of today.  I got the unique privilege to work alongside SSIS rock stars Andy Leonard, Jessica Moss, Matt Masson, and Michelle Ufford Read more

0 comments, 498 reads

Posted in Tim Mitchell on 5 September 2012

“It’s Alive” – SSIS Design Patterns

I’m happy to announce that the book I’ve been working on for the past two years is complete and has been released for sale as of today.  I got the unique privilege to work alongside SSIS rock stars Andy Leonard, Jessica Moss, Matt Masson, and Michelle Ufford Read more

0 comments, 173 reads

Posted in Tim Mitchell on 5 September 2012

SQL Saturday 125 OKC

This weekend I traveled three hours north to Oklahoma City to participate in SQL Saturday 125, the second annual event hosted by the OKCSQL group. Ryan Adams, Russ Loski, John Sterrett and I hit the road midafternoon to give ourselves time to make it in time for the speaker… Read more

0 comments, 175 reads

Posted in Tim Mitchell on 27 August 2012

SQL Saturday 125 OKC

This weekend I traveled three hours north to Oklahoma City to participate in SQL Saturday 125, the second annual event hosted by the OKCSQL group. Ryan Adams, Russ Loski, John Sterrett and I hit the road midafternoon to give ourselves time to make it in time for the speaker… Read more

5 comments, 346 reads

Posted in Tim Mitchell on 27 August 2012

Join me at the PASS Summit

It seems just yesterday that we were all in Seattle together, getting a crash course in what’s new and exciting in SQL Server.  It couldn’t possible have been 8 months since we were attending after-party events together, stopping by the Tap House for a beer, or closing down Bush Gardens… Read more

0 comments, 325 reads

Posted in Tim Mitchell on 25 June 2012

Newer posts

Older posts