DatabaseJournal.com Staff

[From Oracle Corp.] LAS VEGAS – COLLABORATE 07 16-APR-2007 05:00 PM Today at COLLABORATE 07, Oracle announced the Oracle Application Integration Architecture, an open, standards-based platform for business process management across Oracle, third-party and custom applications. As part of the Oracle Application Integration Architecture, Oracle is delivering pre-built integrations across Oracle ERP, CRM and industry […]

[From myLittleTools] myLittleTools has announced that DotNetPanel Software has joined their Vendors Partner Program. myLittleAdmin, a web-based management tool specially designed for MS SQL 2005, has been fully integrated with DotNetPanel 2.0.5. DotNetPanel users are now able to silently log into myLittleAdmin from their control panel in order to manage their databases. The article continues […]

>>Script Language and Platform: This script returns week numbers in current year. Author: bobozlobo SELECT ROWNUM week_in_year, TO_DATE(‘1.1.’ || TO_CHAR(SYSDATE,’yyyy’)) + ID, TO_DATE(‘1.1.’|| TO_CHAR(SYSDATE,’yyyy’)) + 6 + ID FROM ( SELECT (a1.id + a0.id) ID FROM ( SELECT 0 id FROM dual UNION ALL SELECT 1 FROM dual UNION ALL SELECT 2 FROM dual UNION […]

[From Intranet Journal] The development platform PHP continues to grow in popularity, becoming more and more of a powerhouse in 2007. Two new recent releases of PHP drive home the point that there is constant care and feeding of this platform by the open source community as usage continues to grow. For the non-programmer, PHP […]

by JP Vijaykumar Many times developers find it difficult to delete records from parent tables when child records reference those tables through foreign key (referential integrity) constraints. Constraints validate the data; without constraints, we are just storing invalid data. For a developer to identify and disable foreign key constraints is a difficult task. Most of […]

[From Help Net Security] PostgreSQL contains two vulnerabilities that could result in a Denial of Service or unauthorized access to certain information. PostgreSQL does not correctly check the data types of the SQL function arguments under unspecified circumstances nor the format of the provided tables in the query planner. The article continues at http://www.net-security.org/advisory.php?id=7316

[From Winnersh Triangle Web Solutions] The SQL Documentation Tool creates comprehensive technical documentation for Microsoft SQL Server 7.0, 2000 and 2005 (including Express Edition) databases. Reports are created in HTML, Microsoft’s HTML Help, RTF and plain text formats. The HTML format documentation can be viewed in any web browser. The HTML Help format documentation is […]

[From MySQL AB] CUPERTINO, Calif. — March 7, 2007 — MySQL AB, developer of the world’s most popular open source database, today announced the appointment of industry visionary Tim O’Reilly to its corporate board of directors. The company also announced that Dr. Jeffrey Pugh has joined its senior management team as vice president of engineering. […]

[From Quest Software] ALISO VIEJO, Calif., March 7, 2007 – Quest Software, Inc., today announced the results of the first PL/SQL Test-A-Thon, held last week at Oracle PL/SQL Programming Conference 2007 (OPP) in San Mateo, California. The PL/SQL developer-focused conference featured training on best practices, fundamental and advanced PL/SQL skills, and development using Toad® for […]

[From Microsoft Corp.] The SQL Server 2005 Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature introduced in the SP2 release of SQL Server Management Studio. The reports allow a database administrator to quickly identify whether there is a current bottleneck on their system, and if a […]

[From Jumpstart TV] Binary objects like Word documents, MP3 files, or any other non-data file can be challenging to load into SQL Server. In this presentation, Brian shows you how to use SQL Server Integration Services (SSIS) to load BLOB resume files into SQL Server by using the Import Column transform. The article continues at […]

[From BMC Software, Inc.] Building on 20 years of leadership in DB2 mainframe management and optimization, BMC Software today announced its support of IBM’s newly updated DB2 9 for z/OS offering as part of an ongoing drive to strengthen the integration of the mainframe within BMC’s Business Service Management (BSM) offering. BMC delivers BSM across […]