(Brian Moran) Most IT professionals recognize that addressing performance problems during development is faster, easier, and less expensive than waiting until after you roll out your application to production. But development teams that take performance tuning seriously during the early stages of de
Other News
Learn About SQL Server Disaster Recovery from Vas Srinivasan of Sonasoft.com
(Brad M. McGehee) Disaster recovery is an important topic to DBAs. In this interview with Dr. Vas Srinivasan, Vice President of Marketing of Sonasoft.com, makers of SonaSafe for SQL Server, you will learn about the importance of SQL Server backups and disaster recovery.
Pageiolatch Values in Sysprocesses
(Brian Moran) I’m seeing pageiolatch_sh values in the master..sysprocesses table’s lastwaittype column. Many sysprocesses rows that have a pageiolatch lastwaittype also have nonzero values for waittime, so I know that the server process IDs (SPIDs) are waiting. What do the pageiolatch values mean?
DB2 Migration to Version 8
(Marin Komadina) A long line of applying database FixPaks has ended with number 11, the last FixPak V7, and a brand new line has begun with DB2 V8. Currently, a total of six FixPaks have been released for DB2 V8. Consequently, support for DB2 V7 has come to an end. This event triggered many DBAs to
What’s in a Name? The Story Behind Stinger
(Kim Moutsos) Thanks to an innovative roll-out strategy, the “light and nimble” new release of DB2 enjoyed months of buzz before its debut. As the ship date approaches, IBM Canada’s Bob Picciano sheds light on what’s in it for you.
How to implement the database primary key with a surrogate key
(Jason Zhang) How do you use a surrogate key as a primary key? The core of a surrogate key solution is to find an efficient way to generate unique sequential numbers. Learn about three implementations: the traditional way, Key Manager, and new IBM DB2 Universal Database (UDB) features.
Tip: Create an XForms form that submits a second instance
(Nicholas Chase) Because they can easily send and receive XML, XForms forms make great Web services clients, but using them in this way limits your control over the structure of your instance. This tip explains how to manage your data within one instance while submitting a second.
XML on the Web Has Failed
(Mark Pilgrim) XML is predicated on two main strengths. First, publishers can use any character in the world, natively and efficiently, by declaring the character encoding that makes the most sense for their content. English publishers can use an ASCII encoding and store each character in one byte.
Using the JSP 2.0 EL API
(Andrei Cioroianu) The JSP 2.0 Expression Language (EL) is a much-needed feature for Web developers who want to build scriptless JSP pages. It was designed as a part of the JSP Standard Tag Library (JSTL) 1.0, and then JavaServer Pages (JSP) 2.0 adopted and enhanced the EL. In its current form,
Application Server Architecture and BPEL
(Amlan Debnath) In recent years the application server has greatly evolved, expanding the set of core services provided by the infrastructure. The current Java platform supports XML data handling, scalability, load balancing, and other capabilities that allow application-level services to be develop