(Cheung-Yuk Wu and Marion Behnen) IBM DB2 Data Warehouse Edition SQL Warehousing Tool provides variables and variable groups to enable you to customize your data transformations and work flows. Optimize your DB2 Data Warehouse Edition flow design with a good understanding of variable usage in order
Other News
Getting MySQL to use full key length
(Peter Zaitsev) There is one bug, or "missing feature" in MySQL Optimizer which may give you hard time causing performance problems which may be hard to track down, it is using only part of the index when full index can be used or using shorter index while there is longer index available. The last i
How And Why AJAX, Not Java, Became the Favored Technology for RIAs
(Bruce Eckel) Several of Bruce Tate’s books focused on the flaws in Java and the need to let go of some of the ideas that haven’t worked out. And blogs like this and this have been appearing more frequently. And of course there’s Steve Jobs now-famous quote (referring to the iPhone): “Java’s not wor
The XML behind podcasting
(Ed Tittel) In my current series of XML tips, we’ve been looking at various markup languages, tools and technologies related to syndication, including various forms of RSS, Atom and even RDF. In today’s tip, we’ll take a look a one particular type of syndicated content—namely podcasting—that has bec
Creating Custom Configuration Sections in Web.config
(Scott Mitchell) Most ASP.NET applications include a number of configuration settings, such as connection strings, mail server settings, system-wide default settings, and so forth. While these settings could be hard-coded in the source code, it’s usually a wiser idea to place them in a configuration
Forms, Controls, and Other Useful Objects
(Tim Patrick and John Clark Craig) If you are writing a desktop application, you are dealing with forms and controls. Since its first release, Visual Basic has made the dream of drag-and-drop programming possible: just add some controls to a form, press F5, and go.
Another short comment on V8 CPU usage
(Willie Favero) Sometimes what is measured isn’t always what you think it is; isn’t always an accurate picture of what is going on. So is the case with CPU regression. If you are comparing accounting information from Version 7 to the CPU being used by Version 8, and an increase in CPU is measured, i
Directives, Access, and More with the Oracle HTTP Server
(Sam Alapati) In addition to the many OHS configuration directives you have learned about so far, Oracle HTTP Server provides two special directives, Options and AllowOverride, which you can use to allow or disable several features of the Oracle HTTP Server.
IBM Offers Free Sales Help For Open Source Developers
(Paul McDougall) In an effort to bolster use of its open source middleware and license-free database software, IBM said it will provide free sales and marketing support to developers who create products for those offerings.
SQL Server Excel Workbench
(Robyn Page and Phil Factor) Phil and I have teamed up on this workbench, which demonstrates how to create, read, update and delete information in Excel using T-SQL, from SQL Server. As always, the workbench is structured so that it can be pasted into Query Analyser and SSMS, and the individual exa