New XMLSPY 5 Simplifies Application Development For Oracle9i XML DB Users
Author: SSWUG Research
Expressing mixed content in RELAX NG versus WXS
Many XML vocabularies use mixed content, and RELAX NG and W3C XML Schema offer varying expression for mixed content. This article compares the two approaches.
Serving Business Graphics from a Web Service
In this previous article, you built a VB.NET chart server that used XML and XPath to serve up business graphics. This article explains how, with the help of a couple extra tools, you can extend the chart server to consume and display results specifically from a Web service.
Web Services Vendors See Need for Improvement
By Caron Carlson – Web services are gaining momentum in the enterprise, but the leading providers agree that the technology needs several improvements, including better security and greater standardization, to reach its potential.
Slammer may not feed on Microsoft alone
By Robert Lemos – Other companies also make products containing the Microsoft database software that has been exploited by the worm. More than 30 products, from security scanners to backup servers, use the vulnerable Microsoft SQL Server 2000 and Microsoft SQL Desktop Edition (MDSE) 2000 software, a
Calculating Working Days Without Using a Function
by Mike Selvaggio – If you need to calculate working days between two dates and you can’t create the Oracle-recommended working days function, here is SQL that can accomplish the same task:
Debug Stored Procedures in VB.NET
by Dianne Siebold – Debugging is an integral part of writing an application. Visual Studio .NET provides numerous enhancements to the debugger, including a unified debugging interface, Web service debugging, and cross-language debugging. One of the debugger’s most useful new features is the ability
Horizontal and Vertical Partitioning in Replication
From SQLTeam – This article was written by Lynn Zhu and Demico Quinn. They write “Before coming up with the solution that this article will describe, we decided that this would be a great topic to write about and share our experiences with others. We also found that there were not a lot of articles
Backup and Restore – Back to Basics with SQL LiteSpeed
One of the most important aspects for a database environment is ensuring reliable backups are being executed and a dependable recovery plan is established in the event of a system failure or data corruption. Several options are available for defining your backup and recovery model and your choices
Databases and Element Names
by John E. Simpson – As you’ve evidently been learning, moving data by hand between XML and relational databases can be frustrating, intellectually stimulating, maybe even rewarding. Mostly, though, it can leave you simply hungry for help.For almost anything involving getting XML data into o