April 2010 - Posts

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..)

The Slides and Demo's for the SQLBits session I did today at SQL Bits in London can be found here: http://sqlblogcasts.com/blogs/tonyrogerson/UKSSUG/SQLBits20100416NormSetsKeysRI.zip.

Feel free to email me tonyrogerson@torver.net if you have any queries or questions. 

The Agenda was...

  • Thinking in Sets
  • Surrogate Keys
ú  What they areú  Comparison NEWID, NEWSEQUENTIALID, IDENTITYú  Fragmenation
  • Normalisation
ú  An introduction – what is it? Why use it?ú  Joins – Pre-filter problems, index intersectionú  Fragmentation again
  • Referential Integrity
ú  Optimiser -> Query rewriteú  Locking considerations around Foreign Keys and Declarative RI (using Triggers)

 

The UK SQL Server User Group is organising a Social event for SQL and SQL Server professionals, the event will be held after the SQL Server 2008 R2 launch event and is a short walk from that venue.

See site for more information: http://sqlserverfaq.com/events/222/Social-for-SQL-and-SQL-Server-professionals-SQL-quiz-meet-your-peers-ask-the-group-Q-A.aspx

We are putting some light bites on, if you are coming then do let us know through the site.

Neil Hambly who is the London UK SQL Server User Group social organiser (and presenter hey Neil ;)) is organising this; the loose agenda is as follows:

Come and socialise and learn from your peers; these physical meetings are great places to expand your network, get answers and find out how other people are using SQL Server and what is going on. This is the last meeting this year for London and for those who can we should do drinks after the meeting to continue the SQL chat in an even more informal environment.

If you want to twitter please make sure you use the tag #uksqlug so it is shown on the site.

6:30 - 7:15    Meet & Greet (buffet food served) - Drinks available @ bar
7:15 - 8:30    SQL Quiz (or another idea - not sure what else we could do)
8:30 - 8:45    Results, Prizes, bragging rights (Prizes - if we have any Swag)
8:45 - 10:00  General Q&A session with "Gold Medal" {maybe with a spot prize} for best Question/Answer (from group)

 

 

Chris will give a talk on Loading a datawarehouse using SQL Server Integration Services, Tony Rogerson will give a talk on Database Design: Normalisation/Denormalisation and using Surrogate Keys - practicalities/pitfalls and benefits in Microsoft SQL Server. 

Registration is essential which you can do here: http://sqlserverfaq.com?eid=218. 

Come and join us for an evening of SQL Server discussion, as well as the two formal sessions by Chris Testa-O'Neil and Tony Rogerson there will be a chance for other folk to present, we will have some topic discussions - if you have a specific topic to talk around, perhaps a problem at work, something you've always wanted to know then bring it to the meeting.

 

Pizza will be provided.

 

A copy of Windows 7 Ultimate and Brian Larson Business Intelligence book is available to win

 

Registration is essential.


Loading a datawarehouse using SQL Server Integration Services (SSIS)
Chris Testa-O'Neil, SQL Server MVP

http://sqlblogcasts.com/blogs/testas


Exploring tips and tricks that will enable you to understand the techniques that can be used to populate a data warehouse with data.

This session will focus on the data flow and control flow components that can be applied to SQL Server 2005 and SQL Server 2008. Techniques that will be explored include: Using variables to control datawarehouse loads. Managing dimension data with Slowly Changing Dimension. Inserting data into fact tables with the cache and lookup transformations.


Database Design: Normalisation/Denormalisation and using Surrogate Keys
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
 
A talk around Normalisation and Denormalisation, use of Surrogate Keys, Performance and scalability problems caused around joins because of Normalisation; some indexing bits and bobs like index intersection.