(Paulo Morgado) This article will show you how to process XML sub-trees when using XmlReaders and XmlWriters in the .NET Framework 1.1.
Author: SSWUG Research
Oracle 10g Automatic Storage Management (ASM), Part 3: Advanced Features
(Jim Czuprynski) The previous article in this series presented complete demonstrations of how to set up an ASM instance in both Linux and Windows NT, as well as how to use Oracle 10g’s Enterprise Manager (EM) to monitor and manage an ASM instance. This article will focus on ASM instance administrati
Scripting Flickr with Python and REST
(Uche Ogbuji) Flickr probably needs no introduction for readers of this column. It’s a hugely popular social-network site owned by Yahoo, focusing on sharing of photographs. It embodies most of the the current web buzzwords, including tagging, web feeds, AJAX, and accessibility to scripts. Flick
Normalize Data Using Views and Triggers (2 of 2)
(Payton Byrd) This is a continuation of the previous entry. It was too long to fit in one entry!
We are getting closer to an End-of-Service data for DB2 Version 7
(Willie Favero) The number one DB2 Version 7 question I have been receiving lately is “When will DB2 V7 go out of service”. Up until now, I have been talking around the answer. However, on Monday (January 23, 2006), IBM finally gave a hint as to when V7 might actually go out of service.
Lesson 1 SQL Server 2005 Overview
(Vidya Vrat Agarwal) Microsoft SQL Server 2005 (code named “Yukon”) extends the performance, reliability, availability, programmability, and ease of use of SQL Server 2000. SQL Server 2005 includes several new features that make it an excellent database platform. It also includes many enhancements a
Checking and Enforcing Business Rules for SQL Data
(Dina Fleet Berry) With the use of the Internet as its own user interface, data enters the database via a number of ways: windows application, web application, and web service. It is no longer safe to put the business rules at the application level or expect the rules at the level to be implemented
The SQL Server service cannot start when you change a protocol parameter for a clustered instance of SQL Server 2000 or of SQL Server 2005 to a value that is not valid
In a clustered environment, when you change a protocol parameter for a clustered instance of Microsoft SQL Server 2000 or of Microsoft SQL Server 2005 to a value that is not valid, the SQL Server service cannot start. Additionally, you cannot change the protocol parameter back to the original value.
Database Impact of Collecting Statistics in Oracle
(James F. Koopmann) Oracle has given us a new parameter STATISTICS_LEVEL for collecting database statistics. Lets take a deeper look at what you can expect from your database system when this parameter is set and statistics are being gathered.
Boosting Performance with Indexes
This chapter covers Microsoft-specified objectives for the Indexing section of the Database Development SQL Server 2000 exam. (R, pdf)