Lunch with someone new

shakeI met up for lunch with a good friend and former coworker today, and among the topics of discussion was how we as professionals often neglect personal relationships when work and life get busy.  I’ve found that to be especially true since I started working from home last year.  I don’t miss a lot about working in an office setting, but I do long for the days of hallway conversations and working lunches with colleagues. When working in isolation, it can be easy to get into cocoon-mode, shutting out the rest of the world – to the detriment of interpersonal skills and relationships.  Through my work as a professional presenter, I get to talk to a lot of people, but more often than not I’m talking to them in a group setting with little one-on-one interaction.  While the former is useful for building a list of contacts, it doesn’t do much to truly build relationships.

Five years ago, in January of 2009, I set a goal for myself to have lunch or drinks with someone new – not necessarily a stranger, but someone with whom I had not spent any one-on-one face time – on a monthly basis.  I exceeded that goal in a big way.  And I don’t think it’s an accident that 2009 and 2010 were two of the biggest growth years of my career. I didn’t land any work directly as a result of those relationships – in fact, several of the people with whom I met weren’t business associates but personal acquaintances. For me, the bigger benefit was to get out of my comfort zone and get to know more people on a personal basis, whether or not I saw a direct career benefit to meeting with them.  I firmly believe that, five years later, I’m still seeing benefits of getting out of that comfort zone.  And just as importantly, I had a lot of fun!

So I’m going to rekindle this goal.  Since it’s not January, I don’t have to call this a New Year’s resolution, but I’m going to commit to share a meal or drinks with someone new at least once a month (including this month) for the remainder of this year.  I’ll hope that I exceed the goal as I did in 2009.

If you’re not regularly spending face time with peers and acquaintances, I would encourage you to give it a try.  Go out for coffee with someone you meet at a professional event.  Have lunch with an acquaintance.  Even if it’s uncomfortable for you – no, especially if it’s uncomfortable for you – it can pay big dividends in the long run.

PASS Summit 2013 Keynote, Day 2

Today is the second day of the 2013 SQL PASS Summit, and I’m again live blogging the event.  image

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 see emphasis on getting to know your peers.

8:21: Douglas McDowell talking about PASS finance.  A full 75% of PASS revenue comes from the annual PASS Summit.  Looks like the new Business Analytics conference contributes significantly (about 20%) to the budget, generating about 100k in net profit.  Interesting that SQL Rally is not mentioned.  Interesting note that PASS has been working on building up a rainy day fund, and the organization now has $1MM in financial reserves.  Good financial update – relatively brief and to the point.

8:30: Bill Graziano recognizes the outgoing board members, Douglas McDowell and Rushahb Mehta.

8:35: Tom LaRock, new PASS president, takes the stage.  He announces that PASSTv has reached 3,000 people in 79 countries this year.  He also recognizes the incoming ExecCo and board members for the PASS board.  He announces that the PASS Business Analytics Conference (BAC) will be held in San Jose, CA in May of next year, and the next PASS Summit will return to Seattle in 2014.

8:41: Dr. David DeWitt takes the stage.  He’s always a crowd favorite.  Heads may explode in the next hour.  He’ll be talking about Hekaton, the in-memory database technology.  He starts off by poking some fun at the marketing team and their habitual renaming of products.

8:45: Hekaton is memory-optimized but durable.  If the power goes out, you haven’t lost anything.  It is fully baked into SQL Server 2014, which was released in CTP2 earlier this week. The aim for Hekaton is 100x performance improvement, which cannot be gained through improvements elsewhere (CPU, etc.).  Hekaton is more than just pinning tables in memory, which in itself would not yield the expected performance gains.  Hekaton is an engine, not a bolt-on.

8:56: DeWitt talks about database concurrency, showing a small example of competing write operations.  Concurrency, locks, and serialization, oh my.  I think I just heard the first head explosion of the morning.  The slide deck can be downloaded here

