From SQLTeam – This article comes to us from Bill Twomey. Bill writes “I had to automate a daily extract process. This job had to extract a set of records, and deliver them to a remote system. At first this seemed like an easy task, but the requirements of outgoing transfer, a new filename each day
Author: SSWUG Research
Cracking the Code of Life
By Alan Joch – Sophisticated database and analytical systems bring new efficiencies to life scientists.
A Large Order of PL/SQL Please, Easy on the PL
From both a business and a data perspective, Alan Beaulieu illustrates how SQL alone can handle complex business logic that previously required the combination of PL/SQL. Alan is a coauthor of Mastering Oracle SQL.
Transforming XML Schemas
by Eric Gropp – As an example, this article describes an XSLT document which creates an XHTML form based on the WXS definition of a complex element. For brevity and clarity, the article omits several WXS and XHTML form aspects, including attribute definitions, keys, imported/included schemas, and qu
Generating DOM Magic
by Uche Ogbuji – In this article I present examples and techniques for using generators for XML processing. If you’re not already familiar with Python generators, you should read ” Iterators and simple generators”, by David Mertz. Since this article builds on a previous one of mine, ” Streamlining D
XML & Web Services Support in Crystal Reports 9 – Part I
In this two-part article series, we’ll explore the XML and Web services features available in Crystal Reports 9. The first part will show you how to create a new report from a relational database, by running a stored procedure, then publish the report as a XML Web service, and finally use thi
Migrating Unstructured Data to XML
By Renee Boucher Ferguson – CambridgeDocs, which facilitates XML-based content integration, announced a new tool for migrating unstructured content from legacy sources. The xDoc Converter migrates unstructured data from the likes of Microsoft Word, HTML and Adobe PDF documents into any XML sc
Oracle Ponders Dividend If Taxes Lifted
The board of Oracle Corp. would consider paying a regular dividend if taxes on them were lifted, said Jeffrey Henley, chief financial officer of the database software giant.
Security Technology Protects Microsoft SQL Server
By Mitch Wagner – Protegrity introduced Secure.Data F3 for Microsoft SQL Server 2000, combining security software with cryptographic hardware from nCipher.
The comparison of SQL Server 7.0 with SQL Server 2000
In this article, Sergey Vartanyan shows you the core differences between SQL Server 7.0 and 2000.