SQL PASS 2010 Keynote, Day 1

The day 1 keynote was kicked off by a Tina Turner impersonator doing a rendition of “Simply the Best”.  Rushabh Mehta followed up with a Tina wig of his own, though he fortunately had a much less revealing outfit.  Rushabh starts off with an overview of the PASS activities for the year.  PASS has touched over 65,000 individuals this year…


SQL Saturday 56 Dallas (BI Edition) – Recap

This past Saturday, our NTSSUG group hosted SQL Saturday 56, which was our second SQL Saturday of the year.  This event was a departure from the typical SQLSat in that it strictly focused on BI, and featured topics including SSIS, SSRS, SSAS, SharePoint, MDX, and other disciplines in and around the Microsoft BI stack.  Due to space and logistical issues,…


PASS Summit, Birds of a Feather Lunch, and Ask the Experts

The PASS Summit is just around the corner, less than a month away.  Although I’m not presenting a session at the event, I’ll be contributing through a couple of other outlets this year. First of all, I’ll be hosting a table at the Birds of a Feather lunch on Tuesday, November 9th.  The BoF lunch is designed to facilitate targeted…


SQL Saturday 52 Recap

I spent this past weekend traveling to and attending SQL Saturday Colorado in the outskirts of Denver.  This was the first such event in this area, and was arranged and cohosted by volunteers from the local SQL Server user groups including Denver, Boulder, and Colorado Springs.  Marc Beacom, chapter leader of the Denver group, was the chief organizer and did…


Broken or Just Bent? #passvotes

Though things have died down a bit since the initial #passvotes backlash, the recent development in the PASS board election process is still the talk of the town. I’ve had the opportunity to talk to a number of folks about this, and have read some excellent blogs and other opinion pieces from those on both sides of the debate. I…


SSIS: Conditional File Processing in a ForEach Loop

I’ve fielded a number of requests recently asking how to interrogate a file within SSIS and change the processing rules based on the metadata of said file. A recent forum poster specifically asked about using the foreach loop to iterate through the files in a directory and, on a per-file basis, either process the file or skip the file if…


SQL Saturday 28 Baton Rouge – Recap

Last weekend I went to Baton Rouge (by way of New Orleans) to attend and speak at the second annual SQL Saturday event there.  This event was my third of four scheduled SQL Saturday of the summer. I flew out of Love Field in Dallas with fellow Dallas SQL Server pros Sean McCown and Tim Costello, and we met up…


It’s the Process

Unless you’ve spent the last two days hiding under a rock, you’ve heard the uproar around this week’s development in the PASS board election.  The Nominating Committee (NomCom) published the list of candidates who will be on the ballot for this year’s three open board positions.  Five candidates made the cut; two did not.  The buzz – mostly negative –…


SQL Saturday 28 Baton Rouge and Ask the Experts

The second annual SQL Saturday Baton Rouge event is coming up in less than two weeks!  Have you registered? I’m honored to be speaking at this event again this year.  I’ll be presenting an introductory SSIS class (one of the 7:30 early bird sessions).  Later in the morning I’ll be delivering a talk on expressions and configurations in SSIS, one…


What Are You Afraid to Ask?

There are some questions that can’t necessarily be answered in a book or a training video. Those are often the questions revolving around “why?” rather than “how?”. A prime example from my own experience is my lack of understanding of the criticality of transaction isolation levels. As a very green SQL Server professional (and in this case, I define professional…