9:05: Hekaton uses a timestamp mechanism rather than latching.  Related: lock-free data structures.  DeWitt confesses that lock-free data structures are really hard to understand, but gives a couple of brief examples (via animation) of how performance of latches versus lock-free structures operates under a workload.  Hekaton concurrency control is based on three techniques: optimistic data read/write, multiversioning, and timestamping.  When he describes the timestamp mechanism with start/end valid periods, end timestamp of infinity used to represent the current row, it sounds a little like an in-memory version of a slowly changing dimension.  A non-blocking garbage collector will clean up expired or no-longer-valid rows as a transparent background process.

9:37: I have to admit that this stuff blows my mind.  As a BI practitioner, I pay attention to database performance and concurrency issues, but I’ve never dived into the engine in this level of detail.  Though I’m not a performance guru, it’s apparent to me that this stuff is truly revolutionary.  Note to self to find a way to experiment with this soon.

9:57: David DeWitt wraps up.  Great stuff, and it’s obvious the crowd was behind him the whole way (even if he blew minds along the way).

PASS Summit 2013 Keynote, Day 1

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

7:59 am: Found my seat and got wired up.  It appears that coffee will not be served until after the keynote.  In related news, most of the room is already asleep.  I’ve appealed to Twitter in hopes that someone might kindly bring me some Starbucks.

8:20 am: We’re underway. PASS president Bill Graziano kicks off the event and introduces the board members.

8:27 am: This year, 700,000 training hours have been delivered through 227 chapters and 22 virtual chapters.

8:28 am: Giving some love to SQL Saturday via a brief video presentation.  Showing the locations of SQL Saturday events around the world using Power Map, which really drives home how much reach these events really have.

8:30 am: Bill announces that Amy Lewis has been selected as the PASSion Award winner this year.  Big congrats to my friend Amy!  Also, Ryan Adams gets props from Bill as an honorable mention.

8:38 am: Quentin Clark takes the stage, wearing his smart business casual attire.

8:42 am: Interesting analogy.  Quentin asserts that the relationship between on-prem storage/processing and the cloud as being similar to the relationship between brick-and-mortar stores and online retailers.  E-commerce did not end retail stores, and similarly, the cloud will not eliminate the need for on-prem data.

8:46 am: SQL Server 2014 CTP2 is now generally available for download.

8:51 am: Tracy Daugherty takes the stage to demonstrate in-memory capabilities of SQL Server 2014.  He demonstrates an implementation of in-memory technology on a fictional online store, showing the before-and-after query times when adding memory optimization to a key table.  Queries taking several seconds occur almost instantaneously.

9:02 am: On-prem database backup to Azure?  I’m interested.  Tracy shows the new UI feature where you can select URL as a destination for a backup.  Also, new encryption options available in 2014.  Also, automatic log backups on SQL Azure?  Tracy also shows the new feature (available via free download) that allows you to backup databases in older versions of SQL Server to Azure.

9:09 am: Oops.  Network failure during the demo is a perfect example of why you can’t wholly rely on the cloud for the success of your business.

9:28 am: After 20 minutes of mostly marketing hype, it looks like we’re going to see more demos.  A little dose of Power BI – using Power Query to bring together disconnected sets of data into a unified view, a function that can be performed by non-technical business users.  Brief glimpse of Power BI on mobile devices, even fruity ones.

9:40 am: Impressive… querying a database using plain English.  “Show number of calls per capita by country” yields a valid set of data.  Adding “as map” changes the output from bar chart to map.  We’re breezing over the details of how this works, but if it really works as shown, this is going to be a game changer for self-service BI.  Hopefully not just a rehash of English Query.  Go to to sign up and use this.

9:44 am: Power BI contest is announced. to participate.  Tell your Power BI story to win prizes including XBox One, Surface 2 Pro, trip to PASS Analytics conference.

9:48 am: That’s a wrap.  Nothing earth-shattering here.  Most interesting to the general populous is the release of SQL Server 2014 CTP2.  A few cool things with Power BI as well, which I’ve still yet to explore.

It’s Election Season

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 voting window is very narrow – just five days – so be sure to get your votes in before the deadline of noon PDT on September 30th.  I would encourage you to get to know the candidates, if you don’t already.  PASS has an elections page where you can find out about the candidates, ask questions via the forums, and link to Twitter chats with the candidates.

