By providing a flexible, platform-neutral way for rendering diverse data types, XML has become a standard for exchanging information across heterogeneous applications. Web services, a set of XML based protocols for finding and communicating between loosely-coupled, internet callable application “ser
Author: SSWUG Research
Performing client-side XSL transformations
(Tony Marston) It is a feature of my software that I produce HTML output from XML documents with server-side XSL transformations. This means that as well as producing the XML document I transform it into HTML on the server before I send the result to the client.
FIX: A memory leak occurs when you run a remote query by using a linked server in SQL Server 2000
When you run a remote query by using a linked server in Microsoft SQL Server 2000, a memory leak occurs. This problem occurs when the following conditions are true: • The query returns variable-length data that is 256 bytes or larger. For example, the query returns a column, and the type of the
DB2 for z/OS Version 8 Reserved Words
(Willie Favero) Yup, every new version and release of DB2 has them. They are words that you cannot use in an SQL statement under penalty of error (-199 or DSNH083I) unless they are a delimited identifier (mark off by a quotation mark (") for example). And why might they be a problem? Well, DB2 might
Advice on Using Variable Character Columns in DB2
(Craig Mullins) One of the long-standing, troubling questions in DB2-land is when to use VARCHAR versus CHAR. The high-level advice for when to use VARCHAR instead of CHAR is for larger columns whose length varies considerably from row-to-row. Basically, VARCHAR should be used to save space in the d
Checklist: Data mining 101 in SQL Server 2005
(Laurence Schwarz) Data. We have more of it now than ever before. And in the last 10 years, technology has provided us with the tools to collect ever more data. The question is what do we do with it? What does it mean? (R)
DB2 security, Part 7: Object ownership management for DB2 9
(Kevin Yeung-Kuen See) Transfer ownership is a new DB2 9 feature where the ownership of a database object can transfer to another authorization ID (authid). There are two general usages for this feature. The first usage is when the owner of an SQL object leaves a company, the ownership of the object
Building a SQL Server 2005 Integration Services Package Using Visual Studio 2005
(Jayaram Krishnaswamy) Data Transformation Services (DTS) which came with MS SQL Server 7.0 has now emerged as SQL Server Integration Services in MS SQL 2005 Server, an enterprise quality ETL (extraction, transformation, and load) program. DTS as implemented in SQL 2000 was limited in its tasks and
Beginning SQL Server 2005 Reporting Services Part 1
(Steve Joubert) If ever there was job for “real” developers to shuffle to their juniors, it is building reports. It’s not real development anyway; it’s more like glorified formatting. Besides, the esoteric tools that you use to build reports try to provide an abstraction layer, which often prevents
An Introduction to AJAX Techniques and Frameworks for ASP.NET
(Rama Krishna Vavilala) By now, the chances are high that you have heard of AJAX in the context of web development. The acronym was coined by Jesse James Garret in his article: AJAX: A New Approach to Web Applications. Several frameworks have emerged since then to support AJAX Web development. In th