Some upcoming events on XML, SQL Server and databases where I will be speaking
Over the next couple of months, I will be speaking/presenting at a couple of occasions.
MSDN is running a new series of SQL Server 2005 and VS 2005 webcasts. Here are the ones that are interesting from an XML and SQL Server point of view and are being presented by either myself or Shankar. They require registration that can be done by following the links below.
Tuesday, April 5, 2005 3:00 P.M.–4:00 P.M. Pacific Time
MSDN Webcast: Managing XML Data on the Database with SQL Server 2005 and Visual Studio 2005 (Level 300)
I will be presenting information about the XML datatype (not much on XQuery or optimizations though since that will be covered separately), XML Schema Collection, FOR XML PATH mode, how to use XML inside CLR user-defined stored procs (how to use XSLT), and give an update on SQLXML 4.0.
Friday, April 15, 2005 11:00 A.M.–12:00 P.M. Pacific Time
Developing Smart Client Applications Using SQL Server 2005 Native XML Support (Level 200)
Shankar Pal will discuss some of the design considerations for developing applications using XML data type such as the database table design using property promotion, design of XML schemas, writing queries, client-side access using ADO.NET, and XSL transformation using SQL/CLR.
Tuesday, April 26, 2005 10:00 A.M.–11:00 A.M. Pacific Time
Making the Most of XQuery with SQL Server 2005 (Level 300)
I provide an introduction to XQuery and the data modification language as implemented in SQL Server 2005, and show you how to get the most from XQuery. I will provide an introduction to how to optimize XQuery (in preparation to the last presentation) and how to write some common XQuery expressions to get good performance.
Thursday, April 28, 2005 10:00 A.M.–11:00 A.M. Pacific Time
Optimizing and Troubleshooting XML Applications at the Server (Level 300)
Shankar will provide a look at techniques for optimizing applications using the XML data type by first examining the XML index mechanism and then showing how to design and use XML schemas in query optimization, property promotion, and writing efficient path expressions. He will show how to troubleshoot XML applications by analyzing semantic correctness of queries, monitoring performance, and using tools such as Showplan.
I will present a tutorial with presenters from IBM and Oracle and Donald Kossmann as the neutral M.C. on XML and Relational databases which should give an interesting insight into how the “big three” are incorporating XML into their system both at a functional and architectural level. I will put up links to the presentations and papers as soon as they go online.
I will also present at TechEd in Orlando on bringing XML and relational data together (DAT384 Together at Last: Combining XML and Relational Data in SQL Server 2005) both at the academic pre-conference and the general conferernce. Focus will be on how we architecturally combine XML and Relational data and show combining relational and XML data in various ways. If you have any wishes, feel free to let me know... There are also two related Hands-on labs.