tRelational and DPS (Data Propagation System) from Treehouse Software, Inc. (TSI) are THE solution for migrating legacy ADABAS data into RDBMS-based Internet/Intranet/ERP/Data Warehouse applications. This product set currently supports Microsoft SQL Server, ORACLE, Sybase, and IBM’s DB2.
Author: SSWUG Research
Watchdog Group Frowns On Oracle’s Bid For PeopleSoft
By Kristen Kenedy – Conservative government watchgroup the National Legal and Policy Center Tuesday urged the U.S. Department of Justice to block Oracle’s $6.3 billion bid to acquire PeopleSoft.
OracleInstall Helps with Trial Software
Have you downloaded Oracle trial software from Oracle Corp.’s Web site? Are you having any problems? Do you have any questions? OracleInstall provides installation assistance and technical information for Oracle’s free trial software. This information is available to you from Oracle’s Web sit
Oracle, Microsoft Warn of Database Flaws
By Lisa Vaas – Both Oracle Corp. and Microsoft Corp. have discovered new vulnerabilities in their databases, the two companies reported.
SQL Server Stored Procedures for Beginners
(Tom O’Neill) Learn the basics of writing SQL Server stored procedures. (R)
How to Create ODBC DSN on multiple SQL server machines
by MAK [Muthusamy Anantha Kumar] – A particularly tedious job for Network Administrators is the creation of ODBC DSN on multiple client machine or server for front-end applications. MAK shares a script for creating ODBC DSN (for SQL server) on multiple machines.
Reducing SQL Server Index Fragmentation
By Alexander Chigrik – When you perform any data modification operations (INSERT, UPDATE, or DELETE statements) table fragmentation can occur. When changes are made to the data that affect the index, index fragmentation can occur and the information in the index can get scattered in the database. Fr
HOW TO: Pass a Variable to a Linked Server Query
This article describes how to pass a variable to a linked server query. When you query a linked server, you frequently perform a pass-through query that uses the OPENQUERY, OPENROWSET, or OPENDATASOURCE statement.
XML DTD
by Jan Egil Refsnes – This chapter covers the XML Document Type Definition. Using a DTD is the formal way to describe a valid XML document.
Use rdf:about and rdf:ID effectively in RDF/XML
Generators are a very powerful new language feature of Python 2.2. In this tip, Uche Ogbuji presents a set of techniques for using generators for fast and lucid XML processing patterns in Python.