This year, my decision on whom to support for the open board positions was complicated in that I count several of the candidates as friends.  I’ve known most of the candidates for several years, and know them to be hard-working and ethical folks, any of whom would serve the SQL community well as a board member.  In the end, I based my decision on personal experience working with a few of these candidates, through which I was able to get to know not only their work ethic but their passion and drive to serve the community.

For the SQL PASS board election this year, I am happy to support the following candidates:

Amy Lewis

I spent several years working with Amy through our shared involvement in the PASS BI/DW virtual chapter.  Amy was relentless in her efforts to sustain and grow the group, and as a direct result of her efforts the group grew significantly.  She rarely sought recognition for her efforts, but was the driving force behind the success and growth of this group.  I believe her ideas and track record of success will help her continue to serve the community as a PASS board member.

Allen Kinsel

Allen was one of the first people I worked with when I started volunteering with PASS.  I was immediately impressed with Allen’s passion and bias to action.  He is a shoot-straight Texan who is not afraid to speak up even if what he has to say is unpopular.  Further, Allen already has seen success as a prior PASS board member.

Jen Stirrup

I’ve not known Jen as long as the other two candidates I mentioned, but I got the chance to work with her a bit through the BI/DW virtual chapter.  A quiet and very humble person, Jen also has a great deal of passion and sincerity in her efforts in the community.  I believe Jen’s presence on the board will be an asset to the growing PASS presence in the EMEA region.

Are you really an expert?

salesmanThrough 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 appealing attributes, while the latter seeks to find the best fit for the position while pitching her employer to qualified candidates.  On both sides of the table, folks do their best to paint their respective positions in the best light while (hopefully) remaining truthful.

Although the interviewing process can be stressful for interviewers, it’s particularly hard on the interviewees.  After all, they are the ones who will be most directly impacted by any hiring decision.  Have a bad interview and you’re going nowhere; nail the interview and you could reach a major career milestone.  As such, there’s a lot of pressure to make yourself appear to be the best candidate you can be.  Often, candidates will use superlative terms to describe themselves:

  • I am an expert in XYZ software.
  • I have senior level skills in widget making.
  • I have an advanced proficiency in flux capacitor maintenance.
  • I am a thought leader in the field of bacon curation.

There are a lot of very smart folks out there, a number of whom truly are experts.  But increasingly, my experience in this area has taught me that there are many candidates who apply to themselves label including expert, senior, and specialist, simply as a selling point without having real basis for such an assertion.  When candidates use these terms recklessly in their résumés and in interview conversations, they are setting themselves up for a hard landing at some point in the future.

Fake it ‘til you make it?

Describing oneself using superlative language can impress an interviewer, in some cases.  Take for example the typical corporate interview scenario, in which one sits first with interviewers from Human Resources.  The interviewer may or may not have specific knowledge about the field in which the candidate specializes.  A skilled interviewee will pick up on this, and may be compelled to dazzle the interviewer with buzzwords while describing his own skillset as superior.  And if he’s very lucky, he’ll get a second interview with an interviewer who assumes that HR has done the necessary vetting, and may not ask the necessary in-depth questions to weed out the unqualified candidate.

Although unlikely, it’s possible for a candidate to bluff his entire way through the interview process all the way to the job offer.  Even if things get that far, it’s still going to turn out badly for both sides.  When a person describes himself as an expert, such strong language sets an expectation for job performance.   Portraying oneself as an expert implies deep knowledge in the topic, good decision-making skills in the field of expertise, and a history of success.  When the expectations greatly exceed the actual results, it’s going to turn out badly for the “expert”.

The phrase “fake it ‘til you make it” often comes up when pitching oneself for work.  Although this might work at lower skill levels, it’s much harder to fake being an expert when it comes time to actually do the work.

Having conducted technical interviews with scores of candidates, I can tell you that those who described themselves as experts in a particular discipline usually got extra scrutiny in their self-described areas of specialization.  Many of them did quite well upon inquiry, but a disheartening number of folks who claimed to have superior skills in a particular area had a difficult time answering even the most basic questions.

