(Peter Aitken) We all know that Magellan was a famous Portuguese navigator who, in the early 16th century, led the first expedition to circumnavigate the globe. Our task as web designers is not quite so daunting, but we still have to pay attention to navigation.
Author: SSWUG Research
Querying Databases in SQL Server 2005
(Jayaram Krishnaswamy) This hands-on tutorial should help you in understanding the interface available for querying the SQL Server 2005 databases. Some of the major features will be discussed as related to their use rather than going into a lot of details. Querying the database is one of the most ba
Services with Ajax: Why, when and why not
(Daniel Rubio) Besides the term SOA, there is perhaps just one more new term that has made itself onto the development lists of many IT departments in the last few months: Ajax. Although the term is more inclined to stir excitement among Web usability and design professionals, it does bring its shar
Recommended reading list: DB2 UDB for Linux, UNIX, and Windows database administration
(Cindy Wong and Samuel Poon) This article provides a list of online learning resources for DB2 UDB for Linux, UNIX, and Windows. The DB2 UDB Information Center is also a good source of information. Many of the items listed below are published as articles on IBM developerWorks or as IBM Redbooks. Thi
DB2 Content Manager for iSeries, Part 4: Client for Windows
(Jack Boswell) This article is a simplified user’s guide for the DB2 Content Manager Client for Windows on iSeries. It addresses the high-level functions of the Window’s Client. This information should be used in conjunction with the installation manuals and online help. The client application for W
Developing spatial applications using Oracle Spatial and MapViewer
(Liujian (LJ) Qian) This white paper introduces briefly the main features of the up coming Oracle Spatial database 10g and Oracle Application Server MapViewer 10g. Through a case study we also show that these off-the-shelf products can serve as effective building blocks for large-scale spatiotempora
Handling Cursor-Friendly Problems in T-SQL: Running Totals Example
(Mirko Marovic) By design, the SQL programming language works with data sets, so it is not surprising that for most problems, row by row processing is not nearly as efficient as data set processing. There is a class of problems, however, that is much easier to solve using cursors. A typical “cur
Tuning and Optimizing Red Hat Enterprise Linux for Oracle 9i and 10g Databases
(Werner Puschitz) This article discusses Red Hat Enterprise Linux optimizations for x86 (32 bit) and x86-64 (64 bit) platforms running Oracle 9i R2 (32bit/64bit) database, and Oracle 10g R1 and R2 databases (32bit/64bit). This guide covers Red Hat Enterprise Linux Advanced Server 2.1, 3, and 4.
Extending Oracle’s High Availability Framework with 10g Cluster Ready Services (CRS)
(Richard Stroupe) Previously in Oracle 9i RAC, customers who purchased the RAC option also had to depend on third-party venders such as Sun, Veritas and HP for cluster management support. Using multiple vendors for any high availability (HA) solution is very problematic and could introduce many obst
DB2 Data – Test Data Generation and Archiving: Two Underappreciated Arts
(Susan Lawson) There are many facets to a DBA’s work and responsibilities. We give focus to the most apparent and critical such as backup, recovery and data integrity. But what about the other parts of the job? Tasks such as creating accurate test data for proper application testing and the ability