In his latest article, Alexander Chigrik presents a checklist of troubleshooting tips to find potential solutions should you have problems working with Data Transformation Services (DTS) in SQL Server.
Author: SSWUG Research
Novell to Include MySQL in NetWare 6
By Peter Galli – Network software stalwart Novell Inc. is planning to ship a commercial version of the open-source MySQL database, which has been optimized for its NetWare 6 network operating system, by the end of the year.
Using SQL’s EXISTS Predicate to Identify Missing Data
Sometimes knowing that data is missing is just as important as finding data that exists. Use SQL’s EXISTS predicate to select data based on the presence (or absence) of other values.
Oracle Releases TopLink Upgrade, Road Map
Oracle has released an updated version of the TopLink Java development tool it recently acquired from WebGain, along with a road map pledging continued TopLink support for competitors’ databases and application servers.
Beep BEEP!
by Rich Salz – This article is the last in a series examining how one might go about sending binary data as part of a SOAP message. This month we look at BEEP, the Blocks Extensible Exchange Protocol.
HOWTO: Convert FoxPro Cursor into XML Data Format
This article describes how to create an Extensible Markup Language (XML) data file from a cursor in Visual FoxPro 6.0.
Features of Apache SOAP 2.2
By BERTRAND GOUPIL – Apache Soap is an Apache project which defines the SOAP protocol in Java. This project is based on the source of IBM’s SOAP application, SOAP 4J. The latest version of this implementation, dated May 30, 2001, is version 2.2 of the project. Apache SOAP 2.2 defines almost a
Comparing the current and next rows in data warehousing
By Regimon Kallinkal – There is often a need for comparing the current row with the next row for different reasons in data warehousing strategies. Instead of cursoring through an entire table to compare values between current and next records, this technique is faster. Cursors are generally slower f
SQLTools 1.3.5.15 Beta Released
SQLTools is a light-weight, robust tool for ORACLE database development that includes a text editor, SQL console and a couple of SQL utilities. Small enough to fit on a floppy disk and able to be used on a dial-up connection, SQLTools is a handy, portable, free program that works as fast as SQLPlus.
Microsoft steps on three more bugs
By Joe Wilcox – Microsoft issued three security warnings late Wednesday affecting its popular SQL Server database, Windows XP operating system, and Word and Excel applications. The SQL Server flaw, which Microsoft deemed critical, is the most serious of the lot. Exploitation of the flaw would