The W3C has released a Candidate Recommendation of XML 1.1, with changes to control-character and Unicode normalization handling.
Other News
XML and Database Mapping in .NET
by Niel Bornstein – The designers of the .NET runtime put a lot of thought into the issue of binding XML to a database. The path from XML to database and back again starts with ADO.NET, .NET’s database persistence layer, which can be thought of as analogous to Java’s JDBC.
Test DataBase Generation and Management
This White Paper discusses the issues and options involved in the creation of small referentially correct versions of large Oracle databases.
Keep track of who logs on and how many times per month
by John Bechtle – Do you want to track statistics on the number of times your Oracle database is logged on to, or do you get queries about when is the last time some particular account accessed the database? This trigger will update the database keeping statistics on who logs on to the database and
Build Apps that Provide Real-Time Information and Customized Content Using SQL Server Notification Services
By Mark Brown – Here the author provides an architectural overview of the core features that make up SQL Server Notification Services. Along the way he discusses how they can be used for pushing Web content.
Comparing Data Sets with SQL
Learn how to use SQL to compare two sets of rows, from either the same or different tables.
Oracle SQL*Plus Pocket Reference, 2nd Edition
By Jonathan Gennick – The new 2nd edition of our Oracle SQL*Plus Pocket Reference includes many new features for Oracle9i. It also adds sections on basic SQL: INSERT, DELETE, UPDATE, SELECT, and transaction management. The pocket reference size is especially appropriate for this particular subject,
SQL Server Celebrating Its 10th Anniversary
By Brian Moran – SQL Server marks its 10th anniversary in December. Readers can help us celebrate by sharing their memories–wacky or wicked–of SQL Server’s past.
Microsoft SQL Server 2000 DBA Survival Guide: Second Edition
Book review from SQL-Server-Performance.com – Only the most successful SQL Server books made it to a second edition, as most are outdated (due to new software versions) long before there is time for a second edition to be written. One of those exceptions is Microsoft SQL Server 2000 DBA Survival Gui
Microsoft Security Bulletin MS02-061 : Elevation of Privilege in SQL Server Web Tasks
Who should read this bulletin: System administrators using Microsoft® SQL Server™ 7.0, SQL Server 2000, Microsoft Data Engine (MSDE) 1.0, and Microsoft Desktop Engine (MSDE) 2000.