Experts are made, not born

Becoming recognized as a thought leader in a particular area doesn’t come by applying a label to oneself.  It’s been written many times that it takes about 10,000 hours – about five working years – of doing something to truly become an expert in it.  Some things will take far less time to master (Minesweeper) while others require much more (neurosurgery).

With that in mind, don’t try to sell yourself as an expert if you aren’t.  Remember that there are other attributes on which you can rely that have a great deal of appeal to employers.  For example, if I’m looking for someone with senior level skills in a particular discipline, I might consider a candidate with midlevel skills who also demonstrates a great deal of enthusiasm and a strong desire and aptitude to learn.   And don’t forget: attitude, attitude, attitude.  Most hiring managers would choose someone with good skills and a great attitude than a jerk with tons of experience.

Sell yourself

Don’t take the advice in this post to mean that you shouldn’t talk yourself up to a potential employer.  Job interviewing is nothing more than sales: you’re trying to sell yourself to the company doing the hiring, and the employer is trying to decide if they want to “buy” what you’re selling (and hopefully, they’re trying to sell you on the company as well).  However, there is a difference between selling yourself, and selling yourself as something you’re not.  If you’re going to describe yourself as an expert in your field, make certain that the label is accurate.

As an aside, I’ve found that a large number of thought leaders in my field do not even describe themselves as experts.  The smartest folks out there realize that there’s still much left to learn in every vocation, and often refrain from labeling themselves as experts for fear of implying that they know everything there is to know.


The job interview process relies on trust and some measure of faith.  A candidate who unduly purports himself to be an expert is bound to be discovered at some point, and the later the discovery the worse the results tend to be.  Put your best foot forward during the interview process, but don’t sell yourself as an expert if you’ve not yet earned that distinction.

Key Change

piano 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 from multiple genres spanning decades of time, and I often blend seemingly incongruent styles together in a single listening session.  But equaling my enjoyment of the music itself is the appreciation for the technical components involved – the cadence, the symmetry, the melding together of disparate sounds in which the whole is greater than the sum of its parts.  Music is made up of both art and science, and certainly has the ability to inspire emotion in people.

One of my favorite technical elements of music is the key change.  The dramatic shift that comes along with a key change in the middle of the song can give the listener the feeling that things have just taken off, that the song has stepped up to a new level.  Indulge me if you will and take a ride back to the 1980s, where we’ll listen to one of the most recognizable artists from that decade: Genesis.  Jump over to YouTube and listen to Invisible Touch.  Take 4 minutes and listen to the whole thing, or if you’re in a rush, jump forward to about the 2:45 mark.  (Go ahead, I’ll wait.)

Welcome back.  Did you hear what happened at about the 3:07 mark?  A sudden change of key in the song took it up by one full note.  The words didn’t change.  The rhythm or song speed didn’t change.  The song was great before the key change, and was great after the key change, but that relatively small change in key really added something, didn’t it?  Although not every melody would be appropriate for a dramatic key change such as this, it fit very well with the flow of this song.

So what does this have to do with data?  Nothing really, but it does have a lot to do with me.  Today, I’m announcing that I’m making a key change in my career.

It’s so hard to say goodbye

Before I share with you the details of my key change, I’ve got to say a few words about the family I’ve been a part of for the last 3+ years.  I came to Artis Consulting in February of 2010, after having a chance encounter with a friend of a friend at the SQL PASS Summit in 2009 (here’s my blog post about that networking success story).  At the time, I thought I was simply taking a new job – a great job to be sure, but just a job nonetheless.  Very quickly, I realized that this was more than just a job.  The first thing that wowed me was the level of technical excellence, professionalism, and collaboration that existed through the small company.  I had worked with sharp people in the past, but never before had I encountered such a concentration of exceptional individuals like I found at Artis.  Everyone watched out for everyone else.  Everyone shared his/her knowledge – there was no hoarding of information.  Everyone truly cared about the company and its clients, and expressed this not just in word but in deed.

