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

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

0 comments, 40 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

4 comments, 72 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, 62 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, 121 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, 215 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,857 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, 230 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, 372 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, 240 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, 213 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, 468 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, 324 reads

Posted in Tim Mitchell on 21 December 2017

Making a Difference: Andy Warren

Since I started working as a data professional some 15 years ago, I’ve had an enjoyable and successful career. I attribute the successes I’ve had to hard work, a good bit of luck, and having help from others who have walked the same path before me. Today, I want to… Read more

0 comments, 278 reads

Posted in Tim Mitchell on 20 December 2017

Do You Really Need Real-Time?

It wasn’t so long ago that the first day of the month was the most common trigger event for updating key metrics. Indicators such as profit, efficiency, bonuses owed, and other markers would be published monthly after that month’s data was tabulated (which may be days or even weeks into… Read more

2 comments, 366 reads

Posted in Tim Mitchell on 19 December 2017

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

5 comments, 303 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

4 comments, 328 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, 379 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, 564 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, 379 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, 355 reads

Posted in Tim Mitchell on 13 December 2017

Older posts