(Jimmy Zhang) Despite the wide adoption of the Document Object Model (DOM) and the Simple API for XML (SAX), enterprise developers face the numerous shortcomings of these technologies almost daily. Performance and usability problems aside, DOM and SAX are infamous for their inabilities to efficientl
Author: SSWUG Research
Seven Steps to XML Mastery, Step 5: Making Web Services Work for You (Part 2 of 2)
(Frank Coyle) After you build your web service, you want clients to be able to connect to it and use it. In this step, the author takes us on a tour of how the Web Services Description Language (WSDL) lets you describe a web service, so that any client computer can connect to and use the service. Do
Transfer Ownership
(Chris Eaton) Another of the more subtle enhancements in DB2 9 is the ability to transfer the ownership of objects from one user to another. The creator of any object has control authority over that object for the life of that object. Now in DB2 9 that control privilege (or ownership) can be transfe
Open source applications and the changing face of competition
(Dave Rosenberg and Matt Asay) I remember a few years ago speculating that open source applications would never happen: not a wide enough development community with interest and aptitude in writing that kind of software. (I mention it here.) In short, I had bought into the open source myth that open
DDL Triggers
(Jerry Dixon) A number of years ago, I worked for a company that was developing internal applications with SQL Server 2000. We didn’t have any real database administrators. I was given that responsibility, but I was really a developer, one of many in fact. The problem with this arrangement was that
ADO.NET and SQL Server 2005 (Sample Chapter)
(Alex Homer) ADO.NET AND SQL SERVER, in previous incarnations, generally enjoyed separate design and development routes. But ADO.NET 2.0 and SQL Server 2005 (formerly code-named “Yukon”) share a great deal of functionality and complementary technologies. As these two separate products began to appro
T-SQL HTML Parser
(Brett Kaiser) SQL Server comes with a very powerful XML Parser already OPENXML and sp_xml_preparedocument. I posted a code snipet in the comments I got from BOL so you can see how it works. While my routine operates in a different manner, it seems to have been an exercise in futility…but it was
DB2 9 DBA exam 731 prep, Part 6: High availability: Backup and recovery
(Sylvia Qi and Raul Chong) Learn the basics of database backup and recovery. This tutorial explains the different methods of database recovery and logging, and how to use the BACKUP, RESTORE, ROLLFORWARD, and RECOVER commands. It also covers the new DATABASE REBUILD operation. This is the first of a
Importing XML into MS Access 2003
(Jayaram Krishnaswamy) This article is about importing an XML file into MS Access 2003. XML is the lingua franca of the Internet and is used extensively in how we communicate. There is hardly any area that is untouched by XML. It gets this power because information in most formats can be reduced to
Updating Views
This tutorial teaches you –how to use Views in Queries along with Restrictions on DML operations for Views. –how to update a join View along with rules for updatable join views. –how to use DML Statements on Join Views –how to Update Views that Involve Outer Joins