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: Wed, Feb 27 2013

EDMPASS Feb 2013 Meeting with John Huang

Language: English
Event Type: In-Person & Online
Online Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=RMNCD8&role=attend&pw=X%5E2Bxh2wg
RSVPURL: http://www.eventbrite.ca/event/5529914122

Topic: DBCC WritePage and Data Recovery
Speaker: John Huang
5:00 pm - Food and socializing
5:30 pm - Group notice and slides - Harry Zheng
6:00 pm - Feature Presentation - John Huang
7:00 pm - Networking
8:00 pm - Wrap up
Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks.
If you haven’t signed up already at edmpass.sqlpass.org please do so now to receive meeting notifications, news and updates from EDMPASS.


UTC : Thu, Feb 28 2013 00:30 - 03:00
Event Time : Wed, Feb 27 2013 17:30 - 20:00 (UTC-07:00) Mountain Time (US & Canada)
Your Local Time: Thu, Feb 28 2013 00:30 - 03:00


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

Featured Presentation

DBCC WritePage and Data Recovery

Speaker: John Huang

Summary: DBCC WritePage is an undocumented command that allows users to modify physical pages directly. It can only be useful for database repairing when there are extreme situations where nothing can help you recover your data. It makes troubles in most of the time. But it's a good tool for learning other stuff. More importantly, you need to know this when others have already known. In this 500 level session, We will explore some internals, use this command or other ways to break the database integrity, and use this tool to recover it. I will also demonstrate you how to keep yourself safe from using this command.

About John: John Huang, SQL MCM and MVP, has been working with SQL Server since 1994. He is an independent SQL Server consultant in Vancouver specialized in complex data processing, data warehouse, and performance tuning. He runs SQL PASS chapter in Victoria BC and spoke at TechDays, DevTeach, TechFest, SQL Saturdays, as well as local PASS Chapters.