This meeting is brought to you by the Dundee University School of Computing and the UK SQL Server User Group
We are in the Queen Mothers Building; any problems my mobile is 0796 816 0362.
For directions on how to get their look at the map of campus found here: http://www.computing.dundee.ac.uk/travel.asp, it's literally a 10 minute walk from Dundee station.
Registration is essential so we know numbers.
18:00 - 18:15 Meet & Greet
Meet up and socialise with your friends, meet new people, find out what other people are doing with SQL Server.
18:15 - 18:30
Round Table Discussion - Q & A from and to the audience
Bring your SQL problems and hopefully somebody within the room will be able to fix or advise you. There is always a wealth of experienced people at the user group meetings.
LiveLock: Always use IDENTITY for your keys
Two sides of the audience, one will argue FOR the statement and one will argue AGAINST.
18:30 - 19:40 Introduction to SQL Server Integration Services 2008
Allan Mitchell, SQL Server MVP
ETL? You've heard the word (or perhaps not); anyway - you want to know what this really powerful feature that comes with the SQL Server product set is.
Allan will show you some of the killer features in SSIS 2008, this will be an interactive session so bring your questions!
19:40 - 20:00 Break for Pizza
More time to network with your peers, meet new friends and get your questions answered.
20:00 - 20:45 SQL Server Tools
Tony Rogerson, SQL Server MVP
You've been tasked with looking after or developing against SQL Server - what next? How can I make sure my SQL is going to work in production and not grind the entire system to a halt?
I will take you through Management Studio and Profiler so you fully understand what is in there and how to use it; when showing query plans I will explain from an entry level how to read them and what some of the access paths and join types mean.