Skip Main Navigation
Page Content
This event has ended

SQLCambs User Group Event #2

SQLCambs User Group

Monday, 21 November 2011 at 18:00 (GMT)

SQLCambs User Group Event #2

Ticket Information

Type Remaining End Quantity
SQLCambs UG event #2   more info 19 Tickets Ended Free  

Share SQLCambs User Group Event #2

Event Details

Arrival

18:00-18:30 Registration, Refreshments and food

 

The Warm Up

18:30-19:00 READPAST & Furious: In defence of being Pessimistic - Mark Broadbent

One of the biggest criticisms about SQL Server used to be that fact that (unlike some of it's rivals) it uses pessimistic concurrency as its default isolation level and so started the dreaded use of the NOLOCK hint. SQL Server 2005 introduced the optimistic concurrency implementation of READCOMMITTED isolation and if that wasn't enough for the critics, a brand new optimistic isolation level was also introduced.

Problem solved?

Well, even to this day, the use of NOLOCK and READUNCOMMITTED is rife, along with a new problem -the over-use of optimistic concurrency isolation to avoid blocking issues.

Perhaps we are looking at this all wrong? ...Lets find out.


Speaker Bio can be found at http://tenbulls.co.uk/about/


19:00-19:15 Break

 

The Main Event

19:15-20:45 TDD – Thwarting Database Defects - Sebastian Meine & Dennis LLoyd

It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them. This presentation introduces tSQLt, a framework for automated database unit testing. You’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain.

 

Speaker Bios can be found at http://sqlity.net/en/about/ and http://www.testdrivendatabases.com/

 

 20:45-21:00 Wrap up and Close

Do you have questions about SQLCambs User Group Event #2? Contact SQLCambs User Group

When & Where


Red Gate Software Ltd.
Newnham House
Cambridge Business Park
CB4 0WZ Cambridge
United Kingdom

Monday, 21 November 2011 at 18:00 (GMT)


  Add to my calendar

Organiser

SQLCambs User Group

The SQLCambs User Group (or Cambridgeshire SQL Server User group if you like long sentences) is a not for profit organisation and offically recognised as a SQL UK User Group and more importantly is an official SQLPASS chapter.

Our aim is to promote, educate and learn about this fantastic Microsoft product and technologies surrounding it (top to bottom) from some of the greatest minds in the business.

Most importantly it is about COMMUNITY and helping one another achieve our goals and aims in our technical and social lives.

We also welcome first time speakers so please get in touch if you are interested!

  Contact the Organiser

Interested in hosting your own event?

Join millions of people on Eventbrite.

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.