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!