What:
In this presentation Martin Bell, will be looking at the different ways to create XML query plans such as T-SQL statements, SQL Profiler and DMVs. He will look at using XML schemas and the schema used for XML Query Plans. Methods of loading XML Query Plans into a database including SSIS, CLR and T-SQL statements will be demonstrated. XML Query Plans with be analysed using XQueries to show how you can monitor and detect performance issues.
Martin Bell has been a freelance computer consultant in the UK for over 23 years. He has worked on many relational database systems and since the 1998 has specialized in SQL Server. He was first awarded Microsoft MVP (SQL Server) status in June 2003.
This event is run by Scottish Developers in conjunction with the Scottish SQL Server User Group.
Where:
Room 15
Continuing Professional Development Centre
Glasgow Caledonian University
Cowcaddens Road
Glasgow
G4 0BA
Room 15 is on Level 2 of the Continuing Professional Development Centre. The CPDC is on the left side (just past the bookshop) as you enter the university from the pedestrian entrance on Cowcaddens Road.
Map of event showing near by transport links
When:
Start : Wednesday 6 June 2007, 19:00
End : Wednesday 6 June 2007, 21:00
Further information:
http://www.scottishdevelopers.com/modules/extcal/event.php?event=33
Technorati Tags: SQL Server, XML, Query Plans, Martin Bell, BCS, British Computer Society