(Sean Hull) Oracle is a powerful database for building web-based applications. PHP is famous for being quick and efficient; it can help you build fast applications that are not going to weigh down your database. Pair Oracle up with PHP, and you get a powerhouse combination. PHP (an acronym for P
Other News
DB2 Library Contents in Operations Navigator
(Kevin Vandever) Operations Navigator, or OpsNav, as it is affectionately known, has kicked up iSeries operation, administration, and application development several notches, yet many of you still use green-screen methods or other products that don’t compare with what OpsNav can do. One of those thi
APS cannot be restarted after applying SP3 to SQL Server 7 system database
In a Crystal Enterprise (CE) environment with a SQL Server 7 APS database, when Service Pack 3 for SQL Server 7 is applied to the database, the password for username ‘sa’ can no longer be left blank. Therefore a password is entered. When an attempt is then made to restart the APS, it does not st
A Simple Approach to Index Redesign
(Martin Hubel) Through my years of tuning DB2 applications on platforms ranging from mainframes to workstations, I am rarely called in before a problem has occurred. This means fixing an application to either achieve or restore acceptable performance. I often find that the application is not writ
Tips on optimizing your SQL Server indexes
Within SQL Server there are several tools that you can employ to monitor, tune, and optimize performance. Here, I will explain how to utilize and interpret the results of SQL Server tools to optimize the use of database indexes. I’ll also discuss general indexing topics. Indexes are one of the b
How to Shrink the SQL Server 7.0 Transaction Log
There are some common reasons why a transaction log might not shrink when you use the DBCC SHRINKFILE or DBCC SHRINKDATABASE command. The SQL Server Books Online topics “DBCC SHRINKFILE” and “DBCC SHRINKDATABASE” provide detailed information, but a brief summary follows.
Showdown-bcp vs. DTS
Every SQL Server application manager needs to move a large amount of data into or out of a SQL Server database at least once, so SQL Server has several tools for bulk data-transfer operations. In this article, I compare two familiar SQL Server utility programs—bulk copy program (bcp) and Data Transf
Porting Unmanaged Legacy C++ Applications That Interact with DB2 Mainframes into .NET/C#
(Satender Saroha) Recently there has been a sudden increase in new development projects for migrating existing C/C++ applications written on the UNIX/Windows platform to .NET. There are a variety of reasons for that, foremost among them being the desire to utilize the wide range of capabilities the
Reading, Storing and Transforming XML Data in .NET – Introduction
(Dimitrios Markatos) Unless you happened to be involved in some other career field, it would almost impossible to not realize that XML is steadily growing as a common data exchange format that can used be across any platform. As long as you conform to standard XML specifications, you can send your X
Transferring DTS Packages
(Darren Green) This article will try and explain the different ways you can transfer packages between servers and other storage locations, either directly or as files. The most common requirement is to transfer between two SQL Servers, and this is the main focus here, but some methods can be adapted