(Joseph Fuda) This tutorial demonstrates how to transform numbers like 1, 12, and 123 into English words like “ONE”, “TWELVE”, and “ONE HUNDRED TWENTY-THREE”. This transformation is a common requirement for cheque printing applications.
Other News
System Administration Certification exam 918 for IBM Informix Dynamic Server 11 prep, Part 3: System activity monitoring
(Joseph W. Baric, Jr.) Explore the topic of troubleshooting for IBM Informix Dynamic Server. After a brief overview, you’ll learn about the various tools that are available for troubleshooting, and then look at examples of how to examine the database server to solve problems. The third in a series o
MySQL Test Case Creation Tool
(Charles Cahoon) The MySQL test framework needs a tool that will increase the production of test cases. The proposed tool will be a command line client that records queries and responses to then create the .test and .result files. There were a couple of proposed options that would also achieve a sim
QA Strategy and Tactics in a BI Project, Part 2
(Arup Duttaroy) Part 1 detailed the foundational elements of quality assurance (QA) and discussed the importance of documentation in change management and quality reviews. Part 2 is an in-depth discussion of the QA organization.
(67) SelectViews: Interviews with Stephen Walther, Kat Meadows, Brian Dawson and great solutions profiles.
Video Programming for IT Professionals
Get the Sum of a particular column values in a DataGrid
(Rahul Saxena) In this article, I am going to show how we can add a column value in a DataGrid. To add a column value in this programme I am using a function. In the function, I am passing the value of that particular column. Let us see how to do this through the below code.
SQL SERVER – 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) – CTE vs. Derived Table
(Pinalkumar Dave) I have received few emails and comments about my post SQL SERVER – T-SQL Paging Query Technique Comparison – SQL 2000 vs SQL 2005. The main question was is this can be done using CTE? Absolutely! What about Performance? It is same! Please refer above mentioned article for history o
ColdFusion Feature — Coding with XML
(Andrew Schwabe) As a ColdFusion developer, hopefully by now you have heard at least a little about XML (eXtensible Markup Language). Wikipedia defines XML as a “general-purpose markup language” designed to “facilitate the sharing of data” and also designed to be “relatively human-legible.”
Encrypted columns and SQL Server performance
(Dmitry Tsuranoff) For legal reasons it is very important to encrypt table columns containing sensitive data, like SSNs. SQL Server 2005 allows you to encrypt data using different algorithms that employ symmetric and asymmetric keys. Alternatively, you can also use password-based encryption, where t
DB2 LUW Performance: Index Read Efficiency (IREF)
(Scott Hayes) How many rows must be read (evaluated) to retrieve one row? If DB2 lacks sufficient indexes to filter the result set according to the WHERE predicates, then DB2 will have to evaluate many, possibly too many, rows from the data pages to find result sets.