(Brad Cowdrey) This is a series of articles on the SQL analytic features of Oracle9i. At first glance, they seem foreign and overly complex; however, once the features are demystified, they become very powerful tools in the business intelligence and reporting environments. Part 2 explores aggregatio
Author: SSWUG Research
DB2 UDB V8.2 on the Windows Environment
(Whei-Jen Chen) DB2 UDB V8.2, code name Stinger, is another significant jump in DBRM technology. It delivers new features to address the ever-increasing demands and requirements for Information management customers. This redbook is an update of “DB2 UDB Exploitation of the Windows Environment (S
Scalar Sub-Queries in SQL Server
(Muthusamy Anantha Kumar) Scalar sub-queries return exactly one column value from one row. Scalar sub-queries can be used in CASE expressions, WHERE clauses, ORDER BY clauses and SELECT clauses. This article reviews a few examples of how to use scalar sub-queries in most situations.
Manage Development and Production Database Connection Strings with XML Serialization
Database connection strings are an important part of any data-enabled application. Because developers typically have development and production connection strings to manage (depending upon the environment they are working in), many different strategies have been created to handle switching from deve
Microsoft Reporting Services in Action: Extending Microsoft SQL Server 2000 Reporting Services with Custom Code
(Teodor Lachev) This article presents an excerpt from the book Microsoft Reporting Services in Action. Learn how to implement advanced report functionality using custom code.
Database Property Viewer Using SQL RS
In the article titled Understanding Reporting Services Web Service Access, we saw how the entire SQL Reporting Services can be controllled by using the web-service interface. We also built a sample application using the same. The very fact that you can control various aspects of Reporting Servic
A Simple Serializer / Deserializer
(Marc Clifton) I needed a simple serialization / deserialization mechanism to save and load state information for objects whose type (the class) is constructed and compiled at runtime. Neither XmlSerializer nor BinaryFormatter classes handle this scenario. So, I wrote a lightweight assembly to
Basic SQL Coding for DB2 Universal Database for OS/390
(Susan Lawson) Up to now, we have discussed basic SELECT statements. The SELECT statement allows you to retrieve data from your database tables and assumes that data has been previously loaded into the tables. Now we will concentrate on manipulating data in tables using SQL. There are three main
Use ISO Images Without Burning to Disk
(Andy Warren) For those of you who have an MSDN subscription you may have noticed that many of the downloads are now available as ISO images (basically a copy of the data as it exists on disk, sector by sector). Win XP makes short work of burning those images to CD as readable files, but so far
Microsoft, SQL Server and Performance Management: The Business Scorecards Accelerator, Part 2
(Trey Johnson and Pam Barker) This is the second of a two-part series walking you through the new performance management solution from Microsoft, Microsoft Office Business Scorecards Solution Accelerator. Part 2 focuses on bringing the scorecard to life and porting the information to a portal.