TechEd 04:DAT405 Extreme SqlXml
Okay, I eaten my hat, so now its time to see the Magnificent One himself talk
to us about SQLXML
- Version 1.0 features
- FOR XML and OpenXML
- Templates, the ISAPI filters and annotated schemas
- ADO/OLEDB provider
- Move over to Annotated XSD schemas instead of XDR
- Updates in 2.0
- Updategrams
- Bulkload
- XSD
- SqlXml managed classes
- Client-Side FOR XML
- Web Service Support
- Current release
- ID propagation support for Bulkload
- NULL support for Web Services
- All of this will be in Yukon, plus more
- Showed the rainbow chart.
- XML Views is the core
- Virtual XML document over a resultset
- Start with XSD with special elements mapping tables (sql:relation)
and columns (sql:field)
- Issue queries (using XPath) to that schema
- Can support deep and reach hierarchy
- Talked about using sql:overflow-field to add non-mapped data
- Demo of query. Talked about is-constant to generate a container
element.
- Remember that IE won't render poorly-formed XML.
- Question was asked if profiler saw the underlying T-SQL, yes.
- Question was asked if the XPath filtered was applied client or
server side. The full XPath is translated into the clause first.
- Advantages: much easier than for FOR XML queries. Multiple database
can be mapped with a view again and again.
- XML views are updatable
- Decouple of shaping from query.
- Use cases
- A very good way to share data with XML as commonality layer
- Talked about XMLBulk Loader.
- Showed using the managed classes to load an annotated schema, adding
an XPath and streamed the results to a file.
- Non managed class for bulkload, but does work via Inter-Op
- Discussion of doing O/R with SqlXml
- Good, basic demo of updategrams
- Good use of XmlTemplates is to wrap stored procedures to generate XML
output.
- Bummer, no discussion of SQLXML4 features.
I'm really impressed with Irwin as a speaker. Friendly, straight-forward with
and did some good demos.