Welcome

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

 

Announcements

PASS Summit 2014 is just around the corner and SQL PASS Edmonton members can save on registration with our Chapter discount code for $150 off.

Local Chapter Unique Discount Code*

Chapter: SQL PASS Edmonton
Unique Discount Code: CASUMG27

*The Chapter discount code cannot be combined with any other PASS Summit 2014 discount and cannot be applied to an existing registration.

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
Agenda:
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.

When

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

Where

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.

Attachments