(Chenhong Xia) This is Part 3 of a tutorial series that teaches you how to create proof-of-concept applications to access relational and XML data in IBM DB2 9, using Microsoft Visual Studio .NET 2005. Part 1 explained the application specifications, database design, and how to create DB2 relational
Author: SSWUG Research
Whitespace Handling in XSLT Transformation
(Mohan Vanmane) Last week I developed an XSLT using the new XSLT debugger in Visual Studio 2005. Since I was happy with the transformation output in the XSLT Debugger, I deployed my solution on my Web site. However, I was surprised to see that the XSLT transformation output in Internet Explorer look
Capture changes using Oracle 10g’s new row timestamps
(Bob Watkins) Data warehouses are often populated by multiple source systems, each running their own applications. It can be tricky to determine which rows were recently updated, so that feeds to the data warehouse only include the new data. This is especially a problem with legacy applications that
System.Transactions and ADO.NET 2.0
(Sahil Malik) Data is the blood in your system; it sits in its comfortable home of a database, and camps out in the tent of XML, but it deserves to be worked with in a reliable and consistent manner.
Microsoft launches CodePlex and announces MySQL partnership
(Matthew Aslett) Microsoft Corp has officially unveiled CodePlex, its new collaborative development portal for community-based development for open- and shared-source projects, while signing a new partnership with open-source database vendor MySQL AB.
Commenting Functions and Mutiple Lines in Visual Studio 2005
(acc15) A macro can create any function comment from any function definition. A macro hardly can determine function definitions, including calling conventions, full return types (including spaces in types between ‘*’ and ‘&’ and “const” specifier), parameters lists, function names, and so on. Also,
Information on demand: Unleash the power of DB2 9
Information is everywhere. Delivering the right information to the decision makers at the right time is critical to achieving business results. Information can reside in existing relational databases, Web service providers, or within files. The nature of information is changing as more and more info
Web Services Standards for Data Mining
(Robert Chu) Most, if not all, data mining and scoring tool providers require users to use provider-specific ways to invoke their services. The provider-specific approach could be a major factor affecting why data mining tools and applications are not currently as widespread as one might hope. Web
The DBCC SHRINKFILE statement has no effect when you run it after you run the DBCC SHRINKFILE statement together with the EMPTYFILE option in SQL Server 2000
In Microsoft SQL Server 2000, if you run the DBCC SHRINKFILE statement after you run the DBCC SHRINKFILE statement together with the EMPTYFILE option, the second DBCC SHRINKFILE statement does not have any effect.
On creating workspaces and merging/refreshing data with Oracle’s Workspace Manager
(René Nyffenegger) With Oracle’s Workspace Manager it’s possible to have several versions of data. That is, data can be changed, thus giving it a new version, without users looking at data of another version seeing the modified data. In this article, I try to explain this feature.