EDMPASS is a not-for-profit association that organizes events to promote knowledge sharing, to exchange ideas, and to unite Edmonton's SQL server professionals.

EDMPASS - Professional Association for SQL Server Edmonton Chapter, Edmonton SQL Server User Group



 Distributed Replay: Testing With Your Data, Your Way!

Do you want to test hardware upgrades, index tuning or multi-client applications? Would you like to do this with data specific to your organization?  Distributed Replay, introduced in SQL Server 2012, is a tool that will allow you to accomplish exactly that. In this session, we will cover why you should use it, how to set it up, and what types of data to collect for testing  and replay.  This session will demonstrate tangible methods and undocumented tidbits, that you can take back to your environment to create immediate, and measurable tests.


Melody Zacharias is currently a Business Intelligence Architect and Developer with SolutionsOnly Financial Technologies in Vancouver, British Columbia Canada. She is the leader of the Southern Interior Pass (SIP) chapter for the Professional Association of SQL Server and the regional mentor for Canada.   Melody has been passionate about SQL Server and the SQL community.  You can find her on her blog at: sqlmelody.blogspot.ca or on Twitter @SQLMelody

April 16, 2015

Doors at 5pm

Pizza and Presentation at 6 pm

Please register at Event Brite:



Canaidan Room

Lower Level

Canadian Western Bank | Corporate Office

Suite 3000-10303 Jasper Avenue, Edmonton, AB T5J 3X6

Next Meeting: Tue, Nov 20 2012

EDMPASS November 2012 Meeting w/Patrick Chorley

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: http://www.eventbrite.ca/event/4742538059

OLAP and PerformancePoint: Leveraging the Warehouse


UTC : Wed, Nov 21 2012 00:00 - 02:00
Event Time : Tue, Nov 20 2012 17:00 - 19:00 (UTC-07:00) Mountain Time (US & Canada)
Your Local Time: Wed, Nov 21 2012 00:00 - 02:00


10303 Jasper Avenue
Canadian Western Bank Place - Canadian Room
Edmonton, Alberta
Direction: None

Featured Presentation

OLAP and PerformancePoint: Leveraging the Warehouse

Speaker: Patrick Chorley, BI / Data Consultant Ideaca

Summary: SQL Server Analysis Services and PerformancePoint Services are tools in the Microsoft BI stack used for displaying data. Analysis Services allow analysts to investigate data quickly and dynamically without IT having to write queries. PerformancePoint Services displays high level KPIs to executives to be viewed at a glance. These tools leverage the data warehouse to users who may not have technical expertise. This presentation will describe the process of adding KPIs, setting KPI targets, displaying parallel period KPIs, deploying a cube, creating a PerformancePoint dashboard in a BI SharePoint site, and creating dashboard objects. With these created the foundation will exist to leverage the power of the data warehouse and deliver it to users who need the data the most.

About Patrick : None

PASS Summit First Timer Experience

Speaker: Harry Zheng, Data Architect NetDB Solutions Inc

Summary: PASS Summit First Timer Experience

About Harry: None

PASS Summit Veterans Experience

Speaker: Chris Wood, DBA

Summary: PASS Summit Veterans Experience

About Chris: None