Organiser

Allan Mitchell, SQL Server MVP

sqldts.com | sqlis.com |  hire me

SQLBlogCasts

Public Content

Microsoft 2005 KB's

Microsoft 2008 KB's

Evening Meeting on Thu Aug 28, 2008 in MILTON KEYNES

SQL 2008 for Developers; What are CTE's? How can I use CTE Recursion?


LiveMeeting Attendee URL This event is not available via LiveMeeting
Cost Free
Organiser UK SQL Server User Group
Address Unisys Ltd, Customer Service Centre, Fox Milne, Milton Keynes, Bucks, MK15 0YS.
Directions to Event
Tags

Milton Keynes UG Meeting

A new venue just off the M1 near Milton Keynes; thanks go to Unisys and Phil Ealey for doing all the leg work to make this happen.

If you live or work near Milton Keynes you would also like to know there is a general IT group on Yahoo (http://tech.groups.yahoo.com/group/itinmk/) that brings together a number of IT disciplines.

6pm – 6:30 Registration and networking + Tea/Coffee with biscuits.

Meet and greet.

6:30pm – 7 Round Table discussion - 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.

7pm – 7:30 Tony Rogerson, SQL Server MVP
Common Table Expressions - What are they? How they work and How to do Recursion

Tony will take us through how Common Table Expressions have been implemented. We will use the Adjaceny List model to demonstrate how recursion works, we will also look at the performance considerations when using CTE's and how to get round it.

7:30pm – 7:50 BREAK: Sandwiches and Drinks

More time to network and ask questions...

7:50pm – 9.15pm Simon Sabin, SQL Server MVP
SQL Server 2008 fly past for Developers

As much of the new features of SQL Server 2008 that we can cover in the time and before the security guards throw us out.

There are some amazing new features in SQL Server 2008 both in the engine and in the tools. Features like, Table Valued parameters, MERGE statement,  debugger, Intellisense, new data types etc etc.
Bring your list of features you want to know about and we will try and make sure we cover them.

Coming Events RSS

Thu, 5 Aug in 7 days
MANCHESTER
Evening Meeting (18 registered)
Wed, 18 Aug in 20 days
MAIDSTONE
Evening Meeting
Wed, 15 Sep in 48 days
LEEDS
Evening Meeting (9 registered)
Thu, 16 Sep in 49 days
MANCHESTER
Evening Meeting (7 registered)
Thu, 23 Sep in 56 days
CARDIFF
Evening Meeting (6 registered)
Thu, 30 Sep in 63 days
YORK
Multi Day Seminar
Thu, 7 Oct in 70 days
EDINBURGH
Evening Meeting (4 registered)
Wed, 27 Oct in 90 days
LEEDS
Evening Meeting (3 registered)
Thu, 28 Oct in 91 days
MANCHESTER
Evening Meeting (7 registered)
Wed, 8 Dec in 132 days
LEEDS
Evening Meeting (3 registered)
Thu, 9 Dec in 133 days
MANCHESTER
Evening Meeting (6 registered)
Wed, 19 Jan in 174 days
LEEDS
Evening Meeting (3 registered)

Past Events RSS

20 Jul 2010
LEEDS
Evening Meeting
14 Jul 2010
LONDON
Evening Meeting (92 registered)
28 Jun 2010
EDINBURGH
Evening Meeting (14 registered)
24 Jun 2010
CARDIFF
Evening Meeting (16 registered)
23 Jun 2010
READING
Evening Meeting (31 registered)
17 Jun 2010
LONDON
Full Day Seminar
27 May 2010
ONLINE
Online
20 May 2010
LONDON
Evening Meeting (30 registered)
19 May 2010
LONDON
Evening Meeting (38 registered)
7 May 2010
ONLINE
Webcast (14 registered)
21 Apr 2010
READING
Evening Meeting (40 registered)
15 Apr 2010
LONDON
Evening Meeting (11 registered)
6 Apr 2010
MANCHESTER
Evening Meeting (8 registered)
30 Mar 2010
MANCHESTER
Evening Meeting (9 registered)
25 Mar 2010
EDINBURGH
Evening Meeting (12 registered)

Member Chat

Members online:
To post messages you must be signed on - please register or logon.
tonyrogerson Wed 1:32PM
Do most developers talk Oddle Poddle? #sqlfaq
glhotz Tue 9:46AM
RT @tonyrogerson: "Rel" (an implementation of Tutorial D), version 1.0.3 beta is now out http://bit.ly/dzlNdA #sqlfaq - a good language for relational theory
tonyrogerson Mon 2:36PM
"Rel" (an implementation of Tutorial D), version 1.0.3 beta is now out http://bit.ly/dzlNdA #sqlfaq - a good language for relational theory
gavinpayneuk Mon 8:09AM
Trying #oracle as a #sqlserver user for the first time, why and how in Part 1 of my new blog series http://bit.ly/a8KVbL #sqlfaq
tonyrogerson Mon 5:31AM
Celko advocating 100's of params http://bit.ly/aYvo2K when passing a "set" of values rather than CSV or TVP - he just doesn't get it #sqlfaq
tonyrogerson Fri 9:51AM
26th-28th July - Live Video of KDD-2010 Conference (data mining) Keynotes http://bit.ly/9PIA9C #sqlfaq