Tim Mitchell
Follow Tim Mitchell on Twitter  Like Tim Mitchell on Facebook  Subscribe on YouTube  Connect on LinkedIn  Subscribe to the Data Geek Newsletter

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 page. May your feats of strength be mighty, your airing…


Market

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 the relationships built around this now 20-year-old event. We learn…


Seattle

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 the course of the keynote. If you are not in…


Data leaks

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 news, and many can go unnoticed or unreported for years. Data leaks…


PASS Summit 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 of your vendor’s data files, and asks how long it will…


Temp Tables in SSIS

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 SSIS packages, especially in the SSIS data flow. In this…


Business Logic

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 system difficult to maintain when the business logic is spread…


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 (and sometimes overshare) with FaceTwitRedditGram the essential details of our lives…


SQL Server Management Studio Projects

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 Management Studio projects for T-SQL code management. T-SQL Code Management…


business lesson

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 and other light maintenance tasks. One day, when I was…