Greg Larsen continues his series on date/time data by exploring how to use different SQL Server functions to display dates and times in different formats. Learn how to display a date any way you need it by using the CONVERT function along with one or more additional SQL Server functions.
Author: SSWUG Research
Benchmark Announcement Coincides with SQL Server 2000 (64-Bit) Release
On April 24, Microsoft announced the first single-system TPC-C benchmark result to surpass the 600,000 tpmC mark. SQL Server 2000 Enterprise Edition (64-bit) on a Hewlett-Packard (HP) Superdome server running Windows Server 2003 Datacenter Edition returned a tpmC score of 658,277 at a price/performa
Berkeley DB XML: An Embedded XML Database
by Paul Ford – Berkeley DB XML is an open source, embedded XML database created by Sleepycat Software. It’s built on top of Berkeley DB, a “key-value” database which provides record storage and transaction management. Unlike relational databases, which store data in relational tables, Berkeley DB XM
SOAP Version 1.2 Part 0: Primer
SOAP Version 1.2 Part 0: Primer is a non-normative document intended to provide an easily understandable tutorial on the features of the SOAP Version 1.2 specifications. In particular, it describes the features through various usage scenarios, and is intended to complement the normative text contain
XPath Tutorial
XPath is described in XPath 1.0 standard. In this tutorial selected XPath features are demonstrated on many examples.
Python and DB2 for Linux
Free registration on IBM developerWorks is required for this tutorial on the Python API for IBM DB2. My favorite language and my favorite non-OSS RDBMS. Certainly worth the look.
XML Wrapper Generator
The XML Wrapper Generator is a graphical tool that enables rapid and automatic integration of XML data sources into a DB2 database using the XML Wrapper. This tool loads XML schema files, “shreds” them to a relational schema, and generates appropriate NICKNAME and VIEW statements.
RSS on the Client
by John E. Simpson – I am trying to figure out this RSS thing. If I want to “subscribe” to someone’s XML feed, what do I do? I hit the XML button and get an entire page of code. What do I do with that? I’ll start by spelling out something which you probably (at some level) already know: RSS
Cleanup your schema for SOAP
More and more projects are using XML schemas to define the structure of their data. As your repository of schemas grows, you need tools to manipulate and manage your schemas. The Eclipse XSD Schema Infoset Model has powerful querying and editing capabilities. In this article, Shane Curcuru will show
Corel software gets Smart on XML
By Paul Festa – The struggling Canadian software company released Smart Graphics Studio. First announced in December, the software is part of Corel’s push to boost earnings with tools for use with XML, or Extensible Markup Language, a World Wide Web Consortium (W3C) recommendation for creating indus