Installation of Oracle 9i server on Redhat 7.2 is the same as on Redhat 7.1, except for some really strange behaviour I experienced when the Database configuration assistant (dbca) was invoked, both as part of installation and later when I tried to invoke it manually. This combination is not certifi
Other News
Oracle to enhance channel strategy
By Ben Tudor – Oracle has increased its number of partners by more than 20 per cent and has almost doubled its sales through the channel. The firm has also boosted its channel programme by adding incentives for its partners.
Removing duplicate records from a table that has no primary key
By Prashant Dahalkar – There are situations where you may have to rethink queries to tackle complex problems. Here is one of them. We had a table in a SQL Server database called NAMELINK where no primary key was defined. The structure was as follows:
How to pass a list/array to an SQL Server stored procedure
By Vyas Kondreddi – Unfortunately, there is no built-in support for arrays in SQL Server’s T-SQL. This article provides 5 different techniques to simulate arrays in T-SQL, with working examples. It also provides you with links to additional information and books.
Adobe Jumps Gun on Microsoft’s Xdocs
By Ryan Naraine – Adobe rolls out two server-side products in a bid to get a headstart on Microsoft in the market for XML-based network publishing.
Tip: Basics of bootstrapping with DOM, Part 1
By Brett McLaughlin – This tip, the first in a series on bootstrapping with DOM, explains what bootstrapping is, explores the problems associated with it, and lays the basics for use in DOM Levels 1 and 2.
The .NET Schema Object Model
by Priya Lakshminarayanan – Despite the many articles explaining W3C XML Schema (WXS), it’s not enough to discuss WXS as a specification only. Educational materials should also discuss tools which aid the development of XML applications which employ WXS. This article focuses on an API in the .NET pl
How to Install Only the SQL Server Books Online
This article describes how to manually install SQL Server Books Online if they were not installed when the product was originally installed.
Microsoft SQL Server Audit
ClearData Consulting offers a one-day audit of your Microsoft SQL Servers to ensure secure, efficient systems. Our consultants will come on-site to monitor your system, perform system tests and interview your staff to look for possible ways to improve in the following areas:
Security and Parameterization
By Russ Whitney – Analysis applications frequently contain confidential information. Here’s a scalable way to use MDX to determine which users can access sensitive information.