(Jeff Wharton) Create a SQL Server Integration Services (SSIS) package that accepts a Globally Unique Identifier (GUID) as a variable and uses this variable as:
Other News
Customizing WebSphere MQ V7 for small and medium businesses
(Mohit Arora and Amit M. Mangalvedkar) This article describes common challenges you may encounter when implementing WebSphere MQ based solutions at small and medium businesses (SMBs), and shows you how to overcome these challenges.
All-In-One and One for All
PowerPivot Expo – Tomorrow At one of the largest Business Intelligence-focused virtual events of the summer, SSWUG.ORG is hosting eight sessions on PowerPivot! Learn from experts such as Mark Tabladillo, Brian Knight, Jen Underwood and others about organizing, connecting and manipulating tables of large data sets. If you want to attend, you should! After all, it’s free to attend the […]
Composition and Inheritance Wrap up
Composition and Inheritance Wrap up I have been very pleased with the response to the topic of when to use Composition and when to use Inheritance. The responses demonstrate that SSWUG is valued by an audience much broader than just database professionals. Ian shares some thoughts that wrap up this topic very nicely. Your example of a Car inheriting from […]
Understanding XSD Schema
(Ramesh Balaji) Those who deal with data transfer or document exchange within or across organizations with heterogeneous platforms will certainly accept and appreciate the need and power of XML. I am not going to delve into the merits of XML. I will, however, address a simple but powerful schema con
Conventions & Recommendations
There is often some confusion over when to use an element or an attribute. Some people say that elements describe data and attributes describe the meta data, another way to look at it, is that attributes are used for small pieces of data such as order id’s, but really it is personal taste that dicta
How to index XML documents in the presence of schema diversity?
(Matthias Nicola) XML is a flexible and extensible data format and is often used for messages or other document types whose structure can have multiple different variations or evolves over time. As a result, you might not be dealing with a single fixed document schema but with significant schema var
XQuery: Variable-based step in XPath expression
(Henrik Loeser) Recently I was asked how parts of an XPath expression can be passed into an XQuery in DB2. For performance, it is – of course – best to know all the steps when compiling a query. Let’s look into the options by introducing an example:
Predicate transitive closure for IN list is enhanced for DB2 9
(Willie Favero) This is a pretty cool. Transitive closure does some great things to help improve the optimizer’s ability to make better access path choices. For transitive closure and IN list processing, DB2 10 delivers what I think are some significant enhancements.
Debug Load Errors with the Assembly Binding Log Viewer
(Peter Vogel) One of the most frustrating error messages that you can get when debugging your application is “File not found” when loading an assembly (or just instantiating a new class).