By Henry Lau – How to take advantage of features in SQL Server 2000 and Excel 2002 in order to distribute enterprise data to Excel 2002 via XML.
Other News
The DocBook Document Type
DocBook is general purpose [XML] and [SGML] document type particularly well suited to books and papers about computer hardware and software (though it is by no means limited to these applications).
Close the Loop Between Web Service Development and Deployment
by Jon Gustafson and Mark Sabiers – Close the productivity-killing loops between development, deployment, and management in your Web services development process. This article presents a framework for analyzing data from the runtime environment and quickly injecting changes into the development life
Windows CE .Net
CE .Net is Windows CE version 4.0, the successor to Windows CE 3.0. Why didn't Microsoft simply name it "CE 4.0"? Because Microsoft marketing wants to make it perfectly clear that everything Microsoft does in 2002 is related in some way to their grand strategy, .Net. How exactly does Win
Oracle9i Real Application Clusters
By Rich Schwerin – Most trade press coverage of Oracle9i Real Application Clusters (RAC) has focused on the dramatic improvements in the “abilities”—scalability, manageability, and availability—offered by the new technology. Another benefit that users are finding, however, is the ease of migration t
Using Microsoft Excel 2002 with SQL Server Analysis Services
By Don Kiely – How to use OLAP features in Microsoft SQL Server Analysis Services from Microsoft Excel 2002.
Use XSLT in .NET
by Dan Wahlin – In a previous article I discussed some of the different roles that XSLT could play in the .NET platform. One of the roles discussed in that article focused on using XSLT for content management or applications that present varying amounts of data to end users. In this article, I'l
XML for Data: XSL style sheets — push or pull?
Columnist Kevin Williams examines the two most common authoring styles used to create XSL style sheets: push and pull. He takes a look at some simple XML and XSL examples and discusses the benefits and drawbacks of each approach.
Revisiting SGML on the web
Four years after the publication of XML 1.0 as a W3C Recommendation, Edd Dumbill opens the XML Europe 2002 conference by questioning whether XML has become the "SGML on the Web" which it was meant to be.
Date-Time Presentation
The technique makes a presentable conversion of the result from substraction between dates. For example, suppose we are looking for how many days, hours, minutes, etc. we spend between two dates, say at the beginning and ending the job/project/compaign. Oracle returns the result in days (such as 2.2