(Wangming Ye) Weaving together Web services to create cross-organizational business processes requires all partners to program to the same standard model and to avoid exposing proprietary implementations. After many years of promoting the interoperability among vendors through joint efforts on stand
Other News
Tuning SQL Statements on Microsoft SQL Server 2000
This paper covers the basic techniques used to tune SELECT statements on Microsoft’s SQL Server 2000 relational database management system. (R)
HOWTO set up a MySQL Cluster for two servers (three servers required for true redundancy)
(Alex Davies) This HOWTO was designed for a classic setup of two servers behind a loadbalancer. The aim is to have true redundancy – either server can be unplugged and yet the site will remain up.
FIX: The xp_sendmail extended stored procedure returns incorrect result set column widths when data in one of the result set columns contain DBCS characters in SQL Server 2000
The following issue is fixed in this SQL Server 2000 hotfix package: • In SQL Server 2000, when you send an e-mail message by using the xp_sendmail extended stored procedure, the attached result set column widths are incorrect.
Process/Data Divide Impedes BI
(Jeanette Burriesci) Business intelligence products focus too intently on data; they must open their eyes to business processes, according to research by Forrester principal analyst Keith Gile. Without process orientation, BI supports strategic decisions much better than operational ones.
Comparing CSS and XSL: A Reply from Norm Walsh
(Norman Walsh) In Printing XML: Why CSS Is Better than XSL, Håkon Wium Lie and Michael Day launch an aggressive attack on my assertion that “web browsers suck at printing” and “CSS is never going to fix it.” In retrospect, I regret the way that I expressed that. I suppose the shortest possible r
The 4 Cornerstones of Business Intelligence: Webcast
Get more from Oracle, Siebel or SAP systems with a BI solution that is flexible enough to take full advantage of packaged applications and information systems in your infrastructure while keeping data sources secure and transparent. (R)
Oracle Programs New Windows Support
(Clint Boulton) Oracle has issued a toolkit to help Microsoft programmers use Visual Studio .NET 2003 software to write Oracle Database 10g applications on the Windows operating system.
Kill runaway Oracle processes on Windows
(Scott Stephens) A user’s process will occasionally hang or spin and lock out other sessions. If the DBA still has access to the database, they can usually just issue the following query. (R)
Interface MySQL with C
(Russell J.T. Dyer) The reliability and longevity of the C programming language coupled with the stability of MySQL make them a strong pair for system database management. In last month’s MySQL column, I went over the basics of developing a Perl interface to MySQl. Before that, I covered PHP with My