Registration is at 5.30, evening will commence at 6pm and finish 9pm.
6pm - 6.30pm
Round Table Discussion
Update on what's been going on and is going on in the SQL Server space.
Bring your SQL problems and ask the audience, bounce ideas - anything related to SQL Server.
6.30pm – 7.30pm
Techniques for developing against SQL Server
Tony Rogerson, SQL Server MVP
In this session Tony will talk through issues that directly effect developers when implementing solutions against Microsoft SQL Server; Collations (SQL v Windows, considerations for performance, storage and joining), enhancements to FOR XML in SQL Server 2005 that will benefit you with set based concatenation and string manipulation, Programming (SET v SELECT for value assignment and associated problems, introduction to Sub-Queries, ORDER BY in a VIEW) and finally tackling scalability – a cursory discussion and demonstration on single and concurrent query testing.
Slide and demo scripts: http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/10/17/1216.aspx
7.30 – 7.45pm
Break
7.45pm - 8.30pm
Asynchronous Processing in SQL Server
Simon Sabin, SQL Server MVP
If you want to achieve the best performance for your users you have always been told to reduce the length of your transactions. You DBA is horrified when you want to use xp_cmdshell or the sp_OA sps in a trigger to call an external app. So how do you get all that processing done. If we need to maintain/update external systems transactionally we are faced with a big head ache, consistency or performance.
SQL Server is a large multi threaded application, in this session we will look at how we can get SQL Server to perform asynchronous processing, guaranteed and transactionally. Typical examples are logging of usage statistics, updating external systems and batch processing.
All hopefully will keep your DBA happy.
8.30pm - 9pm
Bring and share a SQL Server tip - open Microphone session
Whistle stop tips and tricks session; anybody gets '1' – 'x' minutes to share a tip centred around SQL Server.