DatabaseJournal.com Staff

[From InterSystems Corporation] Cambridge, Mass. -September 30, 2008-InterSystems Corporation today announced that Management Information Tools, Inc. (MITS) will be offering its MITS Report product as an ad hoc reporting tool for the high performance InterSystems CACHÉ object database. MITS is a leading supplier of business intelligence (BI) and reporting tools for MultiValue (MV) databases. The […]

[From Sybase, Inc.] DUBLIN, CALIF. — OCTOBER 2, 2008 — Sybase, Inc., a provider of enterprise infrastructure and mobile software, today announced Mirror Activator, a disaster recovery solution for mission-critical databases, is now available through the EMC Select program. Through EMC Select, new and existing EMC SRDF (Symmetrix Remote Data Facility) and EMC MirrorView customers […]

[From Microsoft Certified Professional Magazine] SQL Server 2008 provides a feature, which, in my opinion, has been far overdue — backup compression. For too long, if you wanted the benefit of compressed backups, you had to look at a third-party tool. Now, backup compression is built right into SQL Server 2008, and what’s even better […]

[From Kroll Ontrack] Minneapolis – Sept. 30, 2008 – Kroll Ontrack, a provider of data recovery and legal technologies products and services, today announced it expanded and improved its Ontrack Data Recovery service capabilities beyond Microsoft Exchange, SharePoint and SQL databases to now include independent support for Oracle systems. This enhanced support provides Oracle-using enterprises […]

[From ComputerWeekly] It all seemed so simple. Your network team had implemented a deperimeterisation plan. They had protected what they thought were their most valuable assets: the credit card database, the Active Directory server, and the accounting system. So why had their customers’ credit card details just been found on a Russian server? The team […]

[From Builder AU] STS is a part of Oracle 10g’s SQL Tuning Advisor feature. Each tuning set contains one or more SQL statements, plus the context information needed to interpret them correctly. A tuning set is used as input to the SQL Tuning Advisor, which examines the statements and makes recommendations for improving them. The […]

Four new webcasts are scheduled for October, covering such topics as “Add Business Intelligence to Service Oriented Architecture Applications”, “Addressing Compliance with SQL Server 2008” and more. MSDN Webcast: Add Business Intelligence to Service Oriented Architecture Applications (Level 100) Wednesday, October 01, 2008 11:00 AM Pacific Time Learn how to add business intelligence to Service […]

>>Script Language and Platform: SQL Server 2000This code will loop through all user tables in all databases and grant select permissions on each table. It will add the user from the variables set at the beginning of the script if the user does not already have access to each database. This script can be modified […]

[From Internetnews] Oracle’s competition is rejoicing over the company’s announcement of the HP Oracle Database Machine, unveiled with much fanfare at Oracle OpenWorld 2008 in San Francisco earlier this week. In announcing the product, Oracle (NASDAQ: ORCL) CEO Larry Ellison told a packed hall that the rapid proliferation of data has forced his company to […]

>>Script Language and Platform: Oracle Author: Raja Hyderali The Script lists the Session ID,Event Name,Time Waited on the Database. This Script is useful in identifying the resource intensive Queries. Can Be used on oracle 8i & 9i Databases. select se.sid,s.username,Se.Event,se.time_waited from v$session s, v$session_event se where s.username is not null and s.username not in (‘SYS’,’SYSTEM’) […]

[From SQL Server Magazine] Open-source databases have been available in the enterprise database market for several years now. Until recently, they didn’t come anywhere close to competing with the major database platforms such as SQL Server, Oracle, Sybase, and DB2. However, we are now seeing a proliferation of open-source databases in the enterprise database market […]

by Tom Slee Rich Internet Applications Once upon a time, there were two competing visions of computer applications. The powerful but aging desktop application had rich feature sets and history on its side. The energetic and brash but still scrawny web-based application had key benefits on its side such as ease of software updates, availability […]