The XML Schema Working Group was tasked with adding the two most important pieces to the XML puzzle: Schema Definitions and a Data Type Libary. Criticism rises now as more and more people work with the resulting specifications, including XML Schema part 2: Datatypes.
Other News
The XMLPULL API
by Elliotte Rusty Harold – Most XML APIs are either event-based like SAX and XNI or tree-based APIs like DOM, JDOM, and dom4j. Most programmers find tree-based APIs to be easier to use, but they are less efficient, especially when it comes to memory usage. A typical in-memory tree is several times l
Microsoft’s JDBC Driver for SQL Server Stacks Up Against Competition
Microsoft recently released its SQL Server 2000 Driver for JDBC. Dr. Heinz Kabutz demonstrates how he put this Type 4 driver to the test against some other JDBC drivers currently available, including the JDBC-ODBC Bridge. He also explains why as a Java developer he’s so pleased to finally see this M
How to Interact with SQL Server’s Data and Procedure Cache
by Randy Dyess – As you have worked with SQL Server, you probably have run across the terms data cache and procedure cache, and may have wondered what exactly a cache was. SQL Server is configured to use a physical pool of memory on the server, and it will allocate the majority of this memory pool t
Help: ADO Truncates milliseconds from SQL Server Datetime columns
When I query a SQL Server Database using ADO 2.6 – the data from Datetime columns comes back WITHOUT Milliseconds.
Oracle’s Groupware Challenge
By Lori MacVittie – In early July, Oracle purchased Steltor, a small and relatively unknown groupware developer. Just a week later Oracle announced its intention to offer the suite as its own entry into the low-growth groupware arena.IBM’s Lotus unit and Microsoft have owned the groupware sp
.NET’s Seismic Shift
By Russ Whitney – You might not realize it, but the .NET shift is going to be a major seismic event. Use this overview to recognize the shift’s leading indicators and prepare for the changes it will bring.
Viewing Transaction Log
In this article, Alexander Chigrik shows you how to view the transaction log in SQL Server 6.5and 7.0. It’s not the complete transaction log but it does help you debug problems.
Review and Upgrade your Database Security
By Rich Niemiec and Kimberly Floss – The Oracle focus on database security goes back 25 years, to the first Oracle client, the CIA, on a project code-named “oracle.” With each version of Oracle, security continued to be a focus as more government and security-conscious companies selected Oracle as t
Working with hierarchical data in SQL Server databases
By Vyas Kondreddi – This article shows you how to process hierarchical/tree structured data in T-SQL and provides you with resources and advanced techniques for managing hierarchies in SQL Server.