(George Walsh) AS/400-based independent software vendors (ISVs) are finding it increasingly difficult to sell their wares to new customers. Many companies will not accept a legacy platform such as the AS/400 when there are more modern environments, such as Windows and .NET, which utilize hardware wi
Other News
TechTip: SQL Communications Area
(Kevin Forsythe) When RPG programmers begin to use SQL, one of the more difficult things for them to adjust to is that the SQL statements do not issue escape messages if an error occurs. They simply set a few status codes and return control to the next line of code in the program. Combating this pro
Predeployment I/O Best Practices
(Mike Ruthruff) The I/O system is important to the performance of SQL Server. When configuring a new server for SQL Server or when adding or modifying the disk configuration of an existing system, it is good practice to determine the capacity of the I/O subsystem prior to deploying SQL Server. This
Anonymous Types (or Projections) in VB9
(Paul Kimmel) In this article, I will demonstrate a small part of my presentation from the West Michigan .NET Users Group Day of .NET, An Introduction to Orcas, anonymous types. (Kudos to Chris Woodruff for pulling off a first rate event.)
Unveil the Data Binding Architecture inside Microsoft ASP.NET Ajax 1.0 – Part 2
(Xianzhong Zhu) In part 1, we mainly examined the data binding architecture inside Microsoft ASP.NET Ajax 1.0 in theory and gave a simple example. Now in part 2 we will continue to study the practical usage associated with the client-side data binding techniques of the toolkit, i.e. we will build tw
Using The Office 2007 OCR Component in C#
(Rick Leinecker) I recently went to a training seminar in order to learn how to use Microsoft Office 2007. It’s a great package, but what really impressed my was its capability to turn images into text with almost no effort. This technique is known as Optical Character Recognition (OCR), and it has
Get started with IBM DB2 Test Database Generator
(Sami Salkosuo) Need sample data to test the application you’re developing? Learn how you can use IBM DB2 Test Database Generator to generate a variety of types of test data, including SQL, comma separated value (CSV), and XML formats. This article shows how to install, configure, and use this tool.
Oracle RAC: Checking RAC status with SQL/OS level statements
(Tarry Singh) Our last article was about monitoring RAC, which we will get back to in upcoming articles. Monitoring can be a daunting task for a DBA but fortunately, the EM console is a good place to start. There are vendors that deliver products to monitor RAC–we did a 3-part article reviewing the
Column Naming
(Dominic Delmolino) Laurent’s post on column qualification reminded me of a conversation I had with one of my staff about column naming standards. But before I get to that conversation, I’d like to share my favorite example about using table aliases.
Perils and Pitfalls in Oracle Partitioning: Bind Variables?
(Don Seiler) Recently one of my developers found some articles by Arup Nanda while researching a query performance problem. The articles were title “Perils and Pitfalls in Partitioning,” parts 1 and 2.