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 26, 2009 in Manchester

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

New Venue - Manchester SQL Server User Group Begins!

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 orare 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.
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
tonyrogerson Fri 8:13PM
@Plip Should have used DAS and disk replication - commodity simple kit always the best approach (usually) #sqlfaq
tonyrogerson Fri 4:52PM
Ashwani Roy and Chris Testa-O'Neill are doing a 30 minute Q&A panel at the 17th March UG even - cool #sqlfaq
tonyrogerson Fri 3:13PM
Posted a blog http://bit.ly/afepEy that describes what Granularity is #sqlfaq
tonyrogerson Fri 12:24PM
7th May 1pm - 1.45pm http://bit.ly/c4UmAP I'm going to do a webcast on Normalisation - vender neutral #sqlfaq
tonyrogerson Fri 12:02PM
Just helped a friend take her first steps in SQL Server #sqlfaq over LiveMeeting; dam "namespace error" on SSRS on the install though :(
tonyrogerson Fri 10:32AM
Thinking about my Denormalisation/RElational Theory talk for SQLBits #sqlfaq; so much to cover - so little time.
mladenprajdic Fri 10:22AM
@tonyrogerson i don't know how useful the #sqlfaq is but there is #sqlhelp that is used and has quite some traffic.
tonyrogerson Fri 10:17AM
Whats the point using DISTINCT (tuples will b unique-I get that), but still keyless - what have you achieved in "relational" terms? #sqlfaq
tonyrogerson Fri 10:09AM
In CJ Date's book SQL and Relational Theory he talks about having DISTINCT on every query - that would be interesting #sqlfaq #infooverload
tonyrogerson Fri 7:39AM
17th March Business Intelligence event is now full - we've over 100 registered now, there is a reserve list in operation #sqlfaq