(Cynthia M. Saracco) The DB2 Viper release, now in beta, features significant new support for storing, managing, and querying XML data. In this article, you’ll learn the basics of how to write Java applications that access the new XML data. You’ll see how to insert, query, update, and delete XML dat
Other News
Mom and Pop Camping Shop Gets E-Commerce Boost
(Hailey Lynne McKeefry) Nature enthusiasts no longer have to make a major hike to take advantage of the vast array of camping, fishing, rock-climbing and canoeing supplies housed within the walls of outdoor specialty equipment retailer Campmor.
The Father of AJAX Gives Paternal Advice
Jesse James Garrett is the "notorious" father of AJAX. You may not also realize that he’s also a writer, interface developer and designer, information architect, and experience strategist. He co-founded Adaptive Path in 2001, where he is now Director of User Experience Strategy. Garrett is the autho
Log Switch Activity
(Warren Nash) The following tip will calculate both the number of log switches per day and the average per month for the last couple of months.
Working with multiple collation types
(Michelle Gutzait) As a DBA, you may need to work in multi-collation environments. You have different development teams, as well as packaged software from different vendors, and you have to satisfy everyone’s needs regarding collation type. (R)
In-Process Data Access (Sample Chapter)
(Bob Beauchemin and Dan Sullivan) Whether you access data from the client, middle tier, or server, when you’re using SQL Server and the .NET Framework, you use the SqlClient data provider. Your data access code is similar regardless of its location, but the .NET Framework 2.0 version of SqlClient co
A Look at the MySQL CSV Storage Engine
(Robin Schumacher) It’s amazing in an age where relational databases reign supreme when it comes to managing data that so much information still exists outside RDBMS engines in the form of flat files and other such constructs. In most enterprises, data is passed back and forth between disparate
Final Checks and OCFS2 Setup
(Tarry Singh) In part 10, we covered an important topic called security. I think with the world (IT and likewise) gearing up for Utility Computing that virtualization will play greater role in helping utility computing become reality. There is a lot of talk of hosting applications from distant serve
.NET Offers a ‘First Chance’ to Squelch Performance-killing Hidden Exceptions
(Robert Bogue) Processing exceptions in any language is expensive. The process of capturing an exception and rolling it into a package that can be processed by code requires a stack walk—basically looking back through the history of what has happened—and that requires a lot of processing time to com
SQL Server 2000 64-bit eagerly acquires the amount of memory that is specified in the min server memory configuration option
This article describes that Microsoft SQL Server 2000 64-bit eagerly acquires the amount of memory that is specified in the min server memory configuration option, regardless of the memory that it currently needs.