by Jon Udell – When you need to store and display a modest amount of structured or semistructured data, it’s tempting to store it directly in an HTML file. I’ve used this strategy many times; undoubtedly you have too. The advantages and disadvantages of working directly with a presentation format ar
Other News
XML and SQL 2000 (Part 6)
By Marcin Policht – In the previous article, I explained the meaning of the “Allow posted updategrams” and “Allow template queries” options on the Settings tab of the Virtual Directory Properties dialog box in IIS Virtual Directory Management for SQL Server tool. I also presented examples of taking
BLOB Access Technologies
By Michael Otey – Microsoft provides several tools for working with BLOB objects. Here are seven of the most important BLOB access technologies.
Understanding Digital Asset Management
By Bernard Chester – The world of unstructured information management uses a number of different approaches, often with similar technologies, based on the target user and the problem to be solved. Document management (DM) and content management (CM) handle file-based information (often from scanning
A Primer on Content Manager V8 on DB2 UDB
The IBM DB2 Content Manager family of products is a scalable, extensible, high performance solution that provides the features and functions to meet information integration requirements. This paper describes IBM DB2 Content Manager for MultiPlatforms V8.1 key concepts and data flow, and also discuss
WebSphere, DB2 Get the Power
By Brian Proffitt – Linux has been available for IBM’s Power architecture for some time, but until recently, there has not been an abundance of Power-ready applications for the 64-bit platform. That, however, all changed, with the announcement of WebSphere, DB2, and Tivoli Security availability for
SQLXML 3.0 SP2
SQLXML enables XML support for your SQL Server Database. It allows developers to bridge the gap between XML and relational data. You can create XML View of your existing relational data and work with it as if it was an XML file.
Fix Slow Connections and Query Failures
Microsoft released two hotfixes for SQL Server. The first fix corrects a problem of slow connections to Analysis Services. The article “FIX: HTTP Connections to Analysis Services Server Computers Running Windows Server 2003 Are Slow” explains that HTTP connections to Analysis Services server compute
Integrating SQL Litespeed with your existing backup infrastructure
Written By: Jeremy Kadlec – Needless to say, backups are one of the most critical aspects of a SQL Server environment and a Database Administrators (DBA) last line of defense to resolve a critical problem. As a DBA, how many times have backups saved you? Even with numerous advancements with RAID and
Using entity references
by Brett McLaughlin – XML is primarily a static language. However, by using entity references, you can perform a limited amount of dynamic substitution. This tip explains how to use entity references, and illustrates their usefulness.