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

Next Meeting: Thu, Jun 27 2013

EDMPASS June 2013 Meeting with John Huang

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: http://edmpass201306.eventbrite.com/

Topic: Locking and Blocking
Speaker: John Huang
Agenda:
5:00 pm - Food and socializing
5:30 pm - Group notice and slides - Harry Zheng
5:45 pm - Feature Presentation - John Huang
8:00 pm - Networking

When

iCal
UTC : Thu, Jun 27 2013 23:00 - 03:00
Event Time : Thu, Jun 27 2013 17:00 - 21:00 Mountain Daylight Time
Your Local Time: Thu, Jun 27 2013 23:00 - 03:00

Where

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

Featured Presentation

Locking and Blocking

Speaker: John Huang, Principle Consultant SQLNotes.info

Summary: Locking and Blocking is one of the most important concepts SQL professionals must know. Understanding it is as important as writing T-SQL and retrieving data from proper indexes. It's powerful that all Transaction Isolation Levels are implemented by locks ONLY (except snapshot related isolation level). With this knowledge, you can explain why your SQL Server behaves like that and also you can tell the preferable locking behavior under different circumstances. Furthermore, It's not the only thing internally used by SQL Server. It's also a tool being exposed to programmers/DBAs since version 7.0 in which it allows you to build your own concurrency controls. John Huang, SQL MCSM Charter, 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.

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.

Attachments