DatabaseJournal.com Staff

[From Apex SQL Tools] Apex SQL Tools has a new version of Apex SQL Diff, SQL Tools for database comparison and synchronization. Apex SQL Diff is a SQL Database Tool for comparison of both data and structure. Apex SQL Diff allows you to programmatically synchronize your databases. ApexSQL Diff is a SQL Database Tool that […]

[From Webyog Softworks Private Limited ] Webyog, has released SQLyog v4.0. SQLyog is available in two editions: SQLyog and Enterprise. SQLyog is FREE for personal and commercial use. SQLyog contains all features of SQLyog Enterprise – except the Power Tools: HTTP/SSH Tunneling Data & Schema Synchronization Notification Services ODBC Import For additional information please visit […]

By Tom Copeland There is an understanding in the database world that using a “SELECT DISTINCT” SQL query is not a good idea, because it is essentially getting duplicate rows out of the database and then discarding them. Usually it is better to rearrange the “WHERE” clause in the query to only get the rows […]

[From SQL Server Magazine] If you live in the United States, you likely had to remember to set your clocks back 1 hour last Sunday at 2 a.m. (except for those lucky folks in Arizona, most of Indiana, and Hawaii). By now, you’ve probably managed to change all your clocks–except that pesky one in your […]

[From Apex SQL Tools] Apex SQL Tools has a new version of Apex SQL Log, a SQL Tool for database auditing. Apex SQL Log is a SQL Tool that analyzes SQL Transaction Log to display information on data AND structure changes. Apex SQL Log reads Live Logs and backup files creating no overhead and can […]

[From Daffodil Software Ltd.] Gurgaon , India – November 3, 2004: Daffodil Software today announced the launch of One$DB, a free version of its Java database – Daffodil DB. One$DB is exactly the same as Daffodil DB, barring a few features such as Full Text Search, Persistent Stored Modules and Row Sets. In spite of […]

[From optadat@.com] What is eva/3® UDC? optadat@.com Entwicklung moderner System-Software GmbH, producer of eva/3 Application Builder, expands its product range with the eva/3 UDC. eva/3 UDC was designed to easy convert and port data between diverse databases at the push of a button. At the moment eva/3 UDC supports thirteen databases DB2, Oracle, Sybase, My […]

>>Script Language and Platform: Oracle This script will both alert and capture relavent data on Oracle SQL blocking locks events. The following script creates 2 procedures, and 1 new table (in place of TBS_AAAAA put in the tablespace you want in this table) and submits the proc to DBMS_JOB, running it at 10 minute intervals. […]

>>Script Language and Platform: Oracle Listed below is a very easy way to monitor for Space issues ( or insert any SQL here for monitoring for other needs and thresholds ). If any tablespace has less then 5% free then a page message is sent to the DBA cell phone. If any tablespace has 15% […]

by Paul Zikopoulos DB2 Universal Database (DB2 UDB) Version 8.2 became generally available in September 2004. This release includes lots of enhancements for developers: a Java2 Platform, Enterprise Edition (J2EE) certified and redistributable JDBC Type 4 driver, support for CLR-based stored procedures, WSDL generation in support of Web services with mere clicks of a button, […]

[From internetnews.com] European regulators are preparing to announce their position on Oracle’s hostile takeover bid for PeopleSoft, regulators said Friday. European Union (EU) antitrust chief Mario Monti said a decision in case is on the European Commission’s (EC) agenda for next Tuesday. That is two weeks earlier than the Nov. 9 deadline previously set to […]

[From NEOS, LLC.] (Manchester, CT) – NEOS, LLC.( www.neosllc.com), announced this week that it will be showcasing Vgo4Oracle, the recently released tool that speeds J2EE development on the world-class Oracle Application Server platform. This revolutionary software tool will be the center of attention at the NEOS exhibit area at the Oracle OpenWorld Conference taking place […]