(Susan Visser) IBM’s new Dynamic Warehousing initiative was recently unveiled. IBM is the first to fully understand and define this next generation of data warehousing. Only IBM can deliver all of the Dynamic Warehousing capabilities with a product portfolio that is best in class. Read the Dynamic W
Author: SSWUG Research
Real-World AJAX Book Preview: Digging into the XInclude Binding
(Kurt Cagle) The XInclude Binding serves as a good example showcasing how such bindings can be created. If you are familiar with XBL bindings, the one aspect that is missing in the JavaScript version is the use of a specific template. This can be readily overcome within the constructor, especially s
How to find the max row per group in SQL without subqueries
(Xaprb) A while ago I wrote about how to select the first, minimum, maximum or least row per group in SQL. This article shows how to solve this problem without subqueries.
SqlCredit – Part 3: Schema/Proc Updates and Automated Unit Testing
(Rob Garrison) In this month’s installment, we will discuss updates based on feedback from part 2 as well as introduce automated unit testing.
UDM in SQL Server 2005: Linking Relational and Multidimensional Databases
(Alexander Berger, Py Bateman, Irina Gorbach and Edward Melomed) The Unified Dimensional Model (UDM) of Microsoft SQL Server Analysis Services 2005 makes it possible for you to set up your system so that different types of client applications can access data from both the relational and the multidim
A flexible data integration architecture using WebSphere DataStage and WebSphere Federation Server
(Simon Harris and Susanne Englert) Combine WebSphere DataStage and WebSphere Federation Server to provide an efficient and flexible architecture for moving and transforming data. This article promotes the use of WebSphere Federation Server as a “data pre-processor” for DataStage, and demonstrates si
OBJECT_NAME enhancement and OBJECT_SCHEMA_NAME addition in SQL Server 2005 SP2
(Umachandar) SQL Server 2005 SP2 has an important enhancement to OBJECT_NAME metadata function and a new OBJECT_SCHEMA_NAME metadata function. I will first describe the old functionality to give some context and demonstrate how the new features help a lot.
Creating a Node Tree Fragment in XSLT using Internet Explorer
(Mike DiRenzo) This article describes a means of using C# to create a node-tree-fragment in XSLT.
How to Use Variables, IF and CASE in Database Interactions with TransactSQL
(Jagadish Chaterjee) This is the second article in a series focused on programming with Transact-SQL. In this article, I shall cover a few of the tricks for using variables and finally touch on IF and CASE structures as part of Transact-SQL.
How to set a single table read-only in Oracle
(David) It is easy to set an entire TABLESPACE read-only in Oracle by using the following command: ALTER TABLESPACE tbs_name READ ONLY;