Service Broker (Intro + Guidance), Indexing (Selection, Usage, Fragmentation etc...), Normalisation, Surrogate Keys - Locking considerations
Network, learn, ask a question, meet other folk, get fed - these are all things that happen at user group events. These events are a really great opportunity to socialise in an informal learning experience - if you want your own exposure then come and do a 1 - 5 minute nugget in front of your peers.
Remember to tell your friends and the people you work with; make sure you register as soon as you can.
5.45pm – 6:15 Registration and networking + Tea/Coffee with biscuits.
Meet and greet.
6:15pm – 6:30pm Round Table discussion and Nuggets - ALL
Take stock and get the latest news in the SQL Server field. This is also a great opportunity to ask any burning questions you have, may be a problem at work.
It's also a great opportunity to share your knowledge and gain exposure in the industry by giving a short 1 - 6 minute "nugget" demo/tip.
Group discussion.
6.30pm – 7:30 Thinking Sets, Normalisation, Surrogate Keys, Referential Integrity
Tony Rogerson http://sqlblogcasts.com/blogs/tonyrogerson, SQL Server MVP
Repeat of my SQL Bits session but I'll drill into areas you want. I can talk around thinking in sets, what are surrogate keys - comparison of NEWID, IDENTITY and NEWSEQUENTIALID, a look at constraints and how they can help the optimiser, locking effects caused by Foreign Keys, affect of READ_COMMITTED_SNAPSHOT on using triggers for RI.
7:30pm – 7:50 BREAK: Light refreshments
More time to network and ask questions...
7:50pm - 8:10pm Group discussion on topics from the evening
Quite often topics spring up but we don't have time to really talk about them, in this session we give the opportunity to drill into various areas of the product - this will be a group discussion with anybody and hopefully contributing :)
7:10pm – 8.55pm Talk-tutorial on Service Broker and Indexing
Neil Hambly, http://sqlblogcasts.com/blogs/neilhambly
o Introduction - What is this Service Broker
o Terminology - key concepts - let's understand the plumbing
o Designing Service Broker applications - Design considerations
o Index Types - What are they, structures
o Chosing "Good" index keys - Column Selectivity & Index order
o Performing Usage analysis using DMVs