This article describes how to change the location of the data and log files for any SQL Server 7.0 or SQL Server 2000 database.
Other News
Using Clobs/Blobs with Oracle and Hibernate
Hibernate 1.2.1 comes with support for Clobs (and Blobs). Just use the clob type in your mapping file and java.sql.Clob in your persistent class.
Process Large Result Sets in Java Web Applications
(Srinivasa Rao Chintala) Many Web applications involve the processing of huge result sets, where you have to display a finite number of results per page for easier viewing across pages. Pagination is the most common way to handle large amounts of data in more manageable chunks — i.e., using PREVIOU
Write Ajax-style Applications Using the ASP.NET 2.0 Client Callback Manager
(Wei-Meng Lee) It seems everybody is talking about Ajax these days. The technology behind Ajax is hardly new, yet some really ‘killer’ new applications of XMLHttpRequest object have emerged recently, and these have breathed new life and excitement into the concept of client-side image refresh.
MS Office XML Formats Not OK with GNU
(Peter Galli) The royalty-free license under which Microsoft plans to make its upcoming new Office Open XML Formats widely available is incompatible with the GNU General Public License and will thus prevent many free and open-source software projects from using the formats, community officials say.
Introduction to XQuery in SQL Server 2005
(Prasadarao K. Vithanala) This white paper provides an introduction to various features of XQuery implemented in SQL Server 2005 such as the FLWOR statement, operators in XQuery, if-then-else construct, XML constructors, built-in XQuery functions, type casting operators, and examples of how to use e
IBM to get aggressive on DB2, co-fund partners for road shows
(N Geetha) Following a spate of acquisitions worldwide that enhance the technological capabilities of its DB2 database management software, IBM in India has aggressive plans to increase its market share.
Testing 1, 2, 3 . . .
(Phil Zoio) It wasn’t too long ago that quality assurance (QA) teams played the leading (if not the only) role when it came to software testing. These days, however, developers are making an enormous contribution to software quality early in the development process, using automated unit-testing tech
Set up and run a Trade6 benchmark with DB2 UDB
(Joyce Coleman and Tony Lau) The WebSphere performance benchmark sample (known as Trade6) provides a suite of workloads for characterizing performance of the WebSphere Application Server. This tutorial describes how to install and set up a Trade6 sandbox with DB2 V8.2 and WebSphere Application Serve
Live Backups of MySQL Using Replication
(Russell Dyer) One of the difficulties with a large and active MySQL database is making clean backups without having to bring the server down. Otherwise, a backup may slow down the system and there may be inconsistency with data, since related tables may be changed while another is being backed up.