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

Wed, Dec 10 2014 20:00 (GMT+01:00) Brussels, Copenhagen, Madrid, Paris


SSIS internals and performance

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

SSIS internals and performance

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 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.

 

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

 

 

PASS Summit 2014 Discount Code

The annual PASS Summit is taking place in Seattle, on Nov 4-7, 2014. If you have not registered, you can use PASS DW/BI VC discount code of VCSUM05 to get $150 off registration price. To register, please visit http://www.sqlpass.org/summit/2014/RegisterNow.aspx.

 

 

October 2014 Upcoming Sessions



Wednesday 15 Oct 2014 Noon CEST / 9 PM AEDT / 6 AM EDT

Risk Analysis Dashboard on a shoestring

Speaker: Johan Ludvig Brattås 

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

Visualization is all the rage – with the focus on Self-Service BI, In-Memory technology and fancy graphics. Tableau, QlikView and Microsoft PowerBi are showing off the eye-candy, and managers like what they see. However, either these solutions cost a lot of money, or your organization is stuck on older versions of software that lacks the functionality needed. This session will show you how to make a cool dashboard using a database (MS SQL Server 2008), Excel 2010, and in addition how to prepare your solution for SQL2012 and the full PowerBI-suite with PowerPivot. 



Johan Ludvig Brattås 


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 diiving into PowerView, R and all other sorts of technologies he can get his grubby little hands on.
Read less


Timezone

Check your Timezone by clicking here, or use our handy list below

Los Angeles - Wednesday, 15 Oct 2014 at 3:00 a.m 
New York - Wednesday, 15 Sep 2014 at 6:00 a.m 
London - Wednesday, 15 Sep  2014 at 11:00 a.m 
Sydney - Wednesday, 15 Sep 2014 at 9:00 p.m 
Auckland - Wednesday, 15 Sep 2014 at 11:00 p.m 

 

Wednesday 22 Oct 2014 1 PM BST / 8 AM EDT

A Dive Into Data Quality Services

Speaker: Steve Simon

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

Data quality and data cleansing have always been major challenges to any enterprise that deals with data. For those of us who have dealt with Data Profiler Tasks in SQL Server 2008, we were shocked yet pleasantly surprised with the great advances that Microsoft has made with the advent of Data Quality Services, in the SQL Server 2012 release. In this hands-on presentation we shall be looking at how to set up a new knowledge base, based upon an existing one, set up rules, do knowledge discovery within the new knowledge base and finally cleanse the data through a data quality project. The end results being more effective data, guaranteed to keep end users and management happy. 


Steve Simon 


Steve Simon is a SQL Server MVP and is a senior BI Development Engineer with Atrion Networking Corporation in Providence RI USA. He has been involved with database design and analysis for over 29 years. Steve has presented papers at 8 PASS Summits and one at PASS Europe 2009 and 2010. He has recently presented a Master Data Services presentation at the PASS Amsterdam Rally and is a regular presenter at SQL Saturday’s in the USA and Canada. Steve has presented 5 papers at the Information Builders' Summits. He is a PASS regional mentor.

Timezone

Check your Timezone by clicking here, or use our handy list below

Seattle - Wednesday, 22 Oct 2014 at 5:00 a.m
New York - Wednesday, 22 Oct  2014 at 8:00 a.m
London - Wednesday, 22 Oct 2014 at 1:00 p.m
Sydney - Wednesday, 22 Oct  2014 at 11:00 p.m
Auckland - Thursday, 23 Oct 2014 at 01:00 a.m