I am still tracking through the virtual e-mail mountain following 3 weeks holiday in Sri Lanka and I see the SQL Community have focused their attentions on Manchester. In addition to the upcoming SQL Bits goes Fourth on 28th March (venue tba). Tony Rogerson and Martin Bell are hosting an evening of SQL-ness this Thursday (5th Feb).
You can register here and the full details are:
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 alike 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 firstname.lastname@example.org 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