A SqlServer focused evening event.
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/
A lap around the SSIS Catalog - Jamie Thomson
SQL Server Integration Services (SSIS) 2012 includes a new database referred to as the SSIS Catalog. SSIS developers and administrators are going to spend a lot of time in here and, like any database, you need a good handle on what secrets it holds. In this session I'll take you on a demo-heavy (i.e. no slides) tour of the SSIS Catalog so you can get a handle on the sea-change this is going to bring to SSIS development.