(Inge Halilovic) This article summarizes some of the key features of IBM Informix Dynamic Server, Version 10.0 and provides insight into the general business problems they are intended to solve.
Other News
Message Maintenance Architecture with C# and XML
(sarav.r) In today’s IT world “Error Messages” or “Information Messages” in any systems are inevitable. In application development the messages are normally coupled in to the system. So, whenever customer asks for change in messages, developers get in to the code and change the messages, which is ge
Microsoft SQL Server and Itanium 2: High Performance and Low TCO
The industry excitement over 64-bit processing capabilities on the Intel platform in the last several months has been explosive. Probably the most appealing feature of 64-bit is the ability to directly address large physical memory – currently as high as 512 GB on the Windows 2003 platform. M
Using MySQL from PHP
(John Coggeshall) Welcome back to PHP Foundations. My previous column finished the crash course on using MySQL to store and retrieve data from a database using the Structured Query Language (SQL). In today’s column, I will begin to use everything I have shown you thus far to work with and create dat
Quick! Which specific SQL Server user is logged into which database?
(Serdar Yegulalp) SQL Server’s master database stores tables with important and constantly updated information about the state of the SQL server. One of these tables, sysprocesses, can be used to track (in SQL Server itself) which SQL Server users are currently logged in and which database(s) they a
Setting up a default library in DB2
(Kent Milligan)How can I set up a default library in DB2 in order to not change our SQL statements? In fact, we are migrating from DB2 UDB Windows Server to the iSeries. Actually, in Windows environment, our SQL statements run well and with the SET CURRENT SCHEMAS = “EMPORIUM”, we define default sch
Beginning Regular Expressions: An Encyclopedia of A Book
(Dan Mabbutt) A lot of you may be wondering why you should care about “Regular Expressions” … or you might even be wondering what they are. Regular expressions search and select text. This “specialty technology” is taking on new meaning because text is coming back. Technologies like XML and We
Effective Strategies for Data Mining
Databases were developed with an emphasis on obtaining data; more data meant more information. Professionals trained in decision support analysis analyzed such data and discovered information in the form of patterns and rules hidden in the relationships between its various attributes. This assisted
T-SQL implementation of SKIPJACK
(David Janecka) This source code is an T-SQL implementation of the crypt algorith SKIPJACK as a user function for MS-SQL 2000.
SQL Server 2005 Integration Services: Lessons from Project REAL
Richard Waymire, Len Wyatt, John H. Miller and Donald Farmer) In Project REAL we are using large volumes of real data and scenarios from real companies to implement business intelligence systems using early releases of Microsoft SQL Server 2005. In the process, best practices are being developed