But the culture of technical excellence and professionalism was not what made this more than just a job.  It was the people – the human beings that made up this small company.  Everyone knew each other, and we knew most of the families of our colleagues as well.  We enjoyed spending time with each other outside of work.  We laughed together during the fun times, consoled and encouraged each other during the trying times, and in general everyone took an interest in the lives of their colleagues.  Just like a real family.  I’ve come to know the people of Artis, and have built many friendships that I firmly believe will carry far beyond my time here.

Without a doubt, I am leaving the best job I’ve ever had – quite possibly the best full time job I’ll ever have.  It was the most difficult career decision I’ve ever had to make, and was incredibly emotional for me during and after the decision to move on.  But nothing lasts forever, and despite the fact that I’m leaving a part of my family behind, I am confident that this key change is the right move for me.

The final countdown

I hinted earlier this week that I had a big announcement to make.  Technically, I have two big announcements, although they are closely related.

Here I go again on my own

My first big announcement:  As of today, I am departing the ranks of full time employee, embarking on a career as an independent business intelligence consultant and trainer.  This has been a dream of mine for years, one that I managed to continually put off for various reasons.  After spending a great deal of time evaluating my long term goals, analyzing the current business intelligence market, and talking to other professionals who have made the move out of full time work, I decided that there’s no better time than now to make this move.

tyleris copy I’m incredibly excited about the possibilities that come along with the freedom of being independent.  I’m still in business intelligence, but now I’m focusing mostly on the data pipeline: integration, ETL, data quality, and reporting.  Just as exciting is the fact that I’m going to offer training as well, which is something that I am very passionate about but until now has been something I did only in my spare time.  My new independent consulting firm, Tyleris Data Solutions, officially launches today, and I’ll start with my first engagement on Monday.

As I mentioned, I delayed the decision to go independent for a while, due in no small part to my concern about being a lone soldier.  At Artis, if I got stuck on a problem or needed a second opinion on a design pattern, I had a network of people who were more than willing to lend a hand, ear, or other appendage.  But as an independent consultant, you’re out there on your own, a solitary rainmaker with no reinforcements.  This as much as anything was a factor in my hesitation to take the leap.  However, my #SQLFamily came through on this one to help allay my concerns about leaving behind my peer network.  For the last 6 months or so, I’ve been chatting off and on with my friends Andy Leonard and Brian Moran, both of whom I met through my activities in the community (and have I mentioned recently how important networking is to your career?).  After talking with both of these guys, they convinced me that I could have the best of both worlds: the freedom of being an independent consultant as well as a network of peers to provide mutual support.

The boys of summer

Linchpin After much deliberation and lots of talks with Brian and Andy, I’ve decided to lock arms with these very smart and professional individuals.  I’m happy to announce that I’m now a Linchpin People Teammate!  I’m joining the Linchpin team to add to their already strong data integration practice, and will immediately get to work on a complex ETL project with a couple of other team members.  Although I’ll still maintain my status as an independent consultant, I’ll get to work on some pretty cool stuff with these guys.  I believe this association with Linchpin People should strengthen all of us.

I’ve known the guys from Linchpin for a while.  Andy and I go back several years, having written a book and done several precon training events together.  I’ve not known Brian as long, but he and I became fast friends when we met at a PASS Summit a couple of years ago; in fact, I remember telling him just after we met that we’d eventually be doing something together.  Mike Walsh and I have known each other for several years, both virtually and in real life.  Several of the other Linchpin team members are friends of mine, and I have nothing but respect for the entire crew.  I am excited and proud to be associated with this fine group of folks.

Don’t worry, be happy

This change was an emotional one for me.  I went through the whole range – excitement, fear, sadness, optimism…  Change is rarely easy, but I’m confident that I’ve made a good decision.  Much like a key change in a song, I loved what I was doing before, and I expect that I’ll continue to love it after this change – I’m just taking it up a few notes.

Business Intelligence Projects now supported in Visual Studio 2012

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 Server Data Tools – Business Intelligence for Visual Studio 2012.  With this release, BI professionals may now fully move onto Visual Studio 2012 for SQL Server 2012 project initiatives.

