IBM’s DB2 V8.1 for Windows provides new levels of information integration. DB2 UDB V8.1 marks the next stage in the evolution of relational database providing for new levels of information integration within your e-infrastructure. DB2 UDB V8.1 allows you to access any information, from any applicati
Other News
An XML Take on Tech·Ed
by Hitesh Seth – Microsoft’s flagship technology conference, commonly known as Tech·Ed, was held in Dallas in early June. Much has been written elsewhere about this event, but I would like to point out a couple of things I thought were quite significant, from an XML perspective.
Replacing the Internet Explorer context menu with a custom built context menu
By Natty Gur – This case study describes how to replace the default context menu shipped with the explorer, with a context menu that allows the programmer to set its pop-up items for each HTML tag, or HTML element with a name attribute and menu items that will always be displayed.
Extending RSS
by Danny Ayers – This article shows how the RDF foundation of RSS 1.0 helps when you want to extend RSS 1.0 for uses outside of strict news item syndication, and how existing RDF vocabularies can be incorporated into RSS 1.0. It concludes by providing a way to reuse these developments in RSS 2.0 fee
Reducing SQL Server Index Fragmentation
By Alexander Chigrik – When you perform any data modification operations (INSERT, UPDATE, or DELETE statements) table fragmentation can occur. When changes are made to the data that affect the index, index fragmentation can occur and the information in the index can get scattered in the database. Fr
HOW TO: Pass a Variable to a Linked Server Query
This article describes how to pass a variable to a linked server query. When you query a linked server, you frequently perform a pass-through query that uses the OPENQUERY, OPENROWSET, or OPENDATASOURCE statement.
NFL, IBM kick off content management deal
By Jason Meserve – IBM and the National Football League Wednesday announced a three-year agreement to develop a content management system for the league based on Big Blue technology and built by its services arm.
Storage Management for SAP and DB2 UDB: Split Mirror Backup/Recovery with IBM’s Enterprise Storage Server (ESS)
This paper provides information on an essential component of advanced infrastructure solutions — the High Availability Split Mirror Backup/Recovery (SMBR) for systems of a mySAP landscape on IBM’s DB2 UDB operating in AIX environment.
DeZign for Databases 3: Database Design Made Easy
Datanamic Solutions B.V. announced DeZign for Databases V3, a significant upgrade to its powerful, easy-to-use database design and modeling product. This new release offers powerful sub-diagram management facilities, a complete new look and feel, many new and enhanced modeling features, a new script
Query to list subdirectories for a given path
This example from Transact-SQL Language Reference Guide will show you how list the subdirectories and their subdirectories for a given path.