(Jean-Paul S. Boodhoo) I am a big fan of objects. It’s so convenient to work with programming entities that you can ask to do something and they just do it. The shift that we developers have made from procedural style to OO style allows us to express ideas in much richer ways than were possible usin
Author: SSWUG Research
Storing an XML Document in Apache Xindice
(Deepak Vohra) Apache Xindice is a native XML database in which XML documents may be stored, queried, and modified. The advantage of a native database over a relational database is that mapping of XML to SQL is not required. Instead, XPath is used to query the Xindice database and XML:DB XUpdate is
Script to Find User Information and More
(Pankaj Borole) This script will find user information, object count (as per object_type), roles assigned, and system privileges.
WebSphere for z/OS Problem Determination Means and Tools
(Rica Weller, Cleberson Calefi, Keith Jabcuga, Suresh Maddukuri and Robyn Nostalgi) For the day-to-day administration tasks for IBM WebSphere for z/OS, you need powerful and efficient tools for analyzing problems, for finding their root causes, and for solving them. (pdf)
Restrictions on Stored Routines and Triggers
Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored functions. Some of restrictions apply only to stored functions, and not to stored procedures.
Monitoring and Tuning SQL Server with Profiler
(Baya Pavliashvili) SQL Server comes with several excellent tools for monitoring and tuning application performance. Profiler is perhaps the most powerful of these tools; it allows you to spy on and analyze the impact of SQL statements sent to your server.
Take your .NET application for a spin with ACT before rollout
(Tony Patton) The time has finally arrived. The coding is finished and everything has been tested as thoroughly as possible, so the next step is rollout, right? Well, you may want to take a step back and evaluate the application’s performance under expected conditions before the unveiling.
Database Migration – It’s More than Running exp and imp
(Steve Callan) The new server using Red Hat is up and running, Oracle RDBMS software has been installed, a new instance is running with all of the new features you can possibly imagine (at long last, run_fast=true is available), and “all” that’s left to do is migrate the source database (or schema)
Perform the Impossible: Update a Multi-Table View using INSTEAD OF Triggers
(Michael Sansoterra) Sometimes using SQL to perform simultaneous inserts, updates and deletes against related tables can be a chore. It would be convenient if programmers could simply treat related tables as a single table for the purpose of modifying data.
Advanced Query Writing, concluded
(Andrew Oppel) From Chapter 1, you should recall that a view is a stored database query that provides a database user with a customized subset of the data from one or more tables in the database. Note that Microsoft Access uses the term query instead of view. The inherent beauty of views is that, on