Browse by Tags

There are a whole bunch of SSIS sessions at the PASS Summit this year – I’m glad to see our product continues to be one of the most popular SQL topics around! Pre-Conference SSIS Design Patterns (BIA-299-P) - Andy Leonard , Jessica Moss , Matt Masson , Michelle Ufford , Tim Mitchell   Full day of...

Hello everyone! The PASS Summit Call for Speakers is open until May 13th, and we’re looking for ideas. What SSIS topics would you like to see presented by the SSIS team this year? Here are some ideas that we’ve been tossing around…. SSIS performance Using SSIS with Azure/SQL Azure CDC in 2012 Upcoming...

Three slide decks from the SSIS presentations I did at SQL Bits X in London have been posted online. These include: SSIS Performance Design Patterns – full day training session! What’s New in SSIS for SQL Server 2012 – breakdown of the new features and functionality in SQL Server 2012 SSIS Catalog –...

Quick post – just wanted to mention the full day SSIS Design Patterns talks I’ll be doing at SQL Saturday #105 and SQL Bits X. Details are available here: SQL Saturday #105 Pre-Con SQL Bits X – Training Day For a sample of the Performance Design Patterns I’ll...

The PASS Summit Schedule Builder is live, and I’ve spent the morning looking over all of the great sessions they have lined up. I always find putting together a schedule challenging – it’s hard to balance my time between the sessions that I want to attend, the sessions I should attend for career growth...

I’ll be presenting SSIS topics for two Canadian user groups next month - the Communauté .NET Montréal on September 7th, and the OttawaSQL.NET group on September 15th. Both sessions have the same abstract, but will have different content as I will be giving the audience a sneak peak of the SSIS Performance...

The (preliminary) SQLBits 9 conference agenda has been posted ! I’ll be presenting an SSIS session entitled “What’s New in SQL Server Denali” which covers most of what we showed at TechEd , as well as some of the integration with the other EIM products in Denali, Data Quality Services and Master Data...

I’m really excited to be presenting at SQLBits 9 in September! The conference will be full of great SSIS content, and I wanted to call out the training opportunity available at the pre conference (on September 29th). There will be two full day training seminars related to SSIS – one for beginners , and...

I’m really looking forward to attending the PASS Summit again this year! Last year we presented the SSIS changes in the first public Denali CTP . It was great to finally be able to show off some of the major features the SSIS team had been working on since the 2008 release. This year we’ll be showing...

Elad Ziklik presented a great Data Quality Services session at TechEd last week, and it is now available online . The session covers the new DQS product that will appear in the next Denali CTP. He describes how to create a knowledge base and build up domain rules so that you can perform your own data...

I presented a “What’s New in Microsoft SQL Server Code-Named Denali for SQL Server Integration Services” talk at TechEd last week, which is now available online . It will show you a sneak peak of what we’ll be delivering in the next CTP of Denali . The first half of the presentation covers designer improvements...

I recently moved back to Montreal (my home city), and was excited to find out about the SQLTeach conference happening at the end of May. From the site: SQLTeach is back in Montreal… The last time we held the SQLTeach event in Montreal it was in 2008. This year we have 3 tracks (SQL Server DBA, SQL Server...

I’ve been invited to present about SSIS at the Ottawa IT Camp on April 16th, 2011. I’ll be presenting a 250 level version of my SSIS Design Patterns talk. I’m also looking forward to meeting Christian Cote and Jean-Rene Roy, who will also be presenting SSIS topics during the event. SSIS What’s new in...

I’m happy to once again have the chance to talk about SSIS at Tech Ed North America. I’ll be presenting two sessions this time around – a Denali focused break-out session, and an interactive session about how to scale out SSIS, which I’ll be co-presenting with Joe Quint. ...

I’m really excited to get to present at another SQL Saturday event -- this time in Boston! I really enjoyed the events in Redmond , and I’m looking forward to presenting two sessions this time around. In the morning I’ll be co-presenting SSIS – The New Stuff with Andy Leonard . We’ll take a look at some...

There is a Session Preference survey up on the Tech Ed North America 2011 site . This is a great way to provide input to the session selection committee. If you plan on attending Tech Ed NA, be sure to fill it out before the survey closes (February 17th).

Will you be attending PASS this year? I’ll definitely be there, along with most of the SSIS team! I’ll be presenting a talk about the next version of SSIS , and representing SSIS in the BI Power Hour . Be sure to swing by the product pavilion and Ask the Experts area as well – it’s a great chance to...

Brian Knight's Performance Tuning SSIS talk from Tech Ed 2010 has been posted online . Performance Tuning Microsoft SQL Server Integration Services In this demo-rich presentation, learn some of the common and not so common ways to tune SQL Server Integration Services (SSIS). Learn how to tune the...

The Performance Design Patterns talk I did at Tech Ed 2010 has been posted online . This is pretty much the same talk I gave at SQL Saturday #43 , so if you had attended and were looking for the slides, you can find them on the MS TechEd site. Enjoy! Microsoft SQL Server Integration Services Performance...

The Pacific Northwest SQL Server Users Group has invited me to come speak to them about SSIS next week (Wednesday, May 12th). I’ll be presenting a preview version of my Performance Design Patterns talk that I put together for the MS BI Conference in June . If you’re interested in attending, please check...

I’m really looking forward to presenting at Tech·Ed again this year! As you probably already know, the Microsoft BI Conference is happening at the same time / place, which means the conference will have even more BI content than it usually does. I’m currently signed up to present a break out session...

I’m really looking forward to attending PASS next week! I’ll be presenting two separate talks this time around: Maximize Your SSIS Investment with Tuning Tricks and Tips Session Details Maximize the performance of your packages with this set of best practices and data flow tuning techniques. We'll show...

I’ll be presenting for the Vancouver BI PASS Chapter next Friday, July 10th, at the Microsoft Canada offices. I really enjoyed meeting the Pacific Northwest SQL Server User Group a couple of weeks ago, and I’m looking forward to sharing SSIS with my fellow Canadians in Vancouver. I’ll be going over some...

I’ll be speaking at the Pacific Northwest SQL Server User Group meeting next Wednesday, June 10th. I’ll be giving an updated version of the Avoiding Common Pitfalls in SSIS talk I gave at TechEd a couple of weeks ago. It will be my first time attending a user group meeting, and I’m really looking forward...

I flew to Tucson last week to record my sessions for the upcoming SSWUG.ORG Spring Virtual Conference . I recorded three sessions for the BI track : How to Avoid Common Pitfalls with SSIS Starting up a new project with SQL Server Integration Services? Save time and money by learning about how to avoid...