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

 The PASS Business Analytics Conference discount code for our chapter "SQL PASS Edmonton” is:  BA4N3A. Discount amount $150 off 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

Suite 310-10180 101 St NW
Everest Conference Room, Manulife building
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