Links from the SSIS Roadmap Session

Here are some of the resources I mentioned in the SSIS Roadmap session at the PASS Summit.

SSIS Reporting Pack from Jamie Thomson

image

 

DQS Matching Transform from OH22 Data

image

 

DQS Domain Value Import Destination from OH22 Data

image

There is also a great series of blog posts (part 1, part 2, part 3) on using these transforms on the DQS team blog.

Data Feed Publishing Components

image

SSIS Content from PASS Summit 2013 on PASS TV

You can now stream sessions from the 2013 PASS Summit on-demand from the PASStv site. There’s a lot of amazing content on there, including the Day 1 and Day 2 keynotes. If you’re interested in SSIS (and if you’re reading this, there is a good chance you are), there are two SSIS focused sessions available:


Skylanders Power View Workbook

I had a lot of requests for the Skylanders BI Application I showed off at the BI Power Hour, so I’ve made it available on skydrive. For those that missed it, the “app” is an Excel workbook which uses Power View (on top of Power Pivot) that I created to help my kids made better decisions as to which toys they should buy.

image

The content in the workbook comes from the Spyro wiki at Wikia and is licensed under the Creative Commons Attribution-Share Alike License.

BI Power Hour at PASS Summit 2013

A big thank you to the PASS Summit 2013 attendees who made our BI Power Hour a great success! I have to admit I was a little worried when we lost all power 15 minutes before the session started (highly ironic that we lost power before the BI Power Hour devoted to Power BI), but I was encouraged when the audience started planning a hostile takeover of Paul Randal’s session room next door. but everything came back up just in time. We packed the ballroom, showed off some great functionality,  and only had one injury from the all of the flying swag. Reading through all of the #BIPH tweets after the session was very entertaining – we really appreciate all of the audience participation. This might have been our best Power Hour yet!

PASS 2013 BI Power Hour Audience #biph

PASS Summit 2013

Wow, has it really been two months since my last blog post? I guess I’ve been busy!

I’ve been hard at work on SSIS and some components for Power BI. I hope to blog about all of the fun projects I’ve been working on this past year, but in case I don’t get a chance, you can come hear me talk all about it at this years PASS Summit!

Yes boys and girls, I’ve once again tricked the conference organizers into letting me present at the Summit. No SSIS pre-cons this year, but I’ll be doing a total of 4 sessions that span SSIS and Power BI topics.

My favorite session – the BI Power Hour – will once again be educating audiences with a set of carefully selected, thought-provoking demos, that will in no way revolve around cats or tapping things. We’re honored to be a Spotlight session this year, and have a killer lineup of presenters. We’re hoping to have enough seats for everyone this year (rather than having people sitting on the floor and in the aisles like last year) – but you might want to get there early just in case.

I’ll be presenting an SSIS Roadmap session, showing off some of the cool new things we’ve been working on.

I’ll also be co-presenting a couple of Power BI sessions – an all up, end to end session (Power BI – This is How We Do It) with many of my co-presenters from the BI Power Hour, and a session which takes a deeper look at the components which allow corporate data source access from SharePoint Online (Power BI and the Data Management Gateway).

I’m really looking forward to another great Summit – hope to see you in Charlotte!

Presentations Galore!

I’m mentally preparing myself for a whole slew of upcoming conferences / speaking engagements over the next month and a half. I love talking about SQL Server technologies, and I’m honored that I’ll have so many chances to do it in the next few weeks!

Please come see me at one (or more) of the following events:

My Sessions at the 2012 PASS Summit

TechEd has its appeal, but of all of the conferences I attend, I must admit that I love the PASS Summit most. I look forward to it every year. The event is physically and mentally exhausting, but I always come home feeling refreshed and inspired. I really enjoy meeting people who use the products I work on, hearing about their issues, and trying to help them out as much as I can.

My schedule this year is even more hectic than previous years, with three breakout sessions and a pre-con event. I’m co-presenting each of my sessions with talented Microsoft folks, and have been busy working on putting the finishing touches on my talks to ensure my audience is entertained (they might even learn something, too).

SSIS Design Patterns [BIA-299-P]

This is the SSIS pre-con event that I previously posted about. The day will be split between the five authors of the SSIS Design Patterns book that came out last month.

In this full-day session, the "SSIS Design Patterns" (Apress, 2012) author team – Matt Masson, Tim Mitchell, Jessica M. Moss, Michelle Ufford, and Andy Leonard – will describe and demonstrate patterns for package execution, package logging, loading flat file and XML sources, loading the cloud, dynamic package generation, SSIS Frameworks, data warehouse ETL, and data flow performance.

Data in the Sky: Efficient On-Premise to Cloud Data Transfer [CLD-306-M]

Co-presenting with Wee Hyong Tok, a PM from the SSIS team. If you’ve seen any of my SSIS presentations in the past, you’ve probably seen Wee Hyong’s material before – I love stealing his slides as my own.

Thinking about moving some of your operations to Azure? Have multiple remote sites, and want to use the cloud to centralize and share data between them?? Just like hearing talks about data transfer performance?! Have we got the session for you!
We’ll cover some common user scenarios and describe when and how to use the latest Microsoft data transfer technologies, including SQL Server Integration Services (SSIS), SQL Data Sync (a capability of SQL Database), and more.

