-->
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.

My SQL Server Management Studio Setup

We’re all creatures of habit, and work more efficiently when we know exactly where to find the tools we need. The same holds true with digital tools, and those of us who work with SQL Server will spend a lot of time using SQL Server Management Studio. SSMS has a… Read more

0 comments, 62 reads

Posted in Tim Mitchell on 18 December 2017

Some Thoughts on Community, Leadership, and Continuous Improvement

The SQL Server community is just awesome. I can’t say that enough. I may sound like a broken record when I keep repeating these things, but I owe a great deal to the community. I’ve worked hard in my career, but I am certain I would not be where I… Read more

2 comments, 154 reads

Posted in Tim Mitchell on 17 December 2017

The Value of Shortcuts

Decades ago when I was working as a retail clerk, I had a boss named Billy. Billy was a pragmatic guy who had worked in retail most of his adult life, and was full of practical tidbits of advice. He also had no tolerance for inefficiency, and was quick to… Read more

1 comments, 163 reads

Posted in Tim Mitchell on 16 December 2017

To Learn, Teach

Back before I started doing technical presentations or writing blog posts, I frequently found myself in awe at those who did those things. Watching someone present on a deeply technical topic or reading an article about a complex concept always made me wonder what chain of experiences would give the… Read more

1 comments, 133 reads

Posted in Tim Mitchell on 15 December 2017

Picking The Right Team

Years ago, back before I became a consultant, a job search led me to an interview with a technical company. The company was large enough to offer a variety of challenges with room for advancement, but wasn’t so big that one would get lost in a sea of employees. The… Read more

1 comments, 157 reads

Posted in Tim Mitchell on 14 December 2017

The Value of Consistent Design

Yesterday I wrote about best practices, illustrating that what may be an assumed technical design standard doesn’t fit every scenario. In a similar vein, I believe that consistency often trumps what are considered to be best practices. In this post, I’ll share some thoughts on the value of consistent design.… Read more

0 comments, 149 reads

Posted in Tim Mitchell on 13 December 2017

When Best Practices Aren’t Best

Most everyone is familiar with the term best practices. This phrase describes an industry-specific design or methodology that can be applied to most problems in a given domain. Data professionals, carpenters, medical practitioners, retail professionals, hair stylists, and most any other craftsperson will learn through experience a set of rules… Read more

2 comments, 180 reads

Posted in Tim Mitchell on 12 December 2017

The Eleven Days of Festivus 2017

Last year, I celebrated the holiday season by blogging daily during the 11 days leading up to Festivus, writing about SSIS, reporting, and leaving data trails. I had so much fun doing that stretch that I’m doing it again this year for Festivus 2017. Starting today and continuing through Festivus… Read more

0 comments, 115 reads

Posted in Tim Mitchell on 12 December 2017

The One Piece of Career Advice I Wish I’d Gotten

Over the years, I’ve been approached numerous times with requests for advice from folks who are looking to get started in technical careers. Some of these questions come from new or soon-to-be college graduates who are just starting their journey, while others are from experienced professionals looking to move into… Read more

2 comments, 1,996 reads

Posted in Tim Mitchell on 29 November 2017

Long Live OLE DB!

Back in August of 2011, an announcement from Microsoft started a wave of angst among those who build and support solutions on the Microsoft data platform. In that brief blog post, the data access team announced the deprecation of the OLE DB data interface driver, and that SQL Server 2012… Read more

3 comments, 198 reads

Posted in Tim Mitchell on 20 November 2017

Training Day in London: Building Better SSIS Packages

I am delighted to announce that I’ll be delivering my full-day course, Building Better SSIS Packages, at the SQLBits conference in London on Thursday, February 22nd. This course is aimed at data professionals with experience in SQL Server and a general understanding of SQL Server Integration Services concepts. This will… Read more

0 comments, 186 reads

Posted in Tim Mitchell on 17 November 2017

PASS Summit 2017 Day 2

It’s day 2 of the PASS Summit. Yesterday was a whirlwind of a day, after my early-morning post-Halloween trip to Seattle. I spent some time with my Microsoft friends in the SQL Clinic and visited several vendor receptions, followed by a quick visit to the karaoke party. Today is the… Read more

2 comments, 436 reads

Posted in Tim Mitchell on 2 November 2017

PASS Summit 2017 Day 1

It’s the first full day of the 2017 PASS Summit. As I write this, I am somewhere over the panhandle of Texas headed for Seattle and the rest of my #SQLFamily who are are already at the Summit. It’s been a bit strange for the last few days as I… Read more

1 comments, 185 reads

Posted in Tim Mitchell on 1 November 2017

SQL Server Temporal Tables

Temporal data storage, which was defined in the ANSI SQL:2011 standard, describes an architecture in which relational databases maintain row-level versioned copies of data. When using temporal data, the database does automatically what many DBAs and application developers have had to do manually for years to track point-in-time versioning for… Read more

1 comments, 1,768 reads

Posted in Tim Mitchell on 11 October 2017

PASS Summit 2017 is Coming

The yearly PASS Summit is just around the corner, a little less than six weeks away. For those not familiar with this event, it is a gathering of several thousand data professionals for 4+ days of education and networking. The PASS Summit will take place in Seattle, Washington, from Tuesday,… Read more

2 comments, 211 reads

Posted in Tim Mitchell on 22 September 2017

Knowing Your Data

Is it possible to be an effective data professional without knowing anything about the domain of data you support? I remember having a conversation a few years ago with a friend of mine, a fellow data practitioner. In his role as a database administrator, he asserted, he could do his… Read more

0 comments, 190 reads

Posted in Tim Mitchell on 1 September 2017

Using the SSIS Script Component With Multiple Outputs

One of the more common questions I find in SQL Server SSIS forums is how to split apart a single text file into multiple outputs. Files extracted from foreign sources often arrive in nonstandard formats, and are too often unchangeable at the source and must be parsed during the import… Read more

6 comments, 185 reads

Posted in Tim Mitchell on 22 August 2017

Upcoming Full-Day SSIS Class in Dallas

This year I’ve delivered my full-day Building Better SSIS Packages course a half dozen times across the country, but I hadn’t scheduled this class in the Dallas area this year. As of today, that has changed! I’m happy to announce that I’ll be delivering this class at the Microsoft office… Read more

0 comments, 206 reads

Posted in Tim Mitchell on 21 July 2017

Create a Staging Load with Biml

When designing the ETL architecture for new or changing systems, one of the more common needs is to create a process that copies all of the data from a set of tables (perhaps even all tables) from a source system to a destination database. This is especially prevalent when building… Read more

2 comments, 1,115 reads

Posted in Tim Mitchell on 12 July 2017

Running SSIS in an Azure VM

In the previous post in this series, I addressed how to use an on-premises instance of SSIS to move data to and from Azure databases. If you’re running in a pure Azure environment without on-prem SQL Server, that load architecture would present some challenges. However, by running SSIS in an… Read more

2 comments, 564 reads

Posted in Tim Mitchell on 10 July 2017

Older posts