(Brian Eastwood) One of the biggest additions to Visual Studio 2005 was the introduction of Visual Studio 2005 Team System, or VSTS. This product — now available in editions for developers, architects, software testers and database programmers — emphasizes collaboration throughout the software dev
Author: SSWUG Research
Design Patterns for ASP.NET Developers, Part 1: Basic Patterns
(Alex Homer) For the past year or so, I’ve been involved in documenting frameworks that help developers write better code, and create applications that are more efficient and easier to test, debug, maintain, and extend. During that time, it has been interesting to see the continuing development of b
Getting Started with AJAX 1.0
(Mahesh Chand) Recently, Microsoft released the commercial version of AJAX 1.0 as an extension of ASP.NET 2.0. That means you can develop AJAX enabled Web applications using ASP.NET 2.0.
Overloading Procedures in PL/SQL
(Lewis Cunningham) A FAQ that I get, well, frequently, is about overloading procedures. I think most people get how to overload but not when or why. Today I am going to explain a classic example of where overloading makes your life easier. More importantly, it makes the life of the code maintainer b
Moving Oracle Databases Across Platforms without Export/Import
(Roger Schrag) Prior to Oracle 10g, one of the only supported ways to move an Oracle database across platforms was to export the data from the existing database and import it into a new database on the new server. This works pretty well if your database is small, but can require an unreasonable amou
VB 9.0 Xml in Visual Studio ‘Orcas’ February CTP
(Avner Aharoni) In February CTP you will find the same functionality as in the May CTP with many improvements. Some of these improvements came from the feedback of extensive usability studies we conducted in the fall. Observing the obstacles users encountered provided us with good ideas on how to im
DataStage Tip: Extracting database data 250% faster
(Vincent McBurney) An IBM Developerworks article shows how to configure the remote DB2 Enterprise stage and benchmarks it as 250% faster than a standard API connection.
IBM Boosts Support For WebSphere, DB2
(Stacy Cowley) IBM is offering an expanded slate of sales and technical support around its free, entry-level WebSphere Application Server and DB2 products, a move aimed at wooing solution providers drawn to the low cost and easy accessibility of open-source offerings.
Getting MySQL to use full key length
(Peter Zaitsev) There is one bug, or "missing feature" in MySQL Optimizer which may give you hard time causing performance problems which may be hard to track down, it is using only part of the index when full index can be used or using shorter index while there is longer index available. The last i
Advanced topics for DWE users Part 2: Best practices for choosing DB2 Data Warehouse Edition SQL Warehousing variable phases
(Cheung-Yuk Wu and Marion Behnen) IBM DB2 Data Warehouse Edition SQL Warehousing Tool provides variables and variable groups to enable you to customize your data transformations and work flows. Optimize your DB2 Data Warehouse Edition flow design with a good understanding of variable usage in order