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



Last minute presentation change:

Favourite pre recorded SQL Pass sessions from 2014!


Canadian Conference room

Lower Level

Canadian Western Bank Building

10303 - Jasper Ave,

Edmonton, Alberta

Thrusday Feb 19, 2015

Doors: 5pm

Pizza and main presentation at 6pm.


Grab a free ticket here so we know how much pizza to order!




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.