{"id":560,"date":"2007-06-05T00:39:03","date_gmt":"2007-06-04T23:39:03","guid":{"rendered":"http:\/\/www.craigmurphy.com\/blog\/?p=560"},"modified":"2007-06-05T00:40:20","modified_gmt":"2007-06-04T23:40:20","slug":"sql-server-2005-xml-and-xml-query-plans","status":"publish","type":"post","link":"http:\/\/www.craigmurphy.com\/blog\/?p=560","title":{"rendered":"SQL Server 2005 – XML and XML Query Plans"},"content":{"rendered":"

What:<\/strong>
\nIn 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.<\/p>\n

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. <\/p>\n

This event is run by Scottish Developers in conjunction with the Scottish SQL Server User Group.<\/p>\n

Where:<\/strong>
\nRoom 15
\nContinuing Professional Development Centre
\nGlasgow Caledonian University
\nCowcaddens Road
\nGlasgow
\nG4 0BA <\/p>\n

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. <\/p>\n

Map of event showing near by transport links<\/a><\/p>\n

When:<\/strong>
\nStart : Wednesday 6 June 2007, 19:00
\nEnd : Wednesday 6 June 2007, 21:00 <\/p>\n

Further information:<\/strong>
\nhttp:\/\/www.scottishdevelopers.com\/modules\/extcal\/event.php?event=33<\/a><\/p>\n

Technorati Tags: SQL Server<\/a>, XML<\/a>, Query Plans<\/a>, Martin Bell<\/a>, BCS<\/a>, British Computer Society<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

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 … Continue reading SQL Server 2005 – XML and XML Query Plans<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,16],"tags":[],"class_list":["post-560","post","type-post","status-publish","format-standard","hentry","category-community","category-developer-events"],"_links":{"self":[{"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/560","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=560"}],"version-history":[{"count":0,"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/560\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=560"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=560"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.craigmurphy.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}