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

Fri, Feb 22 2013 11:00 (GMT-05:00) Eastern Time (US & Canada)


Hacking the SSIS 2012 Catalog

RSVP: None

SSIS 2012 Catalog

Andy Leonard is CSO of Linchpin People, an SSIS Trainer and Consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, blogger, and engineer. He is a co-author of SQL Server MVP Deep Dives, Volume 2 and SSIS Design Patterns. His background includes VB and web application architecture and development; and SQL Server 2000-2012.


Andy Leonard is a consultant and trainer with Linchpin People, LLC. He is active in the SQL Server community, co-CSO of SQLPeople.net, and co-author of several books on SQL Server and Integration Services.

 

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.

 

 

August 2014 Upcoming Sessions


Friday 15 Aug 2014 11 AM PDT / 2 PM EDT / 7 PM GMT

Continuous Integration for Reporting Services

Speaker: Nat Sundar

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

Developing a Report with Reporting Services is easy. But how can we deliver consistent and bug free Report in a short turnaround. Continuous Integration help us to Build, Unit Test and Deploy the components as we develop. It helps the Developers, DBAs, Test Engineers and the Release Managers. 

Continuous Integration: 

With the help of CI tools , we can build the Report files (.RDL) from Source control (Perforce, SVN, etc). However writing Unit test cases for Reports requires little thoughts. Once the test development has completed, this also need to be build and integrated with the CI tools for automatic runs. 

Also the Reports, Datasets and the Datasources have to be deployed to a Test environment. With the help of CI tools the deployment process can be automated as well. 

In this Demo Rich session, I will walkthrough the best practices around the Development, Build, Unit Test case and Deployment. 

Nat Sundar

Nat Sundar is an independent SQL BI consultant working in the UK. He has considerable years of experience with the UK Financial Services Industry (Mainly in Insurance and Investment Banking). 

He is passionate in SQL Server, SSIS, SSAS, SSRS and MDX. 

Linked-In Profile: http://uk.linkedin.com/pub/nat-sundar/58/a87/842

Timezone

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

Los Angeles - Friday, 15 Aug 2014 at 11:00:00 a.m 
New York - Friday, 15 Aug 2014 at 2:00:00 p.m 
London - Friday, 15 Aug 2014 at 7:00:00 p.m 
Sydney - Saturday, 16 Aug 2014 at 4:00:00 a.m 
Auckland - Saturday, 16 Aug 2014 at 6:00:00 a.m 

 

Wednesday 27 Aug 2014 Noon BST / 9 PM AEST

Intro to R

Speaker: Stephanie Locke

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

R, the statistical programming language, is another open-source program making inroads into the Microsoft world. 

R was originally for doing stats, but it now does database CRUD, reporting, documentation, and even websites. It can be awkward to know where to start, so this session fast tracks you to the sections you need to know about to save yourself pains you didn't even know you had. 

Stephanie Locke 

Stephanie Locke (@SteffLocke) is an experienced Analyst and BI developer within the Finance and Insurance industries. Steph runs her local SQL Server User Group, helps organise SQLRelay, co-author of the book Tribal SQL and contributes to the community at large via blogging, presenting and forums. 

Timezone

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

Seattle - Wednesday, 27 Aug 2014 at 4:00 a.m 
New York - Wednesday, 27 Aug 2014 at 7:00 a.m 
London - Wednesday, 27 Aug 2014 at Noon 
Sydney - Wednesday, 27 Aug at 9:00 p.m 
Auckland - Wednesday, 27 Aug at 11:00 p.m