(Allen) One of the very common questions appearing on various developer forums is that of comparing the pros and cons of MySQL and MS SQL. While comparisons have been made by many volunteers, mostly technical issues, I personally find that they are difficult to compare especially regarding their per
Other News
IBM ‘Stinger’ release pushes .NET, Linux support
(Robert Westervelt) IBM is launching the next version of its DB2 Universal Database, code-named Stinger, touting new autonomic features and .NET developer tools. Stinger will be widely available Sept. 17. (R)
Converting XML to RDF
(Bob DuCharme) Last month we looked at the REST interface to Amazon Web Services (AWS), and how an f parameter in a URL calling this interface can point to an XSLT stylesheet. If you set it to “xml” instead of pointing it at a stylesheet, Amazon returns data in formats that conform to either the “li
Oracle Response Files – Part 1
(Steve Callan) Like the sandworms in Beetlejuice (you know they’re out there, and you hate ’em too), many DBAs avoid Oracle’s response files. The fact of the matter is this: they can be harnessed and used to your advantage. Buried in an installation directory, and not given that much press in in
A Scalability Study for WebSphere Application Server and DB2 Universal Database
(Yongli An, Tsz Kin Tony Lau and Peter Shum) Performance and scalability are essential for your e-business systems. While your business is growing, you need more power on your e-business site to support more customers. This paper documents the technical aspects of a scalability study that demons
Integrating XSL-FO into Web-Based Applications
(Adelene Ng) This article demonstrates how to integrate XSL-FO, XSLT, and JavaMail into existing web-based applications. This article shows how to generate PDF reports for an application through the use of XSLT and XSL-FO embedded within the Java application. Also it illustrates how the generate
Web Services Made Easy
(Rick Dobson) At the formal release of the Microsoft .NET Framework, Bill Gates promoted Web services by demonstrating the SQL Server 2000 Web Services Toolkit, which comes with XML for SQL Server 2000’s third Web release (SQLXML 3.0). The Web Services Toolkit is a jewel, letting you graphically
Data Migration – Quickly Inserting New Data
(Steve Jones) I recently worked on a data migration project for a friend who was moving from one version of a web application to another. It was a home grown application and also required a complete migration from one database to another, in many cases from a denormalized structure to a very normali
SQL Performance Tuning using Indexes
(Scott) Effective indexes are one of the best ways to improve performance in a database application. Without an index, the SQL Server engine is like a reader trying to find a word in a book by examining each page. By using the index in the back of a book, a reader can complete the task in a much
SQL Server tips for working with nested triggers and dump files
(Kaye Garten) Sometimes, triggers can inadvertently fire other triggers or even the same trigger recursively. In this compilation of SQL Server tips, you’ll learn to detect such an event. Then, by changing gears a bit, you’ll see how to read the backup information stored in SQL Server’s msdb dat