(Alex Glauberzon and Martin Wiseman) Think about the last time you had to update a table that contained a large number of columns. Now, imagine that the table is under construction and you’re responsible for adding or deleting columns or modifying columns’ data specifications. And, of course, this s
Other News
Using Different Techniques for SQL Server Automation
(Haidong Ji) In my previous articles (Using xp_cmdshell, Using WMI, Using VBScript, Automate DTS Logging, among others), I talked about various technologies you can use to automate SQL Server management. Different situations call for different techniques. Many times, you may find yourself using a co
HOW TO: Create an Indexer Property in Visual Basic .NET
This article describes how to create an Indexer property in Visual Basic .NET by using the default property attribute.
Work with XML Data Type in SQL Server 2005 from ADO.NET 2.0
(Thiru Thangarathinam) One of the excellent features of the next release of SQL Server, known as SQL Server 2005, is its deep XML integration with the SQL Server database engine. This integration goes well beyond the simple relational-to-XML mapping layer that SQL Server 2000 provided. SQL Server 20
Oracle Asks Court To Flush PeopleSoft’s Poison Pill
(Kelly Shermach) Oracle will appear this week before Judge Leo Shrine, who is known for protecting the rights of outside shareholders. Oracle is asking Shrine to invalidate PeopleSoft’s poison pill, which would enable current shareholders to secure enough stock to block a hostile takeover.
Data Lifecycle Management Series: IBM DB2
This paper examines how to be successful on the IBM DB2 platform through the use of smart data lifecycle management techniques. It also showcases how software tools from Embarcadero Technologies automate and streamline the process of data lifecycle management, with the end result being dramatic savi
Introductory Database Access with PHP
(James Ervin) One of PHP’s strongest features as a scripting language for Web applications is its diverse database support: the “What Can PHP Do?” page lists over 20 database platforms that PHP can communicate with. The PHP-MySQL combination powers numerous high-profile Web sites worldwide. However,
Achieving Flexible Database Clusters with IBM and Oracle9i RAC
Learn the advantages of scalable on-demand clusters with Oracle9i RAC. IBM and PolyServe authors introduce the computing infrastructure known as Flexible Database Clusters and illustrate with a 14-node cluster of IBM eServer® BladeCenter® running Oracle9i RAC and PolyServe cluster software. Atta
Whither XML? Is it for your organization?
(Tony Stewart) This article discusses some of the ways in which XML is uniquely suited to the news and media industry and outlines a few of the choices that you should consider when adopting XML.
Synch mobile apps with DB2 Everyplace and .NET
This is the first tutorial in a series of three covering the development of a mobile service technician sample application for DB2 Everyplace using Visual Studio .NET 2003 and the .NET framework. The first tutorial introduces developers to the DB2 Everyplace Synchronization client API for .NET to im