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.
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/
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.
20:45-21:00 Wrap up and Close
When & Where
SQLSaturday Cambridge is the UK’s first and largest SQLSaturday. SharePoint Saturday Cambridge is our sister event and both run together as an annual not-for-profit event consisting of very low-cost pre-conference days and culminating in the main event day (Saturday of course!). The conference features leading SQL Server and SharePoint (including related technology) experts from around the world and provides a premier social networking event in the UK.
SPS/SQLSaturday Cambridge pre-conference is on Friday 8th September 2017 and more information can be found on the organiser site http://sqlcambs.org.uk/preconall/.
SharePoint Saturday/SQLSaturday Cambridge Community day is on Saturday 9th September 2017 and registrations can be our SharePoint registration page or through our SQLSaturday registration (to open in Jan '16)
Register now to avoid missing out (or entering a wait list).