Writing Series I am in the midst of incrementally publishing a guide to ETL best practices. This guide is platform-agnostic, intended to highlight recommended methodologies for ETL architectures on any platform. I am writing a series of posts on using SSIS in the cloud, as well as a series on SQL Server temporal tables. I also have a series of SSIS…
Tim Mitchell is a business intelligence architect, author, and trainer. He has been building data solutions for over 20 years, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is a 13-time recipient of the Microsoft Data Platform MVP award (2010-2022). Tim is the founder and principal data…
I’m back home after a long week attending and presenting at the SQL PASS 2012 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 a full-day preconference seminar before the Summit. Unlike last…
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 with some spectacular SQL Karaoke. Yet here were are, getting…
I’m happy to announce that the North Texas SQL Server User Group will be hosting our fourth SQL Saturday event this fall. SQL Saturday #163 will be a BI-focused event similar to the one we hosted in the Fall of 2010. We invite you to join us at the Microsoft campus on Saturday, October 13th for a full day of…
It’s SQL Saturday season again. I found out this morning that I’ll be speaking at next month’s SQL Saturday event in Houston. This will be my second consecutive year to speak at this event. The crew in Houston is great to work with. Nancy Hidy Wilson, Jonathan Gardner, Malik Al-Amin, and the others event planners did a great job last…
Have you voted yet for my sessions your favorite sessions for SQL Rally. If not, this is a friendly reminder to hop on over and vote now. You have to have a PASS login to vote, but don’t worry – it’s free to get one and takes about 2 minutes. Out of the 60 total sessions to be presented at…
Like many others, I’m planning a few changes for my life for next year. I’m a believer in finding one’s own way, while still abiding the advice of the wise. Often called upon for inspirations are the timeless words of Confucius, the inspiring speeches of Martin Luther King, the controversial yet insightful analyses of Sigmund Freud, and the various authors…
This past Saturday, I made the relatively short (3 hour) drive north to Oklahoma City to participate in their first ever SQL Saturday event. I have to say that this was one of the best SQL Saturday events I’ve attended, which is especially notable since it was their first such event. The venue they chose was the Moore Norman Technology…
“Hey man, this is Ty*, what’s happening?” roared the familiar voice in my Bluetooth earpiece. It was a voice I knew well, and briefly brought a smile to my face. After exchanging pleasantries and catching up a bit, Ty revealed the real reason for his call: “Say, dude, I’m looking for a new job, and I was hoping you’d write…