(Arup Nanda) What tool do you use in your day-to-day DBA-related activities? It’s a question I asked recently in a user group meeting. The answers varied depending on the DBA’s work experience. Most senior administrators expressed a preference for simple command-line SQL*Plus (my personal favo
Other News
Kylix 3 for C++ and IBM DB2 UDB v8.1 on Linux
(Bob Swart) In this article, I will use Borland Kylix 3 for C++ on Linux to work with IBM DB2 Universal Database (UDB) tables. Kylix 3 produces native Linux executables, and is available for Delphi and C++ as a development language.
SQL MAIL and SQL Agent Mail using POP3 and SMTP
(Gregory A. Larsen) How many times have you had problems sending SQL MAIL or SQL Agent Mail from SQL Server because the Exchange server was taken down or not working? Have you ever tried to connect up SQL Mail and/or SQL Agent mail to Exchange through a firewall or across domains, only to find out t
How to troubleshoot connectivity issues in SQL Server 2000
This article can help you to resolve connectivity problems with Microsoft SQL Server 2000. This article contains descriptions of common connectivity problems and the steps that you can take to help resolve your connectivity problems.
You call that a standard?
(Martin LaMonica) There is a clear demand from customers for products that work together based on widely used standards. But Glushko contends that the standards process is stacked to favor large tech companies, which can control and ultimately benefit most from specifications that are ratified as 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
Oracle 10g Could Ease DBA Tedium, Users Say
(Marc L. Songini) Oracle Corp. users took stock of the company’s new 10g database, saying that the software’s automated management and self-tuning features could reduce the amount of drudge work they have to do. With 10g, Oracle has made strides in developing a database that’s easier to manage,
Web services programming tips and tricks: Extend JAX-RPC Web services using SOAP headers
(Richard A. Sitze) In this article, the author examines how JAX-RPC SOAP handlers process SOAP message headers. Specifically, he shows how a handler adds a SOAP header to an outgoing message and how a corresponding handler removes the SOAP header from an incoming message. In addition, he presents th
UBL: A Lingua Franca for Common Business Information
(Dale Waldt) The Universal Business Language ( UBL) is a language for capturing business information for use in integrating business systems and sharing data with trading partners. UBL was designed from the beginning to leverage the many vocabularies and experiences available in existing systems usi
Will a clustering index prevent an ORDER BY?
(Craig Mullins) Will a clustering index prevent an ORDER BY? (R)