by Joe Chang – Learn how a server’s CPU can affects its performance.
Community
Listen Software Solutions’ “How To” Series: Dynamic SQL
By David Nishimoto – The DBMS_SQL package can be helpful for executing dynamic SQL. Dynamic SQL can be either a DML (Dynamic Manipulation Language: select,insert,update,delete) or DDL (Data Definition Language: create table, create index, or create view).
W3C proposes XML encryption methods
By Paul Festa – The Web’s leading standards group proposed two recommendations for encrypting XML data and documents, a key development in the organization’s push to standardize technologies crucial to Web services.
Rift Threatens Web Services Security Spec
By Darryl K. Taft – An emerging rift among supporters of a proposed Web services security specification could slow the ratification of the standard and hamstring enterprises trying to settle on a way to make Web services transactions safer.
Changing Times
By Itzik Ben-Gan – With many calendars in use and varying ways of expressing times and dates around the world, keeping everything straight in your calculations could be a nightmare—but it doesn’t have to be.
True DBA blooper #3: Wildcard runs wild
By Sara Cushman – Sometimes a simple plan to save time can really backfire. In Oracle DBA Ron Horjus’ case, a mistake he made while implementing a new file path naming standard was so memorable, and miserable, that the details are vivid more than a decade later. At the start, Horjus simply intended
Microsoft patches up SQL Server
By Joris Evers – MICROSOFT POSTED A cumulative patch for its SQL Server 7.0 and 2000 database software late Wednesday, also patching four new vulnerabilities.Also affected are Microsoft Data Engine (MSDE) 1.0 and MSDE 2000, products often used with SQL Server, Microsoft said in security bull
Software Fixes Oracle Database Problems Through Log Analysis
By Tom Smith – Lumigent Technologies Inc. on Monday detailed Log Explorer for Oracle, software that identifies causes of data corruption and is used to recover critical business data by enterprises using Oracle databases.
Determining transactions per second
By Cory Brooks – When asked how many transactions per second were happening on each system, I realized that a quick approximation could be derived from the number of SCN changes per second as recorded in the logs, so I wrote the following code.
Dynamic SVG: Graphic Interactivity in a Browser?
by Nigel McFarlane – Go beyond simple point-and-click interactivity in your Web pages and see how dynamic SVG provides new ways for users to supply input. Download the Adobe SVG Plugin and then try the sample now.