You can read more about this release on the SSRS team blog and SSAS team blog, or download the code from the Microsoft website.

SQL PASS Summit 2012 in Review

I’m back home after a long week attending and presenting at the SQL PASS 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 year, though, this year we have all five members of the author team!  I also delivered two regular sessions: one on using DQS in the enterprise, and the other on how to handle errors and data anomalies in SSIS.


Saturday started off for me in Portland, Oregon, where I spoke at SQL Saturday #172.  I left that event just after the closing remarks and raffle (where I won a Kindle Fire HD – thanks Confio!) with Russ Loski and Karla Landrum to make the 3-hour drive from Portland to Seattle.  We rolled in late, maybe 10:30pm or so, and Twitter didn’t find much going on so I popped into Elephant and Castle for a snack while I reviewed my slide deck for Monday’s precon.


My first #sqlfamily sighting in Seattle was none other than my good friend Andy Leonard, and shortly thereafter I met up with Michelle Ufford at breakfast.  After breakfast, Andy, Michelle, Matt Masson, Jessica Moss and I met up at the convention center to rehearse our material for the precon the following day.  Had a great day of prep work, minor revisions, and a good deal of laughter.

Later, I stopped by the registration area and officially checked in, and greeted a lot of familiar faces.  About 20 of us got together for dinner at Cheesecake Factory, followed by a brief visit to the Tap House.  Since the next day would involve an early wake-up call, I retired by 9:30 to give my material one last glance.


I met up with Andy for a quick breakfast before getting wired up for our precon presentation.  We kicked off at 0830 with a crowd of about 110 or so.  It was fun to see a couple of folks in the audience who were also at our precon last year (shout out to Bill Fellows and Aaron Lowe).  We quickly found a good cadence of trading off between the five of us presenting, each person leading the discussion for about 75 minutes.  I shared design patterns around error handling, scripting, and data warehousing.  It was fun to interact with the audience (along with others not in attendance) via Twitter throughout the entire day, through which we were able to share links to supplemental information about the current topic as the day went along.  And on the topic of Twitter, my friend Andy offered me a valuable lesson about leaving my computer unlocked (and I shall have my revenge when you least expect it, good sir).


On Tuesday, I got to spend the day hanging out with a bunch of my favorite folks talking about SQL Server.  What could be better?  Later, I went by the PASS volunteer appreciation event to shake a few hands, followed by an after-hours trip to that karaoke favorite, Bush Garden.


I stopped by the keynote for a bit to listen to Bill Graziano’s opening remarks.  I stepped out to meet my friend Steve Jones for coffee, and ended up meeting up with about a dozen other folks as we chatted.  I caught up with a couple of my Artis Consulting colleagues, and was off to take part in a book signing at the PASS bookstore.  We got to chat with a few dozen folks (and managed to sell out all of the copies of our book at the bookstore!) in the hour or so we were there.

I sat in on the session by Matthew Roche and Matt Masson on enterprise information management (EIM).  I was particularly interested in the DQS portion of the presentation, and I was glad to learn a couple of new things about the product.  Later, I stopped by the SQL Clinic to say hello to some of the folks from Microsoft.  The vendor reception followed next door, where I did a little more networking and perhaps even some recruiting.

Wednesday was also #sqlkaraoke day, with not one but two sponsored karaoke events:  First up was the Pragmatic Works/Microsoft/HP event at the Hard Rock. These sponsors rented out the Hard Rock for some live band karaoke.  Yep – a real band, not just canned tracks!  This event was a ton of fun.  I didn’t count, but there must have been at least 600 people there.  I even got to belt out some Garth Brooks.  Later I went out to the second sponsored karaoke event, at our favorite little hole in the wall Bush Gardens.  It was a much lighter crowd there, maybe 75 people or so – enough to make it fun to socialize but still giving everyone who wanted to sing the opportunity to do so.


