(Philip Gunning) Regardless of how well a RDBMS performs, the monitoring of SQL statements and resources is required to ensure continued good performance and to identify problem areas. Using the information gathered, adjustments can be made to instance and database configuration parameters, physica
Other News
Start a Long Process from a Web Page Using XML Web Services
(Steve Sharrock) Once again, XML Web Services come to the rescue with a simple solution to the common problem of web pages that want to do some background processing on the server and yet still return to the client without waiting for completion of the process.
XML and Wireless Technologies: WML
(David Gulbransen) It took just a few years for XML to penetrate just about everywhere in the Internet. But the triumph of XML has continued even after that—to wireless technologies.
The Mutation error in Oracle Database Triggers
(Amar Kumar Padhi) The Mutating table error is a well-known problem encountered in development; most developers have come across this error. “ORA-04091: table is mutating, trigger / function may not see it”
MSSQL Server 2000 Reporting Services: Managing Reporting Services: Data Connections and Uploads
(William Pearson) In this article, we will introduce the Managing phase of the reporting lifecycle within the context of Reporting Services. Here, as well as in subsequent articles, we will examine our options for central management of the reporting function, from the perspective of the objects that
Six Steps to LCC@Home
(Kendall Grant Clark) Let’s review where we’ve been and where we’re going. In January I started this new column, Hacking the Library, by talking about dijalog lifestyles (“Geeks and the Dijalog Lifestyle”), my attempt to describe the challenges facing people roughly like myself who have one foot in
Expert tips for securing Oracle DBMS
(Robert Westervelt) While many companies think they’re being proactive with security, too many are addressing security at the application level rather than the database level, according Oracle security expert Arup Nanda. Nanda, 32, a Norwalk, Conn.-based DBA who runs Proligence, an Oracle consultanc
HOWTO: Configure MSDTC in a Windows 2000 Cluster Environment
After you install Cluster Server on Windows 2000 Advanced Server and configure Internet Information Services (IIS) or SQL Server, you may have to manually install Microsoft Distributed Transaction Coordinator (MSDTC) as a cluster instance. By default, Microsoft Windows installs MSDTC in the firs
Altering the size of a varchar column
(Craig Mullins) What is the syntex for altering the size of a varchar column in DB2? For example, from varchar(10) to varchar(20)? (R)
Measuring SQL Performance
(Christoffer Hedgate) One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. When you are working with a small site or home project you might not see a big difference, but when implementing systems with large amounts of users and h