(Muthusamy Anantha Kumar) In certain environments, there will be multiple databases with the same structure. When Database Administrators make the same kind of changes or production releases on those databases it is tedious to open different windows in Query analyzer. In addition, it is tedious to o
Other News
Monitor, Control, and Extend with JMX
(Cameron O’Rourke) One of the most interesting and yet overlooked features recently added to the Java platform is Java Management Extensions (JMX). The purpose of JMX is to provide a standard interface for monitoring and controlling Java applications. But the JMX architecture is so flexible that it
Performance Monitoring, Part 1: It’s a Snap(shot)
(Roger Sanders) As you may recall from my recent columns, I always recommend that DBAs approach performance tuning in an organized manner with specific, realistic, measurable goals in mind. Otherwise, tuning becomes a hit-or-miss exercise. To improve database performance, you must first identify
Review of SQL2K Resource Kit
(Brian Kelley) The SQL Server 2000 Resource Kit has been out for a while now. Much like the various Windows Resource Kits, however, it’s still useful as a source of information. It’s one of the resources I keep handy on my bookshelf as well as on my workstation. In this review I’ll cover why. But si
InfoPath 2003 SP1 Preview
(Aaron Skonnard) The recently released InfoPath 2003 SP1 Preview provides a sneak peek at the InfoPath enhancements that will ship with Microsoft Office 2003 SP1 around the middle of 2004. The preview is packed with new features, others which improve the user experience and some which improve the de
Towards a Declarative SAX Framework : Part 1 – A Simple SAX-to-C#-Mapping
(Martin Friedrich) Over the last years XML has grown in importance when it comes to storing data on stream-oriented media. In most cases, DOM-API implementations are used to handle storing and manipulating data in memory. This article shows how to use an alternative API – the SAX-API – in a gene
Oracle8i DBA OCP Track to be Retired December 31, 2004
On May 1, 2004, the Oracle Certification Program announced plans to retire the Oracle8i Database Administrator Certified Professional track. All DBA OCP Candidates following the Oracle8i DBA OCP track will have until December 31, 2004 to complete the required core Oracle8i DBA exams in this track.
DB2 UDB Installation
(Thomas Bauch and Mark Wilding) In this sample chapter, you’ll learn the ins-and-outs of the installation process for DB2 UDB in the Solaris operating environment (with some discussion of other platforms), including distributed installation.
Oracle to DB2 UDB Conversion Guide
(Whei-Jen Chen) DB2 Universal Database (DB2 UDB) has long been known for its technology leadership. This IBM Redbook is an informative guide that describes how to migrate the database system from Oracle to DB2 UDB Version 8.1 on AIX, Linux, and the Microsoft Windows platform. This guide presents
How to enable SQL Server connectivity on Windows XP Service Pack 2
This article describes how to enable SQL Server connectivity on Windows XP Service Pack 2. By default, Windows Firewall is enabled on computers that are running Microsoft Windows XP Service Pack 2. Windows Firewall closes ports such as 445 that are used for file and printer sharing to prevent In