DatabaseJournal.com Staff

by Alex Polishchuk Remote database administration (DBA) is one of hottest trends in the market these days. Numerous companies in various industries rely more and more on external database administrators to support their production, development and QA systems. These companies range from small size companies with less than a hundred employees to large size enterprises […]

[From Builder AU] Blocking occurs in SQL Server 2005 when one process has one or more records locked, while another process tries to acquire locks on the same set (or subset) of records. This causes the second process to wait until the first process is done so it can acquire the records; this can cause […]

[From Yahoo! Finance] CHICAGO–(BUSINESS WIRE)–The Independent Oracle Users Group (IOUG) is again hosting their annual educational event COLLABORATE 08: Technology and Applications Forum for the Oracle Community, April 13-17 in Denver, Colorado, with third-year co-hosts the Oracle Applications Users Group (OAUG) and the Quest International Users Group (Quest). The event is recognized as one of […]

[From Developer.com] The concept of object relational mapping (ORM) is not new. An ORM is a class (called an entity in this context) that has properties or fields that map to database columns. In this article, I will show you how easy it is to use LINQ to SQL to define an ORM, mapping a […]

[From PDAStreet] MSSQL to MySQL database synchronization software is easy to use and non destructive tool can convert large quantity database within minimal time. Database conversion service provides support to all versions of MSSQL database. The article continues at http://www.pdastreet.com/software/pdas/MSSQL-to-MySQL-Database-Migration-2008-3-5-pdastreet-pdas.html

[From Oracle Corp.] REDWOOD SHORES, Calif. 05-MAR-2008 05:00 AM Oracle today announced the general availability of Oracle(r) Secure Backup 10.2, Oracle’s high-performance tape backup solution for Oracle Databases and NAS storage devices. Oracle Secure Backup is a complete enterprise solution for centralized tape backup management with advanced features such as encryption, vaulting, and dynamic drive […]

by Joshua Savill Introduction Data synchronization has become an important part of many corporate information systems. Synchronizing high availability databases and setting up synchronization systems without single points of failure are two challenges that organizations face as they bring synchronization systems to the 24/7 requirements of modern data systems. Data Synchronization In data synchronization environments, […]

[From Highwire Development] As a thank you to Database Journal readers Highwire Development is offering it’s RAAS WorkFlow Manager for free! Generate SQL upgrade scripts. Standardize change management. Maintain version control. Implement product lifecycle security. Simply download the trial, then respond to the license key email you will receive with “I want it for free!” […]

[From PR Newswire] BARCELONA, Spain, March 3 /PRNewswire-FirstCall/ — DIA 20th ANNUAL EUROMEETING, Oracle today announced the introduction of Oracle(R) Remote Data Capture Onsite 4.5.3, the newest version of the company’s electronic data capture (EDC) solution designed to help life sciences organizations and contract research organizations (CROs) conduct clinical trials and studies more effectively and […]

[From Quest Software] LOS ANGELES, February 27, 2008 – Quest Software, Inc. (Nasdaq: QSFT), today announced its comprehensive support for Microsoft SQL Server 2008 through its portfolio of SQL Server-based products and domain expertise. Quest’s solutions help enable SQL Server professionals to gain control of their SQL Server environments, by simplifying administration, maximizing performance and […]

>>Script Language and Platform:Oracle This script checks the free space in the shared pool and when the size is very small executes an alter system flush shared pool. Author: ROBERTO HERNANDEZ ZIA CREATE OR REPLACE PROCEDURE flush_it ( pct_full IN NUMBER) AS — — Cursor definitions — CURSOR get_share IS SELECT SUM(sharable_mem) FROM sql_summary; — […]

[From FreeSoft] Uranium Backup is a backup utility for Microsoft SQL Server 2005, 2000, 7.0, 2005 Express, and 2008. It can backup SQL Server database to TAPE device, to CD or DVD, to local hard disk or network storage device. It supports zip data compression and AES 256 bit encryption. It has a powerful integrated […]