(Steven Warren) In my last article, we discussed how to configure replication and mirroring of SQL Server data via Double-Take. Once you have properly configured your replication sets, you can configure failover and begin monitoring and testing. In this article, we will discuss how to configure and
Other News
Row to Column Function
(Krishna Kondavadi) The objective of this function is to transpose rows to columns. This RowToCol function is built with invoker-rights AUTHID CURRENT_USER. The function works on tables/views of the user who invokes the function, not on the owner of this function.
Microsoft SQL Server 2000 Index Defragmentation Best Practices
(Mike Ruthruff) As Microsoft SQL Server 2000 maintains indexes to reflect updates to their underlying tables, these indexes can become fragmented. Depending on workload characteristics, this fragmentation can adversely affect workload performance. This white paper provides information to help yo
Preparing for Semantic Web Services
(H. Peter Alesso) The inventor of the World Wide Web, Tim Berners-Lee, is also the originator of the next generation of Web architecture, the Semantic Web. Currently, his World Wide Web consortium (W3C) team works to develop, extend, and standardize the Web’s markup languages and tools.
From One String to Many
(John E. Simpson) This month, I found two questions from two different people on essentially the same subject: Q1: Can I use XSLT to parse a string of characters?
Oracle/PLSQL: Trim Function
The trim function removes all specified characters either from the beginning or the ending of a string. This article explains how to use the function in your scripts.
IBM’s Stinger Pokes Holes in Oracle’s Open-Source and Grid Ambitions
(Lisa Vaas) IBM recently released the beta of “Stinger,” the next version of its DB2 database. With the move, IBM lobbed yet another volley in the battle over which major enterprise vendor will provide the database of choice for the open-source Linux operating system.
Practical data binding: Get your feet wet in the real world
(Brett McLaughlin) Data binding, although commonplace in today’s world of Java technology and XML programming, is still largely misunderstood. This column throws out all the theoretical claptrap and focuses on the concepts you need to get started with data binding. You will understand the difference
IOUG Live! 2004 Wrap-up
(Bill Burke) As the International Oracle Users Group conference, IOUG Live! 2004, in Toronto has come to a close, there’s no question in my mind that the 2004 IOUG Live! Conference Committee once again outdid itself in bringing our users group a first-rate conference experience. In every area–w
DB2 UDB Stinger Enhancements on Linux
(Rav Ahuja, Dan Behman and John Keenleyside) DB2 Stinger is the code name for an upcoming release of IBM DB2 Universal Database (DB2 UDB). DB2 Stinger includes exciting new features to improve application programmer productivity and lower total cost of ownership for our customers so that they can ga