Organiser

Chris Testa-O'Neill SQL Server MVP

my blog | training

SQLBlogCasts

Public Content

Microsoft 2005 KB's

Microsoft 2008 KB's

Evening Meeting on Thu Feb 05, 2009 in Manchester

[**** POSTPONED DUE TO BAD WEATHER ****] Tony Rogerson talks on Bits and Bobs to help the developer and DBA with TSQL; Martin Bell looks at Table Valued Parameters -new to SQL 2008


LiveMeeting Attendee URL This event is not available via LiveMeeting
Cost Free
Organiser UK SQL Server User Group
Address Remarc, 3rd Floor, Westminster House, Minshull Street, off Portland Street, Manchester, M1 3HU
Directions to Event
Tags

This event is now postponed and will be resheduled due to the bad weather - will now be on the 26th Feb 

 

 

New Venue - Manchester SQL Server User Group Begins!

More information to follow.

Agenda

18:00 - 18:30 - Introduction, Networking and Food

18:30 - 19:00 – Round Table problems and answers, SQL nuggets - bring a tip or 1 - 5 minute demo and share with your peers.

19:00 - 19:45 – Bits and Bobs to help the Developer - TSQL, Tony Rogerson, SQL Server MVP

In this session I will look at a number of techniques and features in the product that help Developers and DBA's allike create robust and scalable queries. We will look at how the optimiser can use the schema to help it, parameter sniffing, table valued functions, cte's, table valued variables and a few more [once I've thought about them - please email me tonyrogerson@torver.net if there is anything specific].

 

19:45 - 20:00 – Break

 

20:00 - 21:00 – Table Valued Parameters - Saints or Sinners?, Martin Bell, SQL Server MVP
With the release of SQL Server 2008 and the new Table Valued Parameter feature, should we all be using them or are they the spawn of the devil? Martin will look at what options are available in the different versions of SQL Server and compares the performance and practicalities of using each one.

 

Location:

Remarc,
3rd Floor,
Westminster House,
Minshull Street,
off Portland Street,
Manchester,
M1 3HU

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