(Lester Knutsen) The Informix Dynamic Server (IDS) sysmaster database contains information you can use to understand the layout and performance of the databases, tables, and detached indexes on your server. I’ll show you how to use this information to your performance advantage.
Other News
PokerRoom.com Powers High Transaction Online Poker System with MySQL and HP
In the late 1990s, two Swedish students decided to take a break from their university studies. Traveling across North America, they made a living as professional poker players. A couple of years later, upon their return to Sweden, they started an online poker site – PokerRoom.com. Today the si
Extend the SQL Server 2005 Integration Services Script Task with Your Own .NET Class Library
(Jeffrey Juday) If you’re familiar with SQL Server 2005 Integration Services (SSIS) you’re probably aware that SSIS includes vast improvements over SQL Server 2000 Data Transformation Services (DTS). Among these improvements is extensive .NET support, which comes in many forms. For example, the
Implement a DITA publishing solution without abandoning your current publishing system investments
(Robert Anderson and Erik Hennum) In with the old, in with the new. How did IBM move forward with Darwin Information Typing Architecture (DITA) without investing in a completely new system? This article describes the solution that allowed us to begin working with the new, topic-oriented DITA archite
Walkthrough: Using DB2 Stored Procedures with PHP
(Justin Whitney) As a Web developer, I want my DB2 database to do more than just store pretty things. I want to be able to show them off for all the world to see. PHP gives me a fun way to do that. But how do the two work together? And how can I use PHP to make the most […]
Database Links: A Definition in Plain English
(Lewis R Cunningham) A database link is the way Oracle allows you to connect from one database to another. There are several types of links and I will discuss each of those. Database links are also used in heterogeneous access and I will, very briefly, describe that.
An Image is Worth a Thousand Words in PHP
(Brian Vaughn) Picking up where we left off in part one, we will work on some more helper methods and our conversion method. By the time we are done, we wil lhave a fully functional image to text converter.
Locate SQL Server instances on the local network
(James Curran) This articles shows how to retrieve a list of PCs on the local network which are running MS SQL Server, and gets information about the instances, such as server name, instance name, version, and databases.
Installing and using phpMyAdmin to manage MySQL databases
(Vincent Danen) Management of MySQL databases can be fairly straightforward — with the right tools. Using the MySQL command-line client requires a fairly intimate knowledge of MySQL in particular, and the SQL language in general. Not only that, but depending on the size of your terminal, the output
Use XSLT to Write a Simple Stored Procedure Generator
(Max Voskob) Imagine that you’ve just finished building a database for another Web-based system. Now it’s time to start thinking about writing all that SQL to move the data in and out of the database. Being a security-conscious developer, you decide against building dynamic SQL in your data-tier cod