|
Database Management & Programming News, Articles & Tutorials for Database Administrators
Assigning Roles to MySQL Users 02/13/2014
Ever since Oracle became the owner of MySQL when it acquired Sun Microsystems in 2010, improvements to the software haven’t been as forthcoming as one might hope. There still doesn’t seem to be anything like groups in MySQL. According to Oracle, we can expect it to arrive for MySQL 7.0! Until then, this article presents a few software offerings that may help tide you over.
Oracle 11g and Index Access 02/10/2014
New index access paths in Oracle 11g and later releases can use existing multi-column indexes even when the column you're looking for isn't the leading column. Read on to see how Oracle accomplishes this feat.
Windows Azure SQL Database - Uploading Data by using SQL Server Integration Services 02/06/2014
Recently we presented a procedure for uploading data to a Windows Azure SQL Database from an on-premise SQL Server instance. Today we will accomplish the same objective by employing a more traditional approach to data extraction, transformation, and loading (ETL) that relies on SQL Server Integration Services (SSIS).
Natively Compiled Stored Procedures with SQL Server 2014 02/03/2014
With the new SQL Server 2014 In-Memory OLTP tables, stored procedures can be natively compiled and can improve performance. Read on to learn more.
Oracle 11g: RMAN Cloning 01/27/2014
Using RMAN to clone a database is old hat to a lot of folks. But for some, it can be a daunting task. Here's a refresher on cloning using RMAN.
Getting Starting with Change Data Capture (CDC) in SQL Server – Part 1 01/20/2014
Starting with SQL Server 2008, two different in-built mechanisms identify DML changes at the source table so that only changed data sets can be considered for data pulled from the source table to load into the data warehouse. These two in-built mechanisms are Change Data Capture (CDC) and Change Tracking (CT). Read on to learn more.
VoltDB Launches Version 4.0 of Its In-Memory Operational Database 01/30/2014
VoltDB adds enhanced analytics, expanded integrations, MySQL migration and more to VoltDB 4.0, the latest version of its in-memory database.
MariaDB Open-Source Database Gets Enterprise Release 01/24/2014
MariaDB gets an enterprise edition.
SGI Developing In-Memory Database Appliance for SAP's HANA 01/16/2014
The new SGI appliance will run high-volume databases in DRAM and provide up to 200 times the performance of flash memory.
Neo4j 2.0 Aims to Bring Graph Databases to the Masses 01/15/2014
Neo Technology launches the Neo4j 2.0 graph database with an eye on the broader market.
Oracle DB, Middleware Now Deployable on Verizon Cloud 01/10/2014
Cloud-service customers can bring their Oracle licenses to Verizon or purchase Verizon cloud services, which already include Oracle licenses.
MongoDB Offers Certifications for Developers and DBAs 10/30/2013
MongoDB has announced a new certification program for developers and database analysts that work with the MongoDB NoSQL database.
Why Graph Search Is Moving Databases to a New Level 10/16/2013
NEWS ANALYSIS: Open-source database features the most far-reaching search IT since Google started ranking Websites more than a decade ago.
MongoDB's $150M Funding Signals 'Tectonic Shift' in Database Market 10/07/2013
MongoDB lands $150 million in venture funding in a move that indicates the NoSQL database is taking a toll on the big data world.
Oracle Options DB to Cloud, but Beware of the Fine Print 09/25/2013
NEWS ANALYSIS: Subscribing to an Oracle database in the cloud isn't as easy as swiping a credit card and paying by the drink.
Oracle MySQL 5.7 Moves Open Source Database Forward Faster 09/23/2013
A new development milestone release for open source MySQL 5.7 database offers improved performance and manageability.
More Database News...
|
