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

 Distributed Replay: Testing With Your Data, Your Way!

Do you want to test hardware upgrades, index tuning or multi-client applications? Would you like to do this with data specific to your organization?  Distributed Replay, introduced in SQL Server 2012, is a tool that will allow you to accomplish exactly that. In this session, we will cover why you should use it, how to set it up, and what types of data to collect for testing  and replay.  This session will demonstrate tangible methods and undocumented tidbits, that you can take back to your environment to create immediate, and measurable tests.

Bio: 

Melody Zacharias is currently a Business Intelligence Architect and Developer with SolutionsOnly Financial Technologies in Vancouver, British Columbia Canada. She is the leader of the Southern Interior Pass (SIP) chapter for the Professional Association of SQL Server and the regional mentor for Canada.   Melody has been passionate about SQL Server and the SQL community.  You can find her on her blog at: sqlmelody.blogspot.ca or on Twitter @SQLMelody

April 16, 2015

Doors at 5pm

Pizza and Presentation at 6 pm

Please register at Event Brite:

https://www.eventbrite.ca/e/sql-distributed-replay-testing-with-your-data-your-way-edmpass-mtg-apr-16-2015-tickets-16344692415

 

Canaidan Room

Lower Level

Canadian Western Bank | Corporate Office

Suite 3000-10303 Jasper Avenue, Edmonton, AB T5J 3X6

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