(Alex Louwe Kooijmans, Marc van der Meer and Tony Nix) This IBM Redpaper addresses the need for information in the area of integrating security between WebSphere Application Server on z/OS and the outside world. (pdf)
Author: SSWUG Research
Creating documents over a subtree
(Neetu Rajpal) After my TLC session on XML Tools in Visual Studio a gentleman came up to me and asked me a question. He said that he deals with XML coming over the pipe and their usually isn’t an end-of-file character at the end of his email document. He was trying to figure out how he can create a
Extreme Markup Languages
Extreme is an open marketplace of theories about markup and all the things that they support or that support them: the difficult cases in publishing, linguistics, transformation, searching, indexing, storage and retrieval, the things you wish you could do in XML so much that you’re thinking of creat
How to remove duplicate rows from a table in SQL Server
Microsoft SQL Server tables should never contain duplicate rows, nor non-unique primary keys. For brevity, we will sometimes refer to primary keys as “key” or “PK” in this article, but this will always denote “primary key.” Duplicate PKs are a violation of entity integrity, and should be disallowed
Checksum in SQL2005
(Sunil Agarwal) Page checksum is new feature in SQL2005 that provides you a stronger mechanism than torn-page to detect any corruptions in IO path. Here are some details and scenarios.
Integrating databases and workflow systems
(Srinath Shankar, Ameet Kini, David J DeWitt and Jeffrey Naughton) There has been an information explosion in fields of science such as high energy physics, astronomy, environmental sciences and biology. There is a critical need for automated systems to manage scientific applications and data. Dat
Functions (Sample Chapter)
(W. Jason Gilmore) Even in trivial applications, repetitive processes are likely to exist. For nontrivial applications, such repetition is a given. For example, in an e-commerce application, you might need to query a customer’s profile information numerous times: at login, at checkout, and when veri
A New Face on the Block
(Steve Muench) Oracle JDeveloper 10g Release 3 (10.1.3) improves the J2EE development experience from every point of view. Released in February 2006, it provides slick new refactoring features that make iterative code improvements a snap. It also offers new teamwork support that simplifies collabora
What’s So Good About SQL Server 2005 OLAP?
(Andrew Brust) SQL Server 2005 Analysis Services, with its Unified Dimensional Model, has turbo-charged its OLAP capabilities. These new OLAP solutions can be useful to your business because they’re more powerful than their SQL Server 2000 counterparts, easier to develop, and can be based on real-ti
Import DB2 table data into a spreadsheet
(Amar Thakkar) This article describes how to import DB2 for Linux, UNIX, and Windows table data into either a Microsoft Excel spreadsheet or a Lotus 1-2-3 spreadsheet. Using step-by-step examples, learn how easy it is to import data to create meaningful charts and graphs.