Today is the second day of the 2013 SQL PASS Summit, and I’m again live blogging the event.
8:15: Here we go. Looks like a thinner crowd today. Everyone sleeping in from #sqlkaraoke last night?
8:19: The morning is kicked off with a video montage about networking. It’s good to… Read more
Today is the first full day of the PASS Summit 2013 conference. This year I’m again joining the blogger table and will be live blogging throughout the opening ceremonies and the keynote. This year I’m sitting between Colin Stasiuk and Andy Warren.
I’ll be updating this post periodically through the… Read more
It’s that time of the year again – time to make your voice heard as a PASS member. The PASS board elections are upon us, and if you’ were a PASS member as of June of this year, you should receive your ballot via email tomorrow. Remember that this year’s… Read more
This past weekend I made the relatively short (about 3 hours) trip to the Oklahoma City area to attend and speak at the third annual SQL Saturday event there. I’ve been invited to speak at each of their three events, and I’ve been impressed with each one of them so… Read more
As I was browsing my calendar of upcoming events for the remainder of the summer and the fall, I realized two things:
- This will likely be the busiest, most travel-heavy three months I’ve ever had, and
- I’m going to have to buy my wife something really nice by the time…
Of the many emerging technologies I’m currently using, there’s nothing that excites me more than Biml. If you’re not familiar with it, Biml (short for Business Intelligence Markup Language) is a language that allows business intelligence developers to programmatically create and document SSIS packages. I’ve found this to be incredibly… Read more
When it comes to ETL, I’m a pessimist. Until proven otherwise, I assume that all data is bad, all connections are volatile, and all transformation logic is suspect. As such, I spent a lot of time addressing how to prepare for and handle errors in the ETL pipeline with SSIS.… Read more
Through the course of my career, I’ve spent time on both sides of the job interview table, which has given me an empathy for both job interviewees as well as their interviewers. The former wants to put his best foot forward to demonstrate (or at least talk about) his most… Read more
I love music. In fact, I like to think that I’m a student of music – although anyone who has heard me sing karaoke would agree that I’m far from having mastered it. I’ve got a taste in music that is as diverse as anyone I know. I enjoy tunes… Read more
- Iowa City, Iowa – Friday, July 26th (before SQL Saturday 239 – East Iowa)
- Orlando, Florida – Friday, September 13th (before SQL Saturday 232 – Orlando)
In the first post in this series, I covered the basics of object typed variables in SQL Server Integration Services, along with a brief examination of some potential use cases. In this installment, I’m going to illustrate the most common use of object typed variables in SSIS: using an… Read more
Temporary Post Used For Theme Detection (6a375569-f9c1-4835-a7fb-fa1ba0b240e4 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (e621c360-788f-48aa-bd56-670930569ab5 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
I’m happy to announce that I have been selected to present
at the SQL PASS Summit in Charlotte, North Carolina this October. I’ll be delivering a session entitled “Data Cleansing in SQL Server Integration Services”, in which I’ll cover various ways to detect and cleanse dirty data using tools built… Read more
Tomorrow at 10am (11am EDT), I’ll be joining together with my good friend and SSIS Design Patterns coauthor Andy Leonard for a free one hour webinar to discuss scripting in SQL Server Integration Services:
Join SQL Server MVP Tim Mitchell and Andy Leonard as they discuss and demonstrate scripting in…
I’m happy to announce that I’ll be doing a tour of the 4 SQL Server user groups in central Colorado next week. I’ll be speaking at these four user groups:
Monday (3/18): Northern Colorado Database Professionals
Tuesday (3/19): Boulder SQL Server User Group
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
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
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
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
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?