This article demonstrates how to programmatically retrieve an XML data stream from a SQL Server 2000 mapping schema by using an XPath query. The scope operates in a client/server (2-tier) model. This sample also allows you to test XPath queries against the mapping schema. For each query, the tex
Other News
Best of the Rest (Important new features in 10g)
(Arup Nanda) Wow! This is the final week of our amazing journey into the most important new features for DBAs in Oracle Database 10g. Over these last 19 installments I have attempted to cover all the tools, tips, and techniques that have this fundamental appeal: making our jobs easier and more satis
Simplify Site Updates With Templates
(Dan Wahlin) Web developers have long faced the challenge of maintaining a consistent look and feel across a Web site. Several different types of approaches have been developed over time to meet this challenge, including the use of server-side include files, Cascading Style Sheets (CSS), XML combine
The DB2 Configuration Files Revealed
(Marin Komadina) IBM has provided us with an automated installation process. As a result, many DBAs do not have any overview of where DB2 has stored important configuration information. The DB2 configuration files contain security setting parameters, system resource allocation, backup environment va
XML Matters: Practical XML data design and manipulation for voting systems
(David Mertz) In this installment, David discusses his practical experiences developing interrelated XML data formats for the EVM2003 Free Software project to develop voting machines that produce voter-verifiable paper ballots. Some design principles of format subsetting emerge. In addition, Dav
Beyond T-SQL: Digging into the CLR
(William Vaughn) No matter what your job, if you work with SQL Server, you need to understand the Common Language Runtime (CLR), the engine that facilitates the execution of all managed code in the .NET Framework. The CLR is one of the most innovative additions to the next SQL Server release, SQ
How High? High Availibility for Linux
(Simon Harris) This article describes the software, tools and techniques adopted in a recent project to provide a highly available, high volume OLTP system based on the Linux operating system. This article describes at a high level how High Availability (HA) systems operate and pays particular a
The sp_reset_connection Procedure
(Brian Moran) SQL Server is executing a procedure, sp_reset_connection, that my code doesn’t call. What is sp_reset_connection? (R,$)
Creating a System Stored Procedure
(Robert Marda) In this article I will show you how you can make your own system stored procedure. Simply put, a system stored procedure is any stored procedure with a name that starts with sp_ that is found in the master database. These SP’s can be executed from any database and will run from th
It’s RAD – Recovery, Audit, Data migration plus – using a DB2 log processing tool
This session will discuss capabilities and uses of Log Master for DB2. In addition to discussing Recovery, Audit, and Data Migration capabilities, we will also discuss alternative uses, such as methods to reduce maintenance window outages. (R)