by Jim Czuprynski – The new ANSI format for joins in Oracle 9i may appear alien at first, but they have the potential to become part of a DBA’s arsenal for clarifying SQL and PL/SQL code. This article discusses the new join formats including NATIVE, CROSS, and OUTER and includes examples for review
Other News
Did You Know? — May 2003
By Hervé Deschamps – Toad, Forms, Apps Forms, General DOS, Network DOS, Windows DLL stuff.
IBM DB2 Universal Database Express Edition V8.1
DB2 UDB Express is a full featured, affordable and easy to use database for the deployment of your e-Business solution, available on Windows and Linux platforms. It supports popular integrated development environments, is easy to integrate and administer. It is designed and priced specifically for s
EJB Development with DB2 Information Integrator: Cost/Benefit Analysis
J2EE developers, take note! Our authors show you they simplified their code was when using DB2 Information Integrator to access disparate back end data sources. First in a three-part series.
The Power of Partitioning
By Dwaine R. Snow and Paul C. Zikopoulos – Misconceptions about partitioning in DB2 UDB abound. Experts from the Toronto Lab set the record straight about this useful feature.
Row Count and Memory Utilization
Want to figure out how big your data tables are? SQL Server Magazine’s Brian Moran shows you how to query the system tables for this info without perform COUNT* functions on every table in the database.
Moving entire SQL Server user databases
by Eli Leiba – Here are several procedures that you can use to “move” all of your user databases from one SQL Server to another with ease.
SQL Server DTS Best Practices
By Vyas Kondreddi – Microsoft released Data Transformation Services (DTS) along with SQL Server 7.0. A very powerful, easy to use, graphical tool for importing, exporting and transforming data, which is only available as a costly add-on in other RDBMS products like Oracle. Prior to SQL Server 7.0, a
Conversion of XML Data Types
Describes how the XmlConvert class performs strongly typed conversion of XML data.
Beyond Integration
by Hitesh Seth – Even though interoperability and making systems and enterprises work together have been the main goals of XML and Web services technologies and standards, the quest for a better way to develop applications has led XML in another direction: around consuming XML/Web services to develo