19 April 2010 19:54
tonyrogerson
This Wed, Reading - Service Broker, Indexing, Normalisation, Sets, RI and Locking, Surrogate Keys
Registration is a must so we know numbers and for security, register here:
http://sqlserverfaq.com/events/213/Service-Broker-Intro-Guidance-Indexing-Selection-Usage-Fragmentation-etc-Normalisation-Surrogate-Keys-Locking-considerations.aspx
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, 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 Service Broker, Indexing
Neil Hambly
- Part 1 Service Broker (mainly intro & some guidance stuff)
- Part 2 Indexing (Selection, Usage analysis, over/under-indexing impact, Statistics, fragmentation etc..)