At Internet World Fall 2002, Microsoft continues to evangelize XML Web services and its .NET platform as a way to make organizations capable of adapting to trends and capitalizing on opportunities.
Author: SSWUG Research
The O’Reilly Factor: Inside Perl for Oracle DBAs
By Vance McCarthy – Perl can be one of the Oracle DBA’s most powerful tools, thanks to its power as a solution for transforming and gluing data together. That’s the premise of O’Reilly’s latest title, “Perl for Oracle DBAs — Making Life Easier for the Oracle Database Administrators”
How to include Text, nText and Image datatypes in a Union query
As you probably know, in Microsoft database parlance the Text, nText and Image datatypes all hold very large amounts of data. If you’ve ever tried to add these types to a Union query in Visual Basic, the query probably generated errors, claiming that the Text, nText or Image data type can’t be selec
How to Install Only the SQL Server Books Online
This article describes how to manually install SQL Server Books Online if they were not installed when the product was originally installed.
Working with a Metaschema
by Will Provost – If in its entire lifespan W3C XML Schema (WXS) were used merely to validate document after earnest little document, it would have proven its worth. Happily, schemas are useful for much more than validation. XML applications can extrapolate all sorts of functionality from an XML voc
XMLPULL: A Response
by Aleksander Slominski, Stefan Haustein – We are very happy to see that XML pull parsing is gradually gaining more attention. We are also happy to see an article about XmlPull API published on XML.com, as it will expose this approach to a wide audience of Java and XML developers.
Open Digital Rights Language (ODRL) Specification Submitted to W3C
W3C has received ‘Open Digital Rights Language (ODRL) Version 1.1’ from IPR Systems and has published the document as a W3C Note. ODRL is a language for expressing rights information over content; it includes XML schemas for the expression language and data dictionary. The submission request and W3C
Exporting SQL Data as XML
By Darshan Singh – In my last article, Importing XML into SQL Server 2000, we looked at various techniques to import the XML data into SQL Server. To complement that, this article will focus on some of the methods that you can use to export relational SQL data to the XML format.
Find when a stored procedure or function was last altered
By Parthasarathy Mandayam – Find when a SQL Server stored procedure or function was last altered with this script.
SQL Server Database Index Performance Checklist
by Brad M. McGehee – This sixth part of the SQL Server Performance Audit series covers indexes, and how to audit them for best performance.