DatabaseJournal.com Staff

Oracle GoldenGate a quick real-time data integration product has the flexibility to move data between like-to-like, heterogeneous systems, different versions of Oracle Database, different hardware platforms, and between Oracle and non-Oracle databases. It easily achieves seamless replication of data between Oracle Database 10g and 11g. Performs real-time software, log-based change data capture (CDC), and moves […]

Managing backups and data recovery is complex no matter what environment you work in.  There are both short and long-term strategies you need to deploy, as well onsite and offsite backups.  Recent technology changes have improved and changed how we handle onsite backups.  However, these onsite solutions do not necessarily support long-term backup requirements. Your […]

Migrating to a new version of SQL Server should not be based on the desire to be on new technology.  Instead, you should base it on business requirements.   Migrations are costly therefore you want to make sure you get some value for the effort you spend migrating your application.   SQL Server 2008 comes with a […]

Hardware assisted backup and recovery isn’t something new but if you’ve never experienced how it works first hand you might want to stop by NetApp’s booth at this year’s IOUG Collaborate—happening between April 19-21, 2010. At NetApp’s booth you’ll be able to see how database backups can be done without impacting performance. Also showcased will […]

Apache’s CouchDB is not offering version 0.11 as it pushes forward towards a 1.0 release. CouchDB is yet another NoSQL database that is taking advantage of the uncertainty of MySQL and trying to get ahead of the curve—hitting a major milestone this week with their 0.11 release. This 0.11 release is said to be the […]

RethinkDB will be looking to provide a MySQL storage engine for solid-state drives. RethinkDB has just closed a round of funding from an impressive set of investors that include FriendFeed founder Paul Buchheit, Google VP Udi Manber, and YouTube founder Steve Chen just to name a few. Solid-state drives (SSDs) are making a huge push […]

There are several different types of data replication, each unique and having things it’s both good and bad for. There is SAN replication which is mostly used for high availability purposes, but depending on configuration may also be used for disaster recovery. Then there are three kinds of SQL replication: transactional, merge, and snapshot. Choosing […]

SQL developers, no matter which relational platform they’re coding on, all face the same problems in keeping up database performance. Some of these problems result from getting stuck in particular methods, not exploring other methods, queries only running well on test data, or production issues not taken into account when the code was written. Of […]

Brad’s guide to SQL Server Maintenance Plans is aimed at keeping your servers in optimal condition—using SQL Backup Pro to create better backups. Optain a free copy of the eBook “Brand’s Sure Guide to SQL Ser4ver Maintenance Plans” to give you a leading edge by: taking a comprehensive tour of the SQL Server Maintenance Plan […]

In a benchmark conducted by ITTIA, ITTIA showed that ITTIA DB beat out SQLite in the critical areas of insert, update, and select statements. In there tests, ITTIA actually found out that ITTIA DB SQL actually out performed SQLite in nearly every case—utilizing such features as write-ahead logging to give additional boosts in throughput by […]

The launch of SQL Server 2008 R2 Community Tour at the PASS European Conference 2010 in Neuss, German, April 21-23. Said PASS President Rushabh Mehta “As the world’s largest user-run SQL Server community, we are thrilled to host the official R2 launch kick-off at our popular European Conference,” and that “Our attendees will be learning […]

The Oracle WebLogic Server, component of Oracle Fusion Middleware, along with Oracle Database 11g running Oracle Enterprise Linux and Dell PowerEdge R910 Server, holds a few world records. Achieved was the single-node SPECjAppServer2004 industry standard benchmark(1), multi-node(2), and dual-node(3) along with delivering the highest performance per core(4) of any result ever published. Juan Loaiza, senior […]