Organiser

Chris Webb

my blog | hire me

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

Past Events RSS

25 Feb 2010
EDINBURGH
Evening Meeting (19 registered)
25 Feb 2010
CARDIFF
Evening Meeting (16 registered)
20 Jan 2010
DUNDEE
Evening Meeting (7 registered)
17 Dec 2009
MANCHESTER
Evening Meeting (9 registered)
10 Dec 2009
LEEDS
Evening Meeting (9 registered)
26 Nov 2009
EDINBURGH
Evening Meeting (8 registered)
26 Nov 2009
LONDON
Evening Meeting (57 registered)
18 Nov 2009
LONDON
Evening Meeting
11 Nov 2009
READING
Evening Meeting (36 registered)
29 Oct 2009
LONDON
Evening Meeting (42 registered)
28 Oct 2009
DUNDEE
Evening Meeting
15 Oct 2009
MANCHESTER
Evening Meeting (17 registered)
14 Oct 2009
READING
Evening Meeting (33 registered)
8 Oct 2009
CARDIFF
Evening Meeting (18 registered)
8 Oct 2009
EDINBURGH
Evening Meeting (11 registered)

Member Chat

Members online:
To post messages you must be signed on - please register or logon.
tonyrogerson Sat 2:18PM
Feels like I'm writing a book on surrogate keys, Part 1 blogged http://bit.ly/bRbFjX (Rules for surrogate keys, problems they solve) #sqlfaq
Jennifer Stirrup Wed 6:49PM
Is anyone hiring at the moment? Looking for a London-based BI focused role
tonyrogerson Wed 12:46PM
@philcr I'd really like to see Surface with a 2008 R2 demo on it taking full advantage of the kit - that would be cool! #sqlfaq
tonyrogerson Sun 10:14AM
Time for a brew - am reading on the SQL Server Modelling stuff and "M" - don't see where it fits to be honest #sqlfaq