by Kathleen Dollard – Take advantage of the XMLDocument object to combine data files from multiple sources.
Author: SSWUG Research
SAP might be the kink in Oracle’s plan
By Mike Tarsala – Oracle’s hostile bid for rival PeopleSoft is being lauded as brilliant: Oracle wins the game if it can boost sales by buying PeopleSoft outright, and also wins if it doesn’t buy it, by hurting PeopleSoft’s business during takeover wrangling.
A Different Setup
(Itzik Ben-Gan) When your query needs to find items with certain relationships, you can use relational division, or you can try these new tricks. (R,$)
Find duplicate indexes
By Preethiviraj Kulasingham – This script returns duplicate indexes on the current database. It uses two user-defined functions that are compatible with SQL Server 2000 (I used SP3). It won’t work in SQL Server 7.0 because of the user-defined functions and a memory table.
Writing Back Time
Learn how to manage write-back operations in Analysis Services through this example of an employee time-biling application from SQL Server Magazine.
Performance of DB2 Information Integrator in a J2EE Environment
In this last of our three-part series, our authors compare performance results for queries run with federation with those run using direct access.
BMC Buys Maker of IBM DB2 Tools
By Lisa Vaas – BMC Software Inc. has gobbled up yet another company, a small IBM DB2 Universal Database toolmaker, company officials told eWEEK on Wednesday—a move that’s in line with its Project Golden Gate roadmap for providing data management tools that work in a heterogeneous environment.
Indexing text extenders to improve performance
Due to recent accounting scandals in the financial industry, the FCC may implement new regulations that require companies to preserve the content of electronic documents, primarily e-mail, for predetermined time periods. Being able to store and retrieve these documents in a DBMS might be advantageou
SQL Server Security Checklist
Neil Boyle shares a checklist of 24 common security gaps. Don’t let your server fall under any of these lapses. You’ve been warned.
Oracle Debuts Free Hosted Verification Service
Oracle on Friday introduced a free hosted verification service for developers and independent software vendors, who can use the Oracle Portal Verification Service to test the interoperability of their Web-based content and applications.