Nashville SQL Server User Group

Announcements

Meeting Information

Monthly Meetings

Our regular monthly meetings occur on the last Friday of each month from 11:30 AM - 1:00 PM. Lunch is served during the first half hour and the scheduled session begins at noon. We meet at The Microsoft Heartland Office which is located at

The Microsoft Heartland Office
8 City Blvd, Suite 403
Nashville, TN 37209
Phone: (615) 778-2500
Fax: (615) 778-2510      

Next Meeting: Fri, Mar 25 2016

March Meeting: Louis Davidson Let Me Finish..Isolating Write Operations

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: http://goo.gl/forms/6Pq42KFaYw

OLTP databases can be constantly written to and reporting databases are written to at least periodically. In order to ensure consistent results, connections must be isolated from one another while executing, ideally with the lowest possible cost to concurrency.  How this isolation is handled is based on the isolation level, whether the classic lock based or the newer optimistic scheme of the in-memory OLTP engine is used, or even if both engines are enlisted in the same transaction. In this session we will look at examples of how SQL Server isolates reading and writing operations from other writing operations to explore how this may affect your application through error messages and performance hits.

Bio
Louis Davidson has worked in the IT industry for over 15 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 12 years and has written five books on database design. He has a bachelor's degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.

Sponsor

Robert Half


Founded in 1948, Robert Half International (NYSE: RHI) is the world’s first and largest specialized staffing firm. With more than 360 locations worldwide, Robert Half is dedicated to providing you highly skilled professionals whose skills are well-matched to your unique hiring requirements and workplace environment.

Robert Half has built a stellar reputation for high ethical standards, a specialized focus and unparalleled service. As one of the only truly global specialized staffing firms focusing exclusively in professional positions, Robert Half continues to help businesses worldwide find the skills they need, while assisting untold numbers of job seekers in finding meaningful employment.

For more than 15 years, Robert Half has been named to FORTUNE® magazine’s list of “Most Admired Companies.”

When

iCal
UTC : Fri, Mar 25 2016 16:30 - 18:00
Event Time : Fri, Mar 25 2016 11:30 - 13:00 Central Daylight Time
Your Local Time: Fri, Mar 25 2016 16:30 - 18:00

Where

8 City Blvd
Nashville, Tennessee

Direction: None

Attachments

Offers

 

Exclusive Offers for User Group Members

Oreilly Book Discounts

 Thanks to Oreilly for providing us books to give away and providing a discount code for our users. Buy ebooks at 50% off and print books at 40% off: When you purchase a book or ebook on oreilly.com use the UG Program discount code: DSUG

 

Great Microsoft Learning Offers

Microsoft Learning has released a collection of valuable offers for the PASS user group community. Get the Microsoft Learning products that you want for less. Take advantage today of these special offers for home and office users, IT professionals, and developers by visiting: www.microsoft.com/learning/offers

 

Carry all your tech books with you anytime with one-click reference on Microsoft technologies

Microsoft Press has developed a virtual library for IT Professionals, developers and information workers who want to learn about Microsoft products and related technologies. And we want to share it with the Microsoft user group members. To learn more about the E-Reference Library, please click here (http://www.microsoft.com/learning/books/ereference/default.mspx).

 

 

 

sql_micro_sm.gif 

SIOS 

 

 

 

 

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