The Professional Association of SQL Server has a Summit every year in Seattle. (One in Europe too.) This year I vowed I would go. Paid for the conference myself and on November 2nd at 8:40 my flight leaves for Seattle,Washington.

Hello Dolly

Here is where you can find me at the SQL PASS Summit.

Yes, I sometimes have three sessions I want to attend in the same hour… decisions decisions…how is that cloning process going?

• 1:37pm flight arrives in Seattle
• 3pm Check in at the Sheraton Seattle and register for the Summit
• ??? Seattle photowalk
• 6:30pm - 8:00pm PASS Summit Unite 2009 Welcome Reception
• 8pm till ?? SQL Server Central party (maybe)

Tuesday:

• 7:45 AM - 8:15 AM Opening Remarks (Wayne Snyder)
• 8:15 AM - 10:00 AM Keynote Speaker Day 1 - Bob Muglia & Ted Kummert
• 10:15 AM - 11:30 AM [BID-201-M] Business Intelligence with Excel 2010 and Project Gemini
• 10:15 AM - 11:30 AM [BIA-140-M] Introducing Master Data Services
• 10:15 AM - 11:30 AM [PD-307] Soft Skills - Now More Than Ever
• 1:30 PM - 2:45 PM [BID-110-M] Introducing Project Gemini
• 3:00 PM - 4:15 PM [DBA-131] The Ultimate Free SQL Server Toolkit
• 3:00 PM - 4:15 PM [BIA-411] SQLBI Methodology
• 4:30 PM - 5:45 PM [PD-108] Social Computing for the Database Professional
• 4:30 PM - 5:45 PM [BIA-206-M] Overview of Business Intelligence capabilities in SQL Server 2008 & R2
• 4:30 PM - 6:00 PM [BIA-329-S] Loading a Data Warehouse with SSIS

Wednesday:

• 7:00 AM - 8:30AM – Quest breakfast thingy (maybe)
• 8:30 AM - 9:00 AM Daily Remarks & Passion Award (Rushabh Mehta)
• 10:15 AM - 11:30 AM [BIA-207-M] An End-to-End Introduction to SQL Server Reporting Services
• 11:30 AM - 1:30 PM - Women In Technology Luncheon
• 1:30 PM - 2:45 PM [BIA-201-M] BI Power Hour
• 1:30 PM - 2:45 PM [AD-312] Database Design
• 3:00 PM - 4:15 PM [BIA-107] The DW/BI System Lifecycle Overview the Kimball Approach
• 3:00 PM - 4:15 PM [BIA-334] Overcoming SSIS Deployment and Configuration Challenges
• 3:00 PM - 4:15 PM [PD-302] Working in Management Will Rot Your Brain - How to Stay Technical and Advance Your Career
• 4:30 PM - 6:00 PM [BIA-335-S] Data Profiling and Cleansing with Integration Services 2008

Thursday:

• 7:00 AM - 8:30AM – VMware Breakfast thingy (maybe)
• 8:30 AM - 9:00 AM [] Daily Remarks (Bill Graziano)
• 9:00 AM - 9:20 AM [] Dell Vendor Keynote
• 9:20 AM - 10:20 AM [] Keynote Speaker Day 3 - David Dewitt
• 10:45 AM - 12:00 PM [PD-106] Team Management Crash Course
• 1:00 PM - 2:15 PM [PD-101] Achieving Work-Life Balance - What does it really mean?
• 1:00 PM - 2:15 PM [AD-307] Yes, I’m Actually Using The Cloud
• 2:30 PM - 3:45 PM [BIA-115] Understanding Master Data Management and the Benefits
• 2:30 PM - 3:45 PM [DBA-327-M] Proactive DBA: Manage SQL Server Better
• 4:00 PM - 5:15 PM [DBA-421] Using Agile Development Techniques with Integration Services

Friday:

• 11:45am Flight leaves for home

Of course I’ll have to find time somewhere to play BINGO!!

4 Comments | In: Uncategorized | | #

The ETL database my friend and I wrote is going to launch into production Tuesday. It’s like our child’s first day of kindergarten.

There are at least 20 jobs that were not required for launch, those will need to be done in the upcoming months. It’s been almost a year since this project began. A giant endeavor which ultimately ends in a new shiny website with better analytics, promotional control, and user experience.

I’ve learned so much, granted there were, and still will be, moments where I will want to pull my hair out. But what an awesome thing to create from the bottom up?!

No Comments | In: Uncategorized | | #

The way I understood it, if you put a value in “set values” within your job step (calling an SSIS Package) it would overwrite what was in the SSIS Configuration table… apparently I was wrong. I tested this today. SSIS Configuration table is the winner.

No Comments | In: Uncategorized | tags: SSIS. | #