(Chuck Ballard, Cindy Munns, Mary Schulte, Mark Scranton, Uwe Weber and Nora Sokolof) This IBM Redbook focuses on the considerations and methodology for transitioning from IBM Informix Dynamic Server (IDS) Version 9.4 to IBM DB2 Universal Database Version 8.2. We address the basic topic areas
Other News
Pulling XML forward with the .NET Framework XmlReader object
In the past, there were only two ways to parse an XML file—SAX (Simple API for XML) and DOM (Document Object Model). The first reads an XML file in a sequential manner and signals the application as it finds different XML components like elements and attributes, while the second creates a tree repre
Multiuser XML ‘Database’ Web Service
(John Bailo) I have been fascinated with using XMLDocument in c# applications for the past year. I have used XML for local storage and small applications such as Windows services. I like the way they can be easily searched using XPath queries and the way I can load the whole table into a web browser
Web Services Interfaces
(Enrique Castro and Srilu Uppala) The first Web, the World Wide Web as envisioned by pioneers such as Tim Berners-Lee and Marc Andreessen in the early 1990s, was a human-to-machine (H2M) interface. The technology allowed a human using a special program, a Web browser, to access content posted on the
SQL Server Clustering: 2000 to 2005
(Romanth Nirmal) In this 11,000+ word article, you will learn about the basics of how to cluster SQL Server. To make it easier for you to read, it has been divided into 6 sections.
Eliminating Complexity: Automatic Storage Management
(Kelli Wiseth) Provisioning storage for a single database instance, let alone an entire enterprise, is complex. Typically, the process runs something like this: Come up with a reasonable estimate of the amount of space you’re likely to need over the long term, map out what you hope will be an optima
Implementing Paging with SQL Server
(Itzik Ben-Gan) When you write applications that return query results to the client and display the results on the screen, you need to take into account the end user’s screen-size limitations. If a query’s result set contains too many rows to fit on the screen, you have to introduce logic into t
By Popular Demand
(Bonnie Baker) There are three stories that I am asked to tell again and again. One is the brick laying (or dish washing) tale about my two children, Scott and Beth, who do asynchronous and synchronous I/O, respectively. Another is the story of the large box of balls at the airport that I use to ill
Scheduled MS Cluster Failovers using Automation Server Objects
(Anthony Bressi) If you are working in an Active-Passive clustered SQL Server environment there are often times when you need to initiate a failover so that you can perform routine maintenance tasks on the Passive server – to apply service packs, install software, etc. In this article I outline a qu
MS Rolls Out Second Interim Beta of SQL Server 2005
(Lisa Vaas) Microsoft Corp. released its second Community Technology Preview of SQL Server 2005 and rolled out a new, free tool to manage SQL Server 2000 and MSDE (Microsoft Desktop Engine) 2000.