Since I was presenting on Thursday, I spent the morning going through my presentation materials again.  I delivered my DQS session after lunch, to a crowd of about 40-50 people.  Good discussion around the different moving parts of the product, though I was surprised that of the entire room, only one person was actually using DQS.  There were a couple of folks from the product team in my session, which I appreciated because I misspoke on the technical behavior of one of the elements of DQS, and they were able to set the record straight so I didn’t send folks off with the wrong message.

For the final session of the day, I sat in on the BI Power Hour.  This was easily the most entertaining session I attended.  Presented by a host of Microsoft rockstars, this 90 minute session offered a fun look at some uses of the Microsoft BI stack, PowerPivot, and related tools.  They had a standing-room-only crowd, and although their presentations were intended to be a little silly, I think they did a good job of showing some unconventional uses of those tools.

After the last session, I went to the Friends of Red Gate dinner at Fare Start restaurant.  This was the second year in a row that Red Gate has held the dinner at this location, which is a nonprofit training and placement organization aimed at homeless or otherwise disadvantaged individuals.  The food was outstanding and the company even better.  Later I stopped by the EMP Museum for the community appreciation event.  Since karaoke has been the theme of evening events, there was another live band karaoke for this fiesta as well.  I stayed for just a bit since I wanted to retire early and rehearse my demos again for Friday’s morning presentation.  Back in the room by 11pm or so, I rehearsed until about 1am until I completely ran out of fuel.


It’s time to talk about SSIS!  I’ve been working on my error handling presentation for quite a while, so I’ve really been looking forward to this.  I was a little concerned since it was a Friday morning after an apparently late night (at least according to the Twitter stream), and my presentation was scheduled for the same time as one given by the wildly popular Dr. David Dewitt.  However, I was pleasantly surprised by a roomful of folks ready to hear about SSIS error handling: the room monitor counted 177 people in attendance.  Lots of great questions and discussion both during and after the presentation – in fact, I was there for over 30 minutes after the presentation just chatting and answering questions.

8176663000_e35115555bAt lunchtime, I wandered down to the market to take a few pictures and watch them throw the fish around.  In the afternoon I took in a couple of sessions, one on DQS and another on slowly changing dimensions.  I skipped the last session of the day to stop into the PASS Community Zone, a very cool concept that just wasn’t very well publicized.

I had a craving for some fresh seafood, so I invited folks down to the Crab Pot for some crustaceans.  We had maybe 20 people altogether, though we did get split up since there was an early group and a late group.  After dinner, several of us went on the Seattle underground tour, a 75-minute walking tour of some of the basements and underground walkways beneath Seattle’s city streets.  Thanks to my friend Dave Stein for hooking us up with this!  It was a lot of fun and a good way to wind down.

8176709260_12cc735de2After the tour, a few of us headed over for one last trip to Bush Garden, where 30 or so SQL folks were already gathered.  I stayed for an hour or so, but fatigue got the best of me so I cabbed it back over (thanks to Randy Knight for taking care of our ride) and called it a night before midnight.


Travel day for me.  I headed over to the rail station early, only to be greeted by a locked door with a message that the train didn’t start running until 0830 on Saturdays.  As it turned out, I was at the monorail station when I should have instead gone across the street to the Link light rail station.  Inattention cost me about 30 minutes of standing in the cold, but on the upside, I met up with Ryan Adams and Michael Swart and got to chat with them on the 40 minute ride back to the airport.  Ryan, Adam Saxton, and I ended up on the same flight back home, so we got to chat while we waited for our bird.

One final parting gift was that my checked bag didn’t arrive on my flight.  The man at the AA lost luggage counter was very helpful, tracking my back to a later flight and arranging delivery to my home for later that evening (it arrived about 11pm).  Oddly enough, for as much as I’ve traveled, this was my first experience with a lost bag.  I suppose it was as good as any time to have one, since the bag had mostly dirty clothes and I didn’t immediately need anything in there.


It was an incredible week.  As expected, I (along with many others) operated on far too little sleep and way too much coffee for the entire time.  However, it was well worth the time, travel, and exhaustion to spend time with some of the smartest people on the planet.  I look forward all year to this trip, and this year’s SQL PASS summit did not disappoint.

Update: I have published the photos I took during the week on my Flickr stream.  You can find them here.