(Frank Zhou) This query inserts a space between characters in a string.
Author: SSWUG Research
Import COBOL copybooks in IBM Rational Data Architect
(Davor Gornik) Since Fix Pack 1, Rational Data Architect has been able to import COBOL copybooks as a logical data model. Importing as a physical model is not possible because physical data models in Rational Data Architect require database specification, which is not part of the copybook specificat
Planning to upgrade XSLT 1.0 to 2.0, Part 1: Improvements in XSLT
(David Marston and Joanne Tong) XSLT 2.0 introduces numerous new features, and some are specifically designed to address XSLT 1.0 shortcomings. Explore some of the most highly desirable features: grouping, Implicit Document Nodes, user-defined functions, date-time manipulation, Schema-awareness, and
Exact contents of redo logs
(Brian Peasland) I want to know the contents of the redo logs. Do redo logs contain exact data inserted by users or instructions to redo transactions in case of failure? (R)
Deconstructing .NET 3.0
(Matthew David) In 2000, Microsoft released the first beta of a product called .NET 1.0. The product, a framework of classes, was the answer to problems that Microsoft faced from the developer community, particularly the Java community. Microsoft was seen as old-fashioned and behind the times. The .
A Tour of Windows Workflow Activities
(Dino Esposito) Most enterprise applications contain business processes that developers and architects find natural to express through workflows. Ultimately, a workflow is a program that captures the interactions among real-world entities. The workflow waits for stimulus from the external world, and
Configure MS SQL Server 2005 Remote Access ( mixed mode )
(hong_wei_li) MS SQL Server 2005 remote access configuration is different from MS SQL Server 2000. Remote access to MS SQL Server 2005 with user and password is required and necessary for any database applications. If MS SQL Server 2005 is originally configured for windows authentication, configurat
Detect Web Form Field Changes in ASP.NET
(Bill Xie) Knowing whether a group of form fields have changed and which fields have changed can be beneficial in many ASP.NET Web applications. ASP.NET triggers a “value change” event at the server side for each server control for which the client changed the value upon postback.
Best SQL Server 2005 MDX Tips and Tricks – Part 1
(Nicholas Dritsas) SQL Server’s 2005 Analysis Services has introduced several changes to the MDX queries syntax that can lead to better performance than the equivalent AS 2000 queries.
Black Belt Components: Interactive Sorts within a Matrix Data Region
(William Pearson) In this article, we will get more hands-on exposure to providing an interactive sort capability for the information consumers we support. Our hands-on practice will specifically focus on the establishment of interactive sorting within a Matrix data region. We will discuss the gener