The XML classes in the .NET Framework provide a comprehensive and integrated set of classes, allowing you to work with XML documents and data. XML classes in the .NET Framework can be broken into several groups: parsing and writing XML with the XmlReader and XmlWriter, validating XML with the XmlVal
Author: SSWUG Research
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.
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.
Identify and delete duplicate data from a table
(Randy Dyess) Article that explains the basics of identifying and deleting duplicate information from your database.
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.
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 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.
Oracle, Unisys Team on $1 Billion Transportation Security Deal
Oracle Corp. and Unisys Corp. have been chosen by a newly formed Homeland Security agency to construct a single online portal for consumers and airline personnel to report security incidents relating to airlines and other transportation systems.
Issues with Implementing UNICODE for DB2 in UNIX ODBC
Think you can get UNICODE support from IBM’s DB2 ODBC driver on UNIX? Nope. In order to provide UNICODE support for a database, the driver must both support UNICODE and be compatible with the database. Learn more here.
IOUG Live! 2003: The Week in Review
David C. Kreines summarizes the week, focusing on what makes IOUG Live! such a unique event. Read about what he calls “an incredible opportunity to learn, share experiences, and interact with your fellow Oracle professionals.”