DatabaseJournal.com Staff

This query displays the locking processes, all process information, the queries that the blocking processes are running, and the tables they are blocking. It has been tested and used on SQL Server 7.0 and 2000. Author: Matt Nachtrab Download Script: findbp.sql Disclaimer: We hope that the information on these script pages is valuable to you. […]

[From Symtrax] Symtrax Corporation is pleased to announce the launch of a dynamic multi-platform Business Intelligence tool – StarQuery. With ten years experience in the data analysis industry, Symtrax has leveraged all of its know-how in order to develop a comprehensive, user-oriented solution, which is also swift and secure. Integrated into MS Excel, StarQuery has […]

[From EMS HiTech] EMS HiTech company is pleased to announce PostgreSQL Manager for Windows 1.8 – the next version of our powerful PostgreSQL administration and development tool. The newest version of PostgreSQL Manager for Windows 1.8 is immediately available on the PostgreSQL Manager Download page. 1. The Extract Metadata Expert now builds scripts according to […]

by MAK [Muthusamy Anantha Kumar] In a typical development, QA or production environment, it can be very hectic to change all of the connection parameters, such as source file path, destination server name, table name, userID, password etc. in the DTS package when we move the packages from one environment to another environment. This article […]

In the previous articles, we gained a basic understanding of Oracle Warehouse builder architecture and became familiar with its various components. My previous articles on Oracle Streams implementation etc., simply served as pointers towards standard implementation scenarios for the developer community. However, here, before we go ahead with building an ETL prototype, I would like […]

[From Assoc. of Database Developers] The Association of Database Developers (ADD) has been formed to: To provide an international network of database developers so that anyone, anywhere can easily access quality database support and assistance. To establish an international network of database developers to share programming concepts, methods and procedures. The article continues at http://www.databaseassociation.com

by MAK [Muthusamy Anantha Kumar] DBAs are always running out of hard disk space when handling large databases such as data-warehouse databases and other VLDB. Backing up such databases to disk occupies more disk space, since Microsoft SQL Server does not have compression built into the backup process. SQL Server customers usually go for third […]

[From eWeek] Oracle Corp. faces mounting obstacles in its bid for enterprise application software rival PeopleSoft Inc. as more agencies look into the proposed hostile takeover and as PeopleSoft ratchets up its legal defense. Canada’s Competition Bureau has launched antitrust investigations that come on the heels of the U.S. Department of Justice’s continuing inquiry and […]

[From SearchDatabase.com] How to get information to end users at lightning speed is what Gary Moore of Baltimore-based Aegon USA Inc. is hoping to learn at this week’s Teradata Warehousing Institute World (TDWI) conference in Boston. Moore, a team leader for data warehouse investments at Aegon, a parent company of the Trans America Insurance Co., […]

[From Encirq Corporation] High Performance and Full Features in Less Than 50K SAN FRANCISCO – August 18, 2003 — Encirq Corporation today announced Encirq 3e Database Suite for Embedded Systems, a suite of technology, tools, and components for creating the world’s smallest embedded databases – often in less than 50K. With Encirq 3e, developers can […]

[From BMC Software] HOUSTON – (August 12, 2003) – BMC Software, Inc. (NYSE: BMC), a leading provider of enterprise management, today announced new SmartDBA data management solutions for Sybase and SQL Server databases. With the addition of SmartDBA Performance Monitoring Solutions for Sybase and SQL Server, BMC Software is providing DBAs with a single console, […]

[From CNET News.com] Oracle will next month take the first steps toward a utility computing plan by adding “grid” capabilities in its database and application server software. Oracle will unveil an update to its flagship database, renamed Oracle 10G, and its Oracle Application Server 10G at its OracleWorld customer conference in San Francisco next month. […]