(Bruce Miller) Business applications are brimming with documents, email, and other information in electronic form. Any document, email, or similar item created in the conduct of the business mission (especially if it records or contributes to a business decision) is a corporate record and, therefore
Other News
Note the db_block_checksum parameter setting
You may have noticed that the default value for the db_block_checksum parameter is TRUE in Oracle 9i and above, whereas it was FALSE in previous versions. Although this makes it much less likely that minor data corruptions will go unnoticed, there is also a performance cost of which you should be aw
DB2 Access Classes
(Nick Adams) A set of classes to encapsulate DB2 CLI APIs in ADO style.
Parallel Processing for the Real-Time Enterprise
(John Derrick) Service orientation, Web services, self-describing data, loosely coupled applications – choose your favorite term. The enterprise IT world is moving inexorably towards architectures that will allow rapid development of applications that provide real differentiated value to their busin
Pros & Cons of Using SELECT, Views, and Stored Procedures in SQL Server
(G. Vijayakumar) When I first started using SQL Server as a novice, I was initially confused as to the differences between the SELECT statement, views, and stored procedures. They all seemed to perform more or less the same task (retrieve data), and I wanted to know the pros and cons of using each.
DB2 UDB for iSeries cursor sensitivity enhancements
(Kent Milligan) This article explains what cursor sensitivity is and how it’s programmatically controlled on DB2 UDB for iSeries. In addition, the article covers the performance impacts of using the different cursor sensitivity settings.
XBRL: The Language of Finance and Accounting
(Dale Waldt) The eXtensible Business Reporting Language (XBRL) is a language for capturing financial information throughout a business’ information processes that will eventually be reported to shareholders, banks, regulators, and other parties. The goal of XBRL is to make the analysis and exchange
Ways to Determine the Version and SP of SQL Server
(Dinesh Priyankara) Recently one of my co-workers came and asked me the correct version of SQL Server that we have installed in our company and the service pack. So, I asked him to run the SELECT @@VERSION in the Query Analyzer and see the result to get the version and service pack installed. He ran
Storage of timestamp values and nulls
(Craig Mullins) Our applications use a lot of timestamp columns. My question concerns the storage of timestamp values and nulls. When a null indicator is set to X’FF’ (indicating a null value), DB2 requires at least one byte of space for the null indicator. What does DB2 allocate for the “empty” dat
Using DB2 Information Integrator and WebSphere MQ
DB2 Information Integrator enables real-time integrated access to heterogeneous data such as relational databases, XML documents, queues, and text files. It can all be transparently accessed from a common platform and combined using the power of SQL. In this tutorial you’ll use DB2 Information Integ