by Javier Lozano – This is a paper written by Don Chamberlin, the father of SQL. It gives a nice overview of Quilt, a query language for heterogenous data sources. The paper goes through and explains how to use the syntax of quilt along how it can be modeled to a mimic a relational database. It has
Author: SSWUG Research
Concurrency Handling in Oracle: Preventing Locked Data
by Joe Lax – SQL Server and Oracle each have very different methods for maintaining data constancy when accessed by concurrent users. Oracle maintains a snapshot of the data, which prevents queries from hanging without stooping to "dirty reads." Find out how it works.
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.
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
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.
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,
Tip: Multi-pass XSLT
Transforms can often be made cleaner and clearer if executed in phases or passes. First some intermediate output is produced, and then this is further transformed into a final output form. There can even be more than one intermediate form. In this tip, Uche Ogbuji discusses ways of breaking down XSL
Using Web Services Effectively from the JavaTM BluePrints Program
Web services are a highly effective means of enhancing interoperability across heterogeneous platforms. The article Using Web Services Effectively, from the JavaTM BluePrints Program, describes enterprise application environments that benefit from Web service implementations. In this article the int
XMLSPY 5
Unleash the full power of xmlspy® 5 – the original XML Development Environment to fully support the designing and editing of all XML technologies; including XML editing and validation, Schema and DTD design, and XSL transformation. xmlspy® 5 builds on the success of the previous award-winning versio
Tablespace Usage – Revised
by Karen Kolbe – I picked this script off the internet 4-5 years ago. The previous version had created 2 views for the final select, but I have incorporated all the selects into a single statement.