UK SQL Server User Group

Thanks to our Partners:

SQLBlogCasts

Public Content

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	Click here to join Meeting
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

Mon, 6 Jul in 3 days CAMBRIDGE Evening Meeting (27 registered) SQL Server User Group Cambridge - SQL Server 2008	Thu, 16 Jul in 13 days MANCHESTER Evening Meeting (19 registered) Analysis Services (Getting Dimensional with Data)(Optimising Analysis Services) and Excel (not a bad Data Mining client at all) with Chris Testa-O'Neill, Steve Wright and Allan Mitchell SQL Server MVP. Evening sponsored by SQL Sentry, Inc
Mon, 20 Jul in 17 days LEEDS Evening Meeting (3 registered) SQL Server User Group Leeds	Thu, 30 Jul in 27 days LIVE MEETING Online (1 registered) TBC: Microsoft on Communities
Thu, 6 Aug in 34 days LONDON Evening Meeting (6 registered) SQL Server Usergroup does the Great British Beer Festival	Mon, 10 Aug in 38 days LIVE MEETING Online (3 registered) An Evening with the Microsoft Learning Team - Understanding SQL Server Certification and Learning Technologies from Microsoft Learning
Thu, 3 Sep in 62 days MANCHESTER Evening Meeting (3 registered) Manchester SQL Server User Group Meeting - Database developer focused event - Andrew Couch	Wed, 9 Sep in 68 days READING Evening Meeting (2 registered) Database Administration/Management/Engine Focused Event - Agenda TBC
Wed, 14 Oct in 103 days READING Evening Meeting (1 registered) Developer Focused Event - Agenda TBC	Wed, 11 Nov in 131 days READING Evening Meeting (3 registered) Business Intelligence/Data Mining Focused - Agenda TBC

Past Events

26 Jun 2009 LIVE MEETING Online (21 registered) Backing up and Restoring Databases - 30 minutes on how to, why to and building an effective Disaster Recovery strategy - Tony Rogerson, SQL Server MVP	25 Jun 2009 LIVE MEETING Online (19 registered) Creating a star schema and OLAP cube - Trevor Dwyer
18 Jun 2009 LONDON Evening Meeting (47 registered) SQL Server Performance Troubleshooting; Replaying Profiler Traces; nugget on %%lockres%%	11 Jun 2009 LIVE MEETING Online (14 registered) SQL Server Basics (Part 2 : An introduction to using the product - "What is SQL Server? The component parts: cache, databases, files, logs."); Tony Rogerson, SQL Server MVP
10 Jun 2009 READING Evening Meeting (43 registered) SQL 2008 R2 and Gemini; From Data Modelling to Information Architecture and Attribute Relationships, Aggregations and using MDX Studio to its best	4 Jun 2009 LIVE MEETING Online (39 registered) Integrating Data Mining into your BI Solution (7.30pm - 8pm); Allan Mitchell SQL Server MVP
3 Jun 2009 LEEDS Evening Meeting (14 registered) SQL Server Performance Troubleshooting Techniques - Sponsored by Quest Software	28 May 2009 LIVE MEETING Online (22 registered) SQL Server Basics (Part 1 : An introduction to using the product - "The SQL Server Toolset"); Tony Rogerson SQL Server MVP
27 May 2009 EDINBURGH Evening Meeting (17 registered) Patterns and Practices with SQL Server and How to Model Hierarchies.	23 May 2009 TAUNTON Full Day Seminar DDD South West
21 May 2009 LONDON Evening Meeting (46 registered) SQL Server in the Cloud - Evening Event	20 May 2009 CAMBRIDGE Evening Meeting (34 registered) Cambridge SQL UG - SSIS and SSRS sponsored by Redgate
13 May 2009 READING Evening Meeting (24 registered) Sessions on Understanding ADO.NET Data Services, Windows 7 features in-depth and the usual SQL Nuggets and Networking	7 May 2009 MANCHESTER Evening Meeting (16 registered) Tony Rogerson (23 years of hints and tips on SQL and using it) and Chris Testa-O'Neill (Monitoring and Controlling Resources in SQL Server)
2 May 2009 GLASGOW Full Day Seminar Developer Day Scotland

Member Chat

To post messages you must be signed on - please register or logon.

Allan Mitchell Tue 6:41AM

I'm from West Yorkshire if that helps ;-)
Seriously though. Mail Tony.

Robert Hodgson Mon 11:14AM

I am looking for an sql developer in the west yorkshire area for a few hours a week.

Tiago Rente Sun 11:05AM

Hi,
Where can I get the recorded session for "SQL 2008 R2 and Gemini; From Data Modelling to Information Architecture and Attribute Relationships, Aggregations and using MDX Studio to its best"?
Thanks.