Next Meeting: Wed, Feb 27 2013
EDMPASS Feb 2013 Meeting with John Huang
Event Type: In-Person & Online
Online Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=RMNCD8&role=attend&pw=X%5E2Bxh2wg
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 (GMT-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
DBCC WritePage and Data Recovery
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.
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.