With this guide, the authors set an ambitious course to help professional programmers understand the architecture of XML Web services and implement the right solutions by creating and consuming best-of-breed XML Web services.
Other News
XSLT 2 and Delimited Lists
by Bob DuCharme – As part of his work as the editor of the XSLT 2.0 specification, Michael Kay has been prototyping the new features of XSLT 2.0 and XPath 2.0 in a separate development branch of his well-known Saxon XSLT processor. As I write this, his most recent prototype release is 7.4. (His reco
Compare XML Data Access APIs
by Greg Ewing and Jon Rauschenberger – The .NET Framework includes several new data access APIs, each of which has varying levels of support for accessing data residing in SQL Server as XML. Selecting the right API for your needs can make a big difference in how your solutions perform and how much c
The comparison of SQL Server 2000 with Access 2000
Often people in newsgroups ask about some comparison of Access and SQL Server databases. In this article, Alexander Chigrik shows you the differences.
IBM Utilities vs. Third Party Tools for DB2
In order to make the DBA’s job quicker and more professional, many database administrators are using third party solutions. At the same time, IBM is working hard to improve their own tools. Marin Komadina lines them up, giving us the pros and cons to each.
Users Take Open-Source Databases for a Spin
(John Cox) High-volume database updates, which are the essence of transaction-processing applications, remain anchored on products such as Oracle’s 9i and IBM’s (NYSE: IBM) DB2 Universal Database, and increasingly Microsoft’s (Nasdaq: MSFT) SQL Server. But there are a host of new application areas t
IBM offers fast track to DB2 v8 certification
By Ellen O’Brien – In response to the growing demand for database administrators and the emergence of increasingly complex IT environments, IBM has created new exams to accelerate DB2 v8 certification and recognize areas of DBA expertise.
Identify and delete duplicate data from a table
(Randy Dyess) Article that explains the basics of identifying and deleting duplicate information from your database.
Moving Transaction Logs to a Different Drive
You can move the transaction log by using SQL Server stored procedures for detaching and attaching the database. You need to detach the database, move the log file, then reattach the database.
Using the SQL Server INFORMATION_SCHEMA view
by Andew Novick – I recently answered a posting asking how to get the columns from the primary key of a table along with the column’s data type information. It turns out to be pretty easy to find. Everything needed is in the INFORMATION_SCHEMA views.