(Uche Ogbuji) I have been discussing XML best practices in this column and in other series for years. Others, such as fellow columnist Elliotte Rusty Harold, have covered it as well. The more XML experts that join the discussion of XML design principles, the better, so the community can converge on
Author: SSWUG Research
An interview with Michael Rys
(Douglas Reilly) Dr. Michael Rys is the program manager for the SQL Server Engine Team at Microsoft. Michael also represents Microsoft on the W3C XQuery Working Group and has a seat on the SQL Standardization committee. He is also a co-author of XQuery from the Experts.
Using Secure Shell (ssh) with Database Partitioning Feature (DPF)
(Chris Eaton) If you are using DB2 DPF then you know that the db2start command will start up DB2 on all database partitions (across all servers) automatically. The way it does this internally is that it runs a remote shell on the remote partition and issues the start database manager code. As well,
How to Ensure a Strong Oracle Password
(Lewis R Cunningham) Sophos recently blogged about weak passwords and the hashing mechanism in Oracle. Today I wanted to discuss how easy it is to ensure strong passwords in your database.
DB2 and IMS Database Backup and Recovery Using Today’s Modern Technology – White Paper
A general solution for database backup and recovery depends on many aspects and is different for every mainframe shop. HP can provide an independent analysis of the customers’ situation and forecast a way to improve the current business by using new software and hardware techniques. This white paper
Mixed Reaction to Oracle Fusion from J.D. Edwards Users
(Alex Woodie) Users of the J.D. Edwards ERP systems are offering differing views on how Oracle’s Fusion application and integration strategy will effect their long-term plans. The software giant says its half-way to completing Fusion, a new suite of Java-based ERP applications that are due to be rol
Making Mistakes with XML
(Sean Kelly) Since the first publication of the XML 1.0 Recommendation in 1998, hundreds of applications, data models, document formats, tools, specifications, libraries, references, tutorials, books, papers, excitement, enthusiasm, and energy have exploded onto the scene, making this relatively sim
Writing MySQL Programs Using C (Sample Chapter)
(Paul Dubois) MYSQL provides a client library written in the C programming language that you can use to write client programs that access MySQL databases. This library defines an application programming interface that includes the following facilities: –Connection management routines that establ
Doing HTTP Caching Right: Introducing httplib2
(Joe Gregorio) You need to understand HTTP caching. No, really, you do. I have mentioned repeatedly that you need to choose your HTTP methods carefully when building a web service, in part because you can get the performance benefits of caching with GET. Well, if you want to get the real advantages
FIX: An error message is logged, and new diagnostics do not capture the thread stack when the SQL Server User Mode Scheduler (UMS) experiences a nonyielding thread in SQL Server 2000 Service Pack 4
In Microsoft SQL Server 2000 Service Pack 4 (SP4), new diagnostics do not capture the thread stack when the SQL Server User Mode Scheduler (UMS) experiences a nonyielding thread. Additionally, the thread context variable is not populated with the expected thread stack information. When this problem