By Jo Ticehurst – Users should hold off deploying Microsoft’s next version of SQL Server until the first service pack because of major security concerns, analysts have warned.Yukon, the company’s next SQL release, is due next year, but analyst Gartner has said that it expects it to contain a
Author: SSWUG Research
XML Powers Document Builders
By Peter Coffee – Adobe’s FrameMaker 7.0 and Corel’s Ventura 10 ably handle Web document management tasks but miss some of the basics found in lowly word processors.
Updated release of XVIF
Eric van der Vlist announced version 0.2 of his XML Validation Interoperability Framework (XVIF), “including a partial implementation of Relax NG and a very partial implementation of W3C XML Schema datatypes”.
Case-insensitive enumerations
IBM’s own XML ace Doug Tidwell offers one curious reader an automated solution for defining a case-insensitive enumeration that’s straightforward, standards-compliant, and requires little work on the developer’s part. Several code samples are included.
Troubleshooting Replication Problems
Alexander Chigrik’s new replication troubleshooting checklist is the first resource you should consult when attempting to diagnose and solve replication-related issues.
Use SQL Server Triggers to Track Unauthorized Database Changes
What do you do when you’re tasked with determining the source of unauthorized modifications to your database? Use SQL Server triggers and let these useful procedures do the work for you.
Updating Columns from One Table to Another
How can I update three columns in table A from three columns in table B in one UPDATE statement? Check out the answer!
Installing and Configuring Oracle on the Solaris Platform
By Roger Schrag – This document will walk you through the steps of installing Oracle 8i Enterprise Edition release 3 (Oracle version 8.1.7) or release 2 (8.1.6) in a Sun Solaris SPARC environment. Everything you read in this document is hands on, roll-up-your-sleeves-and-get-busy material for Oracle
Tablespace Report from SQL*Plus
by Christopher Chelladurai – The following script lists all the tablespace names in the database with their type (whether permanent or temporary), extent management (whether local or dictionary), sizes, and status (online, offline, read-only). This script should be run by a DBA user in SQL*Plus.
DataDirect Tool Converts XML To SQL
By Peter Williams – DataDirect Technologies has launched software designed to cut time and complexity in transforming data between relational databases and XML for Java applications.jXTransformer is written entirely in Java and is aimed at web application architects and developers who conver