The PASS Business Intelligence and Data Warehousing Virtual Chapter serves to connect BI professionals globally over ongoing webinars.
Next Meeting

Wed, Jul 24 2013 13:00 Pacific Daylight Time


SSIS: Effective Control Flow execution

RSVP: https://attendee.gotowebinar.com/register/1504630336516349696

Effective Control Flow execution with 7 different types of Foreach Loop Enumerator

Controlling execution of tasks in Control Flow tab of SSIS package can be much easier with getting help of Foreach Loop container. Foreach loop container provides ability to loop through items of a list. There are 7 types of enumerators for using in this Foreach loop, which provides wide range of lists to be used in loop structure. For example looping through array of items in a variable, or nodes and elements of an XML data, or looping through excel sheets, looping through SQL Server data objects.... In this session audience will learn about all 7 types of enumerators, and real world scenarios of using them in SSIS packages. One of the main benefits of loop structures are helping in creating dynamic task execution, for example dynamic data flow. In this session, there will be samples of creating dynamic data flows with help of Foreach Loop enumerators.


Reza Rad is an author, trainer, speaker, and consultant. He has been a Microsoft MVP in SQL Server for 4 years, specializing in Microsoft Business Intelligence and data movement. Reza has worked with Microsoft BI technologies more than 10 years. He is an MCP, an MCT, and leader of the New Zealand Business Intelligence Users Group. He has written several books about SQL Server BI and is currently working on others. You can find his technical articles on his blog at http://www.rad.pasfu.com.

 

Web: http://Bi.sqlpass.org | Twitter: @PASSBIVCEmail:  

 

PASS DW/BI VC

January 2015 Upcoming Sessions


Tuesday 27 Jan 2015 11:00 AM PST, 7:00 PM GMT / 28 Jan 2015 8:00 AM NZDT

SSIS Internals and Performance

Speaker: David Peter Hansen

Registration URL: https://attendee.gotowebinar.com/register/2255494534688611842

You have worked with SQL Server Integration Service (SSIS) for a few years, but more often than not, you see performance problems with your packages. Some packages are running slow, while others are taking up more memory and CPU than before. In this session, you will learn the internals of SSIS and why having a deep understanding is important to solve performance problems. You will also learn how the control flow engine and data flow engine work, what the impact on performance buffers have, and how execution trees are related to parallelism.


David Peter Hansen
David Peter Hansen is Microsoft Certified Master (MCM) in SQL Server and works as Consulting Manager for Advectas Denmark. He has worked with database development and administration for 12 years, and has worked with the Microsoft Business Intelligence platform since SQL Server 2000. He is a frequent speaker at conferences and is an active community member.

Check your local timezone here


February 2015 Upcoming Sessions

Monday, February 16, 2015 at 3:00:00 PM CET (UTC+1 hour) / Monday, February 16, 2015 at 9:00:00 AM EST (UTC-5 hours)

BI in the sky (with diamonds)

Speaker: Johan Ludvig

Registration URL: https://attendee.gotowebinar.com/register/620040259754165249

Microsoft is really delivering up on it's "Cloud first" mantra with rapid releases of new functionality to it's PowerBI portifolio, functionality that won't arrive on-premise until next Office release - if ever. So you, or your manager has decided to give PowerBI a go. But the budget for this is a bit tight, and maybe you're not allowed to use the existing server. Azure is ready for you. But what Azure service do you choose, and how do you let PowerBI and Azure play nicely together? That's what this webinar is here to tell you.


Johan Ludvig
Johan Ludvig is a business intelligence consultant who has been working with SQL Server since 2000. He mainly works with T-SQL, reporting and visualization. Johan Ludvig is a certified QlikView developer but is just as happy diving into PowerBI, R and all other sorts of technologies he can get his grubby little hands on.

Check your local timezone here