DatabaseJournal.com Staff

[From Sleepycat Software] Sleepycat Software, makers of Berkeley DB – the most widely deployed application-specific data management software in the world with over 200 million deployments – today announced general availability of Berkeley DB XML, a native XML database built on the most advanced version of Berkeley DB ever engineered. Berkeley DB XML is designed […]

[From Oracle Corp.] As part of our continuing outreach to discuss Oracle’s commitment to PeopleSoft customers and to address any questions you may have, Oracle presents the first in a series of PeopleSoft Customer Town Hall Meetings. This is an opportunity to interact with Oracle Executive Vice President Chuck Phillips. During this audio-only presentation, Mr. […]

[From Secunia] A vulnerability has been identified in SQL Server, which can be exploited by malicious, local users to escalate their privileges on a vulnerable system. The vulnerability is caused due to a general error in the “CreateFile” API and an attack vector exists in SQL Server making it possible to gain the privileges of […]

[From InfoWorld] REDWOOD SHORES, CALIFORNIA – Oracle quietly released the second version of its Collaboration Suite e-mail and collaboration software at the end of June, a company executive said Wednesday. Release 2 of Collaboration Suite was made available through Oracle’s Web site on June 27, though the public announcement and marketing campaign kick-off are planned […]

[From MySQL AB] PORTLAND, ORE. – (July 7, 2003) – Two open source companies, Pogo Linux Inc., a Linux hardware vendor, and MySQL AB, developer of the world’s most popular open source database, announced today a partnership to build the first MySQL. database appliance, a pre-configured, fully-integrated hardware/software offering optimized for speed and value. The […]

[From internetnews.com] Oracle (Quote, Company Info) Wednesday said it has to readjust its timeline a bit as part of its $6.3 billion take over bid for Pleasanton, Calif.-based PeopleSoft (Quote, Company Info). The Redwood Shores, Calif.-based business software maker said it is extending the deadline on its latest offer for all of the common stock […]

The development cycle of a typical data warehouse or data mart includes various stages such as data requirement analysis, modeling, extraction, transformation, loading, report development and testing. This cycle typically involves a significant number of challenges such as extraction from different data sources, missing data, etc., which results in significant loss of time, developer productivity […]

[From atnewyork.com] IBM (Quote, Company Info) Wednesday made new overtures to the medium-sized business market, launching new software and financing facilities for that burgeoning segment, which is generally targeted at businesses with 100 to 1,000 employees. The announcement is the latest in a series the Armonk, N.Y. vendor has made regarding its WebSphere Express line, […]

[From EMS HiTech] EMS PostgreSQL Manager is a powerful graphical tool for PostgreSQL administration and development. It makes creating and editing PostgreSQL database objects easy and fast, and allows you to run SQL scripts, manage users and their privileges, build SQL queries visually, extract, print and search metadata, export data to 14 available formats and […]

by MAK Muthusamy Anantha Kumar Date stamping is a very common requirement in the IT industry for any data extract created. Through the DTS package with ActiveX script, it is very easy to date stamp a file. In this article, I am going to walk you through how to export a table to a date […]

>>Script Language and Platform: SQL Server This script generates a serial number with output. Suppose table APP contains different appointment types, and you want to genrate all distinct apptypes with serial number, this query will generate that output. Author: Vijay Dwivedi select a.apptype,count(*) from (select distinct apptype as apptype from APP where apptype is not […]

>>Script Language and Platform: MSSQL Server 2000, 7.0 This script identifies & displays the MS SQLSever databases physical device information,size,installed path & filegroup information. With the help of this script user will be able to view the SQLserver detailed device information. Author: Sushant Saha /* Purpose : The following script display detail SQLServer device information […]