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: Thu, Mar 21 2013

EDMPASS March 2013 Virtual Meeting

Language: English
Event Type: Online
Online Meeting URL: https://focuscorporation.webex.com/focuscorporation/j.php?ED=197903697&UID=0&PW=NZjQ2ZDRkYzg5&RT=MiM0

Columnstore Indexes in SQL Server 2012: Flipping the DW /faster bit


UTC : Fri, Mar 22 2013 00:30 - 01:30
Event Time : Thu, Mar 21 2013 18:30 - 19:30 Mountain Daylight Time
Your Local Time: Fri, Mar 22 2013 00:30 - 01:30



Direction: To join the online meeting (Now from mobile devices!)
1. Go to https://focuscorporation.webex.com/focuscorporation/j.php?ED=197903697&UID=0&PW=NZjQ2ZDRkYzg5&RT=MiM0
2. If requested, enter your name and email address.
3. If a password is required, enter the meeting password: sqlsaturday
4. Click "Join".

Featured Presentation

Columnstore Indexes in SQL Server 2012: Flipping the DW /faster bit

Speaker: Jimmy May, Principal Architect SanDisk

Summary: Columnstore indexes leverage SQL Server xVelocity technologies & is a wholly new architecture optimized for data warehouse workloads. Transparent to the app, columnstore has been shown to render queries at subsecond response times which heretofore took many minutes or longer. This presentation includes an overview of SQL Server 2012 columnstore indexes, including columnstore futures, review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites & inside MSIT. Learn whether columnstore can change your users' world & why columnstore may be a compelling reason to upgrade to SQL Server 2012. Learn why columnstore manifests my motto, “Change the world or go home!”

About Jimmy: Jimmy May is the World-Wide SQL Server Solutions Architect for Fusion-io, a division of SanDisk. He's formerly a Principal Architect in Microsoft IT as well as Senior Program Manager for the SQL Server Customer Advisory Team (SQL CAT) where he managed the Customer Lab which hosts the biggest, fastest, & most interesting SQL Server apps from all over the world. He is a founder of the IndyPASS & IWUG user groups.