(Li-Fang Lee, Wayne Rosario and Soloman Barghouthi) IBM DB2 High Availability Disaster Recovery (HADR), plus the Automatic Client Reroute capability, enables its client applications to recover from a failed database server with minimal interruption. This article shows you the steps for building a hi
Other News
Row Movement in Oracle
(Steve Callan) One of the relatively newer features in Oracle concerns the moving of rows. Why would a row move and who or what controls that movement? Furthermore, by “move,” what exactly does move mean? Does a row move to another table, or is row movement constrained to the row’s container (i.e.,
How do I check duplicate items in a ListView?
(Mike Gold) This shows how to find duplicate items in a ListView control.
Use XForms to create an accounting tool, Part 5: Developing liability management functionality
(Tyler Anderson) This six-part series demonstrates how to leverage the power of XForms in conjunction with MySQL and PHP to create an online accounting tool called X-Trapolate. Every good programming technology possesses a range of problems it excels at solving. The series highlights some of the pro
Index Build strategy in SQL Server – Part 4-1: Offline Serial/Parallel Partitioning (Non-aligned partitioned index build)
Recall that in the previous posts on index build, we defined “aligned” as the case when base object and in-build index use the same partition schema, and “non-aligned” to be the case when heap and index use different partition schemes, or the case when heap is not partitioned. In this post, we will
FIX: Error message when you use the sp_addarticle stored procedure to add articles to an existing transactional replication publication: ‘Cannot create a file when that file already exists’
When you add one or more articles to an existing transactional replication publication by using the sp_addarticle stored procedure in Microsoft SQL Server 2000, transactional replication synchronizations fail. Additionally, you receive the following error message: Cannot create a file when that f
Configuring Forms Authentication in SharePoint 2007
(Damon Armstrong) SharePoint 2007 is the latest release of Microsoft’s enterprise collaboration suite, which tightly integrates with the Microsoft Office Suite and allows organizations to establish well-managed corporate knowledge from the darkest depths of informational chaos. At least that’s Micro
DTrace and MySQL – 1
(Frank Mashraqi) With this post, I am starting another series of blog posts that will help you become familiar of DTrace. You can then apply that knowledge to find all the hidden performance goodies of MySQL on Solaris 10. Sounds good?
Encrypt backups using Oracle 10gR2’s RMAN
(Bob Watkins) A spate of recent news stories has highlighted the importance of protecting database backups. Backup tapes stolen from banks, brokerage houses, retail stores, and even the IRS have exposed data from millions of customers (source: Chronology of Data Breaches).
Oracle 10g upgrade
(Syed Jaffar Hussain) As part of upgrading all our production databases from 8i & 9i to 10g, last Friday, early morning, we had successfully upgraded our core banking business critical database from 9i to 10gR2.