THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Allen White

Ten Years with the PASS Summit

I can't begin to tell you how honored I am to have been selected to present at the PASS Summit 2015 in Seattle this year. It's especially noteworthy for me in that this will be the tenth consecutive year I will have presented at the Summit. The Program Committee works hard to put together a slate of sessions that will help all data professionals working with the SQL Server platforms learn more so they can provide greater value to their employers and customers. (I know personally now, as I was a member of two of the subcommittees this year.) The fact that I've been invited to present again is both amazing and humbling.

This year I will be presenting two sessions - Automate Your ETL Infrastructure with SSIS and PowerShell and Scalable Application Design with Service Broker.

The first session is one where I'll walk my audience through the process of automatically generating SSIS packages from a PowerShell script, using BIML as the intermediary step. I'll essentially generate an ETL flow from an OLTP database into a Kimball-style data warehouse. Yes, there are other ways to do it, but I like PowerShell, and works really well.

The second session will demonstrate a number of ways you can use Service Broker's asynchronous messaging technology to offload database work that normally has to be done immediately to a (slightly) later time when the server is less busy. Or you can send some of that work to other servers. The limit here is your imagination, but Service Broker's technology ensures that your messages are always delivered, and, if you configure it properly, always in the order in which they were sent.

Here's a link to the sessions so you can view all the great sessions available at this year's event.

I've attended every PASS Summit since 2003, and could spend hours sharing how this singular event has helped me grow, both technically and in my career. It's well worth it to talk with your company about making your way to Seattle. You'll meet people who've been where you are now in your career, and make friends who will both help you solve problems in ways that'll make you look like a rock star, and who will help you grow your career in ways you might never expect.

Thank you to the PASS Program Committee for this honor, and I look forward to seeing all of you at the 2015 PASS Summit in Seattle!


Published Saturday, June 27, 2015 6:11 PM by AllenMWhite
Filed under: ,



Davide Mauri said:

Great achievement!!!! I'll look for you to go for a beer to celebrate :) :) :) Btw I'll also talk about the Service Broker and how it can help to start to use SQL Server on Azure VMs :)

June 29, 2015 10:24 AM

andyleonard said:

Congratulations, Allen!


June 29, 2015 2:29 PM

AllenMWhite said:

Thanks Davide and Andy! And Davide, I'm happy to talk with you any time about Service Broker - on Azure VMs it works just fine!

June 29, 2015 3:04 PM

Lori said:

I'm not surprised.  You always put on a great, informative session.  Congratulations, Allen

June 29, 2015 5:00 PM
New Comments to this post are disabled

About AllenMWhite

Allen White is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He has worked as a Database Administrator, Architect and Developer for over 30 years, supporting both the Sybase and Microsoft SQL Server platforms over that period.

This Blog


Privacy Statement