by Eric van der Vlist – The links between the XP and XML communities were covered last year in an XML.com article by Leigh Dodds, “XP Meets XML”. I will cover the technical relationships between XP and XML in the remainder of this article.
Community
XMLmind XML Editor Version 2.1 released
XMLmind XML Editor (XXE for short) is an XML editor featuring DTD and XML Schema aware editing commands and a word processor-like view configured using W3C’s cascading style sheets (CSS). See Features for more information.
Strategies to Reduce SQL Server Blocking
by Sancho Fock – Learn how to identify and reduce SQL Server blocking.
Converting from Access to SQL Server
By Eli Robillard – The document assists users migrating from Microsoft Access to Microsoft SQL Server. Though written specifically for users of GenericDB, the process may be applied to any Access database. Of particular note are the instructions to convert a Random Autonumber field to one whi
Getting the last inserted sequence value
By Venkat Arikatla – This function will return the last generated sequence value for a given table. It will work both for Oracle 8i and 9i
SAMPLE: How to Retrieve Data Using a SQL XML Query in ATL OLE DB
OLEDBSQLXML.exe demonstrates how to create an ATL OLE DB client that extracts an XML Stream from a SQL 2000 Server using a SQL XML Query.
Multi-Level Collections in Oracle 9i
Steven Feuerstein and Bryn Llewellyn continue their series of articles on new Oracle 9i features with both simple and complex examples showing you how to work with multi-level collections.
Hitachi, Oracle Ally on Storage Technology
Hitachi and Oracle have announced they will strengthen an existing alliance, creating a partnership focused on improving integration of database management and information storage. Their first product will be a software library that enables administrators to more easily find and extract Oracle data
Interact with SQL Server’s Data and Procedure Cache
(Randy Dyess) Article which briefly discussed SQL Server’s data and procedure cache and shows you the common Transact-SQL statements/command and system tables that you can use to interact with the cache through Transact-SQL.
SQL Server Magazine University (SSMU) e-Learning Center
Our instructors make the difference between textbook talk and real-life practical applications! Click here for the details.