|
Database Management & Programming News, Articles & Tutorials for Database Administrators
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.
Disaster Recovery and the Big Data Application 01/16/2014
Ask database administrators how they implement disaster recovery in their big data environments and you'll get two typical responses: DR plans are not necessary and backups will take up a lot of space and recovery will take too long. Despite this reasoning, a disaster recovery plan for your big data implementation may be essential for your company's future.
Converting Between Data Types in MySQL 01/13/2014
There are a lot of occasions for converting one data type to another in MySQL. All of these can be achieved using MySQL's native CONVERT() and CAST() functions. Read on to learn how to use both.
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.
Oracle Unveils Big Memory Machine to Support In-Memory Databases 09/23/2013
Oracle CEO Larry Ellison kicks off OpenWorld with new hardware and software releases.
More Database News...
|
