DatabaseJournal.com Staff

[From BakBone Software] SAN DIEGO, CALIFORNIA – June 11, 2003 – BakBone Software, a global provider of storage management software, announced today the release of a new NetVault Application Plugin Module (APM) for PostgreSQL databases. The new PostgreSQL APM allows IT Administrators to schedule backups of either the entire database or individual tables within the […]

[From ITWeb] Johannesburg, 10 June 2003] – With the theme of ‘Deriving Value from Oracle’, the annual South African Oracle User Group (SAOUG) conference, to be held at Sun City from 6 to 8 October at Sun City, is geared to provide maximum value for users of Oracle software across the board. According to Bryan […]

by Robin Schumacher Even though database vendors continue to proclaim the fact that they have “self-healing” databases, performance problems continue to plague many critical database systems. Added complexity in the database engines and a reduced DBA staff has added to the administrator’s burden of keeping databases up and running at a rapid pace. When troubleshooting […]

[From InfoWorld] IBM Corp. and partners will unveil at the Supercomm trade show in Atlanta next week an integrated system for carriers and organizations that want to manage and distribute multimedia content. The package is designed to make it easier and less expensive for enterprises or service providers to get a content network off the […]

Earlier in this series, we discussed Oracle streams framework and a simple Streams configuration. While Oracle Streams (new feature in Oracle 9.2.0) provides for multitude of functions such as messaging, event management, DML and DDL change capture from disparate databases etc., Change data capture (from Oracle 9.0) can be used only for DML operations on […]

[From Narayana Vyas Kondreddi] Microsoft released Data Transformation Services (DTS) along with SQL Server 7.0. A very powerful, easy to use, graphical tool for importing, exporting and transforming data, which is only available as a costly add-on in other RDBMS products like Oracle. Prior to SQL Server 7.0, all we had was BCP, which is […]

>>Script Language and Platform: MS SQL 2000 ,MS SQL 7.0 Get a specific weekday of a month by passing any date. –Usage explanation for Function Getting Second Tuesday of May/2003 by executing select dbo.UDF_getdate(2,3,’5/26/2003′) –Usage explanation for Stored Procedure Getting the fifth Friday of May/2003 by excuting exec usp_getdate 5,6,’5/1/2003′ –Both Function and Stored procedure […]

[From CyberAtlas] New license software revenue for relational database management systems (RDBMS) decreased 6.9 percent in 2002, totaling $6.6 billion in 2002 from revenues of $7.1 billion a year earlier, according to Gartner, who just completed a worldwide study. IBM led the vendor pack with its DB2 database, which accounted for 36.2 percent of new […]

[From Quest Software Inc. ] Quest Software, Inc. (Nasdaq: QSFT), a leading provider of application management solutions, today announced the release of Quest Central™ for DB2 version 3.0. With this release, Quest Software delivers the only complete and unified solution for the management of IBM DB2 Universal Databases (UDB) and that includes deep diagnostic capabilities […]

>>Script Language and Platform: Microsoft SQL Server For each user database, rebuild the indexes and update statistics. Instructions: Run against master, the script will use the system catalog to produce a list of databases If you want to excluce a database add the excluded db name to the ‘not in’ list below. There is a […]

>>Script Language and Platform: Microsoft SQL Server This script identifies the blocking locks at the top of the blocking chain and kills them. Specifically, it reports what the top blocking spids are doing, kills them, waits three seconds and then reports on current blocking status. Author: Cameron Michelis Download Script: block-sniper.sql Disclaimer: We hope that […]

>>Script Language and Platform: Microsoft SQL Server For each user database,this script will remove all the freespace and truncate the transaction log. Instructions: Run against master, the script will use the system catalog to produce a list of databases If you want to exclude a database add the excluded db name to the ‘not in’ […]