(scott) If you want to build your own UI front end to SQL Server Reporting Services, one web method you’ll need to become familiar with is GetReportParameters. GetReportParameters will return metadata about the parameters in a report, including names, types, and valid values.
Other News
Internet/Distributed Computing using HTTP/POST
(Xuan Shi) Much research on semantic Web services has focused on modeling and describing the service aggregation processes as part of the service semantics. This article demonstrates that modeling the process of Web service aggregation should not be a part of the semantic service description fra
Log DB2 UDB stored procedure messages
(Vikram S. Khatri) This article presents a logging framework that you can use with IBM DB2 Universal Database (DB2 UDB) stored procedures to log informational, error, and debug messages directly from the procedure itself. The logging framework methods use shared memory concepts to coordinate and cha
IBM WebSphere Developer Technical Journal: Leverage IBM Express Runtime to develop and deploy complete software solutions
(Lim Sham Sham and Tan Eng Kian) For independent software vendors (ISVs) and their customers, there is more to a solution than just the application. A complete solution includes an application, but it’s an application that is integrated with the middleware components that enable the application to w
Create XML Easily with FOR XML PATH
(Jerry Dixon) SQL Server 2005 is now here, and with it comes a new XML data type and support for the new XQuery language. XML can now be stored directly in the database, queried, and even edited in place. In addition, the existing creation and consumption capabilities from SQL 2000 have been enhance
Simple DOM Access
(David Nishimoto) The Simple DOM Access (SDA) provide a very abstract perspective for interacting with an xml structure. The xml structure only contains elements named “node”. Creating an xml structure with only node elements provides for easy search capabilities when using the selectSingleNode and
Using Apache-Style HTTP Authentication on IIS
(Ziran Sun) Have you ever wished you could easily set up password protected areas of your web site without creating system user accounts? What about moving a password protected website from Apache to IIS? This article examines a free product that makes both of these tasks amazingly simple.
Stored procedure: Easily filter for SQL Server connections
(Brian Walker) This tip continues the system stored procedure series with a routine to list information about SQL Server connections or perform actions for selected connections. (R)
Primary Keyvil, Part II
(Josh Berkus) What follows are a number of reasons people have given me, on IRC and the PostgreSQL.org mailing lists, for using autonumber keys. Some of them are “good” reasons which demonstrate and understanding of the costs and benefits. Others are “bad” reasons based on sloppy thinking or lack of
Uniform Page Size in 8.2.2
(Chris Eaton) As you may be aware, DB2 has supported multiple page sizes within the same database for years. As well DB2 supports up to 4096 buffer pools where each buffer pool can be of any valid page size (4k, 8k, 16k or 32k). This is in contrast to other vendors that only allow one buffer pool pe