(Lee Sherman) The Resource Description Framework (RDF) and Web Ontology Language (OWL) are important technologies driving development on the road to the semantic web. The former is a set of World Wide Web Consortium (W3C) specifications that provide a model for representing metadata through specific
Other News
When are named sets in the MDX Script evaluated?
(Chris Webb) Interesting discovery I made last week: I was tuning a cube and noticed that all my queries, when they were run on a cold cache, were much slower than I was expecting – even the most basic query seemed to take at least 40 seconds. After a lot of head-scratching I looked in Profiler and
LinkLabel Control and Hierarchies
(Sam Haidar) This short article shows a simple example of how to use the LinkLabel control to display a hierarchy of levels that can be clicked, such as folder names.
Planning to upgrade XSLT 1.0 to 2.0, Part 7: Selection of XSLT 2.0 features and the 1.0 shortcomings they address
(David Marston and Henry Zongaro) XSLT 2.0 introduces numerous new features, some of which are specifically designed to address XSLT 1.0 shortcomings. This article is an extension of the first article in the series, “Improvements in XSLT,” which presented some of the most highly desirable XSLT 2.0 f
FIX: A SQL Server assertion is logged in the Errorlog file when the Log Reader Agent runs for a transactional publication in SQL Server 2005
When the Log Reader Agent runs for a transactional publication in SQL Server 2005, a SQL Server assertion is logged in the Errorlog file. When this problem occurs, error messages that resemble the following are logged in the SQL Server 2005 Errorlog file: Date Time SPID Error: 17066, Severity: 16
How do I… Query foreign data using SQL Server’s linked servers?
(Susan Harkins) If you have a magic wand or a special relationship with some data fairy, all of your data is in the same database on the same server. Most of us aren’t that lucky. Sometimes, the data we need is a non-database format or resides on a different server. SQL Server is flexible enough to
The Fastest Reorganization Is No Reorganization
(Peter Plevka) With the number and size of DB2 database objects continually growing and the requirements of availability getting tougher every month, it is imperative to plan the reorganization of tables and indexes. This article examines options to consider for reorganization and automation, and it
WPF For The WinForms Developer: Part 2
(Ged Mead) WPF comes with a good selection of UI Controls, some of which will be familiar to you and some will be brand new. As you work with WPF in Visual Studio you will find that this happens often; there will be things that you are totally familiar with, some that are brand new and some where th
Sending e-mail from within Oracle
(James F. Koopmann) Sending e-mail from within Oracle can be of great benefit. Here is all you need to get a quick start at sending simple e-mails.
Paging in SQL Server 2005
(David Beahm) Developers and database administrators have long debated methods for paging recordset results from Microsoft SQL Server, trying to balance ease of use with performance. The simplest methods were less efficient because they retrieved entire datasets from SQL Server before eliminating re