Enterprise Information Management: Bringing Together SSIS, DQS, and MDS [BIA-316-M]

Matthew Roche and I will be presenting a follow-up to our TechEd presentation with some new and interesting integration scenarios.

Enterprise Information Management (EIM) – an industry term for managing your data for data integration, quality, and governance – is an important part of the SQL Server 2012 release. This session revolves around a demo that brings together the EIM functionality in SQL Server 2012 and tells the "Credible, Consistent Data" story. You will see how SQL Server Integration Services (SSIS), Data Quality Services (DQS), Master Data Services (MDS), and other Microsoft technologies work together to provide a comprehensive EIM solution.

BI Power Hour [BIA-206-M]

Back by popular demand – I actually had a reviewer give me a bad score in my PASS session last year because we didn’t have a BI Power Hour session! My fault for trying to make the audience laugh by showing them my demos from TechEd… We have a new lineup of speakers for PASS, as well as some old favorites. This one will be great – of all of the presentations I do in a year, this is the one I enjoy most!

The legacy continues. The Microsoft Business Intelligence team is excited to once again present the BI Power Hour. In this entertaining session, we dazzle you with new demonstrations that expose the lighter side of BI while highlighting the flexibility and power of the Microsoft BI Platform. If you’ve never been to a Power Hour session, you don’t know what you’ve been missing. We promise you’ll walk away impressed – and with a smile on your face.

SQL Saturday #146 | Nashua, New Hampshire

sql_sat_nashua

I’ve been invited to speak at SQL Saturday #146 in Nashua in October. I’ll be presenting two talks related to Data Movement:

Efficient On-Premise to Cloud Data Transfer

Thinking about moving some of your operations to Azure? Have multiple remote sites, and want to use the cloud to centralize and share data between them?? Just like hearing talks about data transfer performance?! Have we got the session for you! We’ll cover some common user scenarios, and describe when and how to use the latest Microsoft data transfer technologies, including SQL Server Integration Services (SSIS), SQL Data Sync (a capability of SQL Database), and more.

EIM – Bringing Together SSIS, DQS and MDS

Enterprise Information Management (EIM) is an industry term for managing your data for data integration, quality, and governance. This session revolves around a demo which brings together the EIM functionality in SQL Server, a key part of our Credible, Consistent Data story for the 2012 release. We will show you how SQL Server Integration Services (SSIS), Data Quality Services (DQS), Master Data Services (MDS) and other Microsoft technologies work together to provide a comprehensive EIM solution.

Both are intermediate (200-300) level talks, and will cover multiple technologies. I’ll be using this as a venue to preview of some of the new content I’ll be presenting at the PASS  Summit in November. I’ll most likely end up in SSIS Design Pattern book co-author Andy Leonard’s (Blog | Twitter) two SSIS sessions, as well – I always love to see other people present SSIS topics, and Andy is one of the best SSIS presenters around.

The full schedule is now available on the event site. If you’re at the event, please come by and say hello! I’ll be happy to sign your ebook edition of my two SQL 2012 books.

The timing is perfect, as I’ll be presenting to the New England SQL Server User Group a couple of days before… Hope to see you at both events!

Learn more about SSIS Design Patterns at the 2012 PASS Summit

We managed to bring together the entire author team for the SSIS Design Patterns book to run a pre-conference event at the 2012 PASS Summit. I posted about this when it was first announced, but since our book came out today, I thought it would be a good time to post a reminder.

We’ve been meeting over the last couple of weeks, trying to decide on what content to include in the session. It’s a lot harder than I thought it would be – there is just so much we could talk about. We have all of that content from the book, of course, and there’s always the desire to include brand new material as well. On top of that, we could draw on content from the pre-con that Andy, Tim and I did last year, the Performance Design Patterns talks I put together, Andy’s framework courses, Tim’s upcoming Real World SSIS session (SQL Saturday 163), and the great stuff from Jessica and Michelle’s blogs… You see our dilemma. I have a feeling the eight hour session is going to fly by.

I’ve always felt that having too much content is better than not having enough, and that is definitely the case here. I think the audience will be happy with what we select, though, and we’ll make sure that the topics that didn’t make the cut will be available online (in one form or another).

The event will take place on Monday, November 5th, 2012. If you’d like to join us for the day, you can register here.

Thanks!

 

PASS Summit 2012 – SSIS Pre-Conference Event

Well, I guess Andy, Tim & I did a good job at PASS last year, as we’ve been invited back to present another SSIS pre-conference event at the 2012 PASS Summit. This time we’ll be joined by the co-authors of our SSIS Design Patterns book, Jessica Moss and Michelle Ufford.

 

SSIS Design Patterns
Speaker(s): Andy Leonard, Jessica Moss, Matt Masson, Michelle Ufford, Tim Mitchell
In this full-day session, the “SSIS Design Patterns” (Apress, 2012) author team will describe and demonstrate patterns for package execution, package logging, loading flat file and XML sources, loading the cloud, dynamic package generation, SSIS Frameworks, data warehouse ETL, and data flow performance.

 

We had a great audience and turnout last year (around 120 people if I recall correctly…). This year should be even better…