(Edmond Woychowsky) My manager doesn’t like scrolling through page after page of tabular information when using a browser-based application. And the delay he experiences while waiting for the next page to load provides him the opportunity to exercise his vast knowledge of the more interesting parts
Other News
Scripted Configuration for SQL Server 2000
(Rob Hawthorne) SQL Server is a great RDMS application, but its installation and configuration options leave the seasoned SQL user crying out for more. Upon install, SQL Server 2000’s options are limited in a number of ways. For example, it provides no features for separating the transaction logs fr
Formatting the date with SQL
(Ravinder Bahadur) Here is a simple way to provide a format for date fields in DB2. More complicated formating will need to use the to_char() function available on IBM’s web site.
Enterprise Application Integration using Apache Cocoon 2.1
(Tony Culshaw) Apache Cocoon has typically been categorized as a web publishing framework, but since the release of version 2.1 is has started to look more like an XML application server. A project with a travel company to build a web-based travel agency desktop which integrates several common ba
Seven Ways to Mess Up with XML
(PG Bartlett) A successful XML publishing project inspired this article. The project’s leader, who claims that the financial return gained for his company “made his career” there, achieved success for two reasons: he focused on the right goals and executed the project in the right way. This arti
@@IDENTITY crisis
(Manohar Kamath) If you have worked with SQL Server, you are probably familiar with identity columns. These are equivalent to the “AutoNumber” columns in Access. The main purpose of these columns is to provide a primary key to the table, when a primary key can not be defined using other fields in th
Linux Databases: DB2 vs. Oracle
(Branham Group) This is a report prepared by Branham Group Inc. that compares the two leading commercial database software packages for Linux: Oracle 9i version 9.2 Enterprise and IBM DB2 version 8.1.2 ESE. Comparison is based on cost of ownership, ease-of-use, reliability, and scalability. The resu
SAP, Sybase ally for smaller business
(Mike Ricciuti) Software maker SAP said that it has partnered with Sybase to use the company’s database management software with its business applications. The deal is seen as a blow for Microsoft, which has been the primary database supplier for SAP’s Business One set of applications that are t
Microsoft Hands Over Office 2003 XML Schemas Royalty-Free To Denmark, World
(Paula Rooney) In a move designed to please the European Commission and governments globally, Microsoft announced on Monday that it would make its Office 2003 XML reference schemas available on a royalty-free basis beginning in early December. The decision, which follows Microsoft’s discussions
Getting PDC Content
(Brian Moran) If you didn’t make it to the Microsoft Professional Developers Conference (PDC) this year, then you missed a tremendous amount of information about upcoming Microsoft technologies, including SQL Server’s next release, code-named Yukon. Fortunately, you don’t have to miss all the techni