When you execute a query in SQL Server 2000 Analysis Services to retrieve a drillthrough result set, the result set contains data for the whole relational source. This problem occurs when the following conditions are true: • A cube role was defined for the relational source with the following set
Author: SSWUG Research
‘Hello Ajax’! How to Do the Ajax Thing with Oracle JDeveloper
(Frank Nimphius) For sure, the world’s most successful computer program is “hello world”. Translations of it are available in almost every programming language and pattern.
Overview of SQL Server 2005 Architecture
(Vidya Vrat Agarwal) This lesson introduces you to the various components and services of Microsoft SQL Server 2005. Database administrators (DBAs) are often required to manage multiple aspects of a database server, not just the relational database engine. Therefore, an awareness of the components a
BPEL in a Service-Oriented Architecture
(Adam Kolawa) Business Process Execution Language for Web Services (BPEL) is an XML-based language for standardizing business process description as well as standardization of interaction between business processes in a distributed environment. BPEL extends the Web services interaction model and dep
What is the Future of DB2?
(Sean McCown) I often wonder who will ultimatly take the lion’s share of the database market. Oracle and Microsoft seem to have a strong lead while IBM and Sybase seem to be lagging behind. And for some reason Sybase seems to be almost not even on the same course as the others.
The secrets of open source security
(Chad Perrin) Debates rage across the Internet about the comparative security of Microsoft Windows and Linux-based operating systems. Many people have vested and biased interests in their positions on the matter. Misconceptions born of incomplete knowledge and logical fallacies contribute to the con
IBM DB2 Cube Views enables information on demand
Online analytical processing (OLAP) is a technique for summarizing and interrogating data along multiple dimensions. As such, it is a valuable tool for any organization that must make sense of a large volume of data quickly. (pdf)
How Do I…Navigate XML with the XPathNavigator?
This sample illustrates how to navigate XML documents with an XPathNavigator created from an XPathDocument. It also demonstrates how to use an XPathNodeIterator. The XPathNavigator class provides a cursor-style model to navigate an XML document. This topic also introduces XML Path Language (XPath) e
Windows Presentation Foundation Data Binding: Part 1
(Shawn Wildermuth) Windows Presentation Foundation (formerly Avalon) introduces a profound new way to develop user interfaces for rich clients. For the first time, WPF separates design of the user interface from the code. This separation means that, much like ASP.NET, your markup is typically in one
Understanding Garbage Collection in .NET
(Joydip Kanjilal) Garbage Collection is a technique introduced in Microsoft .NET that manages memory automatically. This article discusses the concepts of Garbage Collection and the strategies adopted by Microsoft .NET for handling managed memory efficiently. It also discusses the methods and prop