Mark Wilson I am the creator of TopXML. I am available for international and local (Australia) contracts. I am a Solution Architect/Business Analyst. I have worked in IT in several countries (NZ, Australia, South Africa, UK) building and training teams for government and very large non-governmental organizations. I am ex-Microsoft Consulting Services. I wrote the first book on Microsoft XML published in 2000 called XML Programming with VB and ASP. Most recently I have been building tools for the SEO industry. Ask me for a 37 point SEO health-checkup for your website.
First posted :
10/19/2003
Times viewed :
14073
SQL Server XML Introduction
In the SQL Server XML Zone you will learn about SQL, ADO and XML; and how to make
use of it in your applications.
Play the SQL XML beginners game
Learn by playing the Understanding
SQLXML game. Read about XSL and then answer the questions. See if you can get a 100% score and if not, play it again.
Where's the tutorial?
In the left hand menu are the tutorial pages.
Below are various articles on SQL Server XML.
Articles
SQLXML in .NET We will explore how we can retrieve XML directly from SQL Server, insert data into SQL Server from XML documents, the SQLXML web release, various .NET managed classes, plus (all from a .NET perspective with code) FOR XML, RAW, Updagrams, OPENXML and more!
Building Oracle XML Applications: Transforming XML with XSLT We have seen three primary ways to use the Oracle XSLT processor. We've used the oraxsl command-line utility, the XSLT processor's programmatic API, and the instruction to associate a stylesheet with an XSQL page. In this chapter, we begin exploring the full power of the XSLT language to understand how best to use it in our applications.
SQL Server and XML Introduction From SQL Server 2000 onwards, a lot more support and functionality for XML was included in the product. Some of this functionality includes accessing SQL Server using HTTP and new OLAP services (now called Analysis Services). But the majority of the new functionality focuses on supporting XML. This new functionality includes the ability to read and write XML data, support for XDR schemas, and XPath. This tutorial will show you the different methods of retrieving XML from SQL Server, how to control how the data is returned, and then discuss how to navigate through the returned results. You will also learn ways of viewing SQL Server tables from an XML perspective. From there you will learn how to load data into SQL Server using XML natively, including real-time over HTTP. Most of the topics covered today are straight out of the box functionality. However, a couple of things are not. Functionality such as Updategrams and XML Bulk Load require an extra installation.
An exploration of XML in database management systems There is a dichotomy in how XML is used in industry. On one hand there is the document-centric model the other primary usage of XML is in a data-centric model. In both models where XML is used, it is sometimes necessary to store the XML in some sort of repository or database that allows for more sophisticated storage and retrieval of the data especially if the XML is to be accessed by multiple users. This article provides a description of storage options based on what model of XML usage is required.
Interactive Microsoft SQL Server & XML online tutorial This 32 page tutorial will introduce you to using XML with Microsoft SQL Server 2000 - includes UpdateGrams, OpenXML, ADO and more! Includes a test at the end, PDF printable version, 7 worksheets and sample source code for download. Free!
Using VB and ADO to return and update Record Set based XML This article is about making the most of ADO and XML until the complete Visual Basic.net, including ADO.net, becomes available. This article is focused on how you, as a developer, can use ADO and XML today; and get valuable skills that apply to Visual Basic.net. I also want to show how you can use ADO, XML, and XSLT today, to improve the quality of your development.
What's New in SQL Server 2000 Subjects covered will include the new data types, cascading DRI, user defined functions, INSTEAD OF triggers, XML, distributed views, and new and improved tools such as the T-SQL debugger in the Query Analyzer and the Copy Database wizard...
Fundamentals of DTS in SQL Server 2000 Microsoft has added an enormous amount of features to DTS - Data Transformation Services - in its new release of SQL Server 2000...
XML-ify your stored procedures Designing your stored procedures return and accept XML is a really useful thing to do! We'll cover some of the XML SQL Server 2000 features and discuss using them in your stored procedures. Jimmy Nilsson is the owner of the Swedish consultant company JNSK AB
XML and SQL Server 2000 Integration Covering the new XML support added to SQL Server 2000. In particular, you will learn about XML recordsets, URL-based queries, XML views/schemas, and how the addition of XSLT transformations can greatly simplify the delivery of XML data to disparate targets.
Identifying and Eliminating Bottlenecks in an E-commerce System Identifying and addressing bottlenecks in e-commerce systems can be a difficult challenge. In this session we start by walking through the process of identifying the source of a performance bottleneck in an e-commerce system and then discuss various options for addressing bottlenecks caused by the database. In particular, we discuss various design patterns and performance tuning techniques that can tune SQL Server for the unique requirements that e-commerce systems present.
Advanced XML Processing in SQL Server 2000 SQL Server 2000 supports retreival and update using XML as a data format. This session is a follow-up to session 5-324 SQL Server 2000 XML Enhancements and presents more in-depth and advanced topics. Topics will include presentations and demonstrations in the areas of advanced SQL statement construction and updating data in SQL Server 2000.
SQL Server 2000 XML Enhancements The session highlights the SQL Server 2000 XML and HTTP enhancements. Discussions detail how XML can be stored and retrieved from SQL Server programmatically.
Using XML Technologies to Build eBusiness Applications XML technologies are changing the entire architecture of business application development. This session covers Microsoft's XML strategy and current and future products that can be used to address your development challenges. Presenters show a tangible business application that uses MSXML (DOM, Schema, XSLT), SOAP SDK, BizTalk and SQL Server XML features. The goal for this session is to provide you with a clear road map of where and how Microsoft XML technologies can help your development efforts.
COM+ and CORBA Interop with XML-based Web Services While XML based web services like SOAP provide a great protocol for interoperability across the web, they are also a great mechanism for cross platform interoperability in the server to server environment. This presentation demonstrates techniques for exposing an existing CORBA application that integrates with and is accessible from a COM+ application using XML and the Microsoft SOAP SDK. We will look in detail at the requirements of the SOAP listener and how it’s integrated with the SOAP SDK. The sample application will be built using Visual Basic, the SOAP SDK, Java, and C++
