Olympia Area SQL Server User Group

Welcome to the website for the Olympia Area SQL Server User Group (OASSUG) in Thurston County, Washington. Our meetings feature excellent presentations plus the opportunity to network with SQL Server professionals.

 

Next Meeting: Wed, Jan 20 2016

RC, SI, and RCSI, Oh My! –We're off to see the Wizard -to understand how it all works.

Language: English
Event Type: In-Person

When

iCal
Event Time : Wed, Jan 20 2016 14:30 - 16:30 (UTC-08:00) Pacific Time (US & Canada)

Where

7273 Linderson Way SW; Room S117, L&I
Washington State Dept. of Labor & Industries
Tumwater, Washington

Olympia Area SQL Server User Group meeting.

New location: LNI

Featured Presentation

RC, SI, and RCSI, Oh My! –We're off to see the Wizard -to understand how it all works.

Speaker: Arnie Rowland, Consultant/Trainer Westwood Consulting, LLC

Summary: I'm just going to say it straight out. I'm pessimistically optimistic that most really understand transaction concurrency in SQL Server. There is often significant confusion about transaction concurrency and contention options available to Developers -is it 'pessimistic', or 'optimistic', or in between? Everyone ‘sort of’ understands READ COMMITTED (RC). But do you sometimes feel 'dirty' as you attempt to 'repeatedly' read that phantasma? In order to reduce locking and blocking conflicts, some folks adopt SNAPSHOT ISOLATION (SI). And a few hardy stalwarts have ventured into the new world of READ COMMITTED SNAPSHOT ISOLATION (RCSI). In this session, we will explore the differences between the three, including a discussion about the positives and negatives of each option. We will discuss the effects of 'Dirty', 'Repeatable' and 'Phantom' reads, and why you may want to know which may be buried in your code. There will be code examples demonstrating the benefits and traps of each option.

About Arnie: Arnie long ago realized that most issues between Developer and DBA comes from incomplete communication and a misunderstanding of each other's objectives. He is a frequent Trainer and Mentor for Developers and DBAs, bringing both sets of skills to better communicate with teams to create a working solution. For over a decade, Arnie has been a SQL Server MVP, Certified Trainer, technical editor for several publishers, including MOC, and has served as University and Community College adjunct faculty. Clients include Fortune 500 and Multi-Nationals, Federal and State agencies, Foreign governments, and local enterprises –both public and private.

Attachments

Announcements

PASS 2019 Discount Code Discount code for the Olympia Area SQL Server User Group is:

LGDISSQJU

Call for Speakers

Peter Palka is trying to put together a 6 month calendar of speakers and topics. Peter would like to start having two presentations per meeting. One topic could be a short 15 minute presentation and then the other could be a 60-90 minute topic. 

 If you have done something you think is noteworthy that others could benefit from, Peter would like to hear from you. He is willing to help you turn any ideas you have into a presentation. OASSUG is a user group, provided and supported by local area SQL Server users.

  Remember you don’t have to do a full-blown 90 minute presentation; even just a short presentation would be a great way to support our local SQL Server user group.

 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids