by Louis Duc Nguyen – Learn how to create a web page to extract data from a SQL Server database, with pivot/transpose.
Author: SSWUG Research
Verify Database Setup
by Andy Clark – The Red Gate Compare Bundle contains three tools that can help you maintain systems—SQL Compare, SQL Data Compare, and COMPare. Each tool does a simple job and does it well.
Database Revolution
By Kelli Wiseth – The world’s first self-managing, grid-ready database is here. Oracle Database 10g, Oracle’s new database release, takes manageability and performance to a new level while ushering in the era of commercial grid computing. Can you scale up your processing power as needed without scal
Oracle Label Security, Part 1: Overview
By Jim Czuprynski – Oracle Label Security (OLS) is a relatively new feature of Oracle 9i. It offers a powerful implementation of row-based security that’s perfect for restricting user access to specific data, especially in a data mart or data warehousing environment. This article presents a high-lev
Top Causes of SQL Server Downtime
Several dozen readers responded to Brian Moran’s call for feedback about the primary causes of planned and unplanned SQL Server outages in their environments. Here are the tallied results.
IBM to Update Information Integration Tool
Since it was unveiled earlier this year, IBM’s DB2 Information Integrator product, which pools data many sources into one location, has become so popular that customers have asked the company to one-up itself.
Expert: Stop stuffing data warehouses full
By Robert Westervelt – With so many data warehouses getting to be behemoth in size, companies should be looking for ways to link data to external sources rather than simply continuing to store more information, according to Barry Devlin, a data warehouse expert and IBM Corp. consultant.
Course Catalog
Descriptions of the available training courses for DB2 Information Management software.
Writing Your Own Functions in XSLT 2.0
by Bob DuCharme – Most XSLT 1.0 processors, particularly the ones written in Java, let you write extension functions in the processor’s host language, link them in, and then call those functions from stylesheets. The XSLT 1.0 spec spells out specific ways to check whether a particular extension func
Build a SOAP-based Chat Application with Java Web Services
by Petr Dvorak – This introduction to Web services eschews the canonical “stockQuote” service in favor of a more complex and more informative SOAP-based chat application. Learn how to develop a fully-functional application using the Eclipse IDE and free Web services software from Systinet.