Database Management & Programming News, Articles & Tutorials for Database Administrators
Big Data Quality Metrics 04/17/2014
Big data applications and their associated proprietary, high-performance data stores arrived on the scene a few years ago. With promises of incredibly fast queries, many IT shops implemented one or more of these combination hardware and software suites. However, few IT enterprises have implemented metrics that clearly measure the benefits of these systems. The expected monetary gains from big data applications have not yet materialized for many companies, due to inflated expectations. The solution: Measure resource usage, and use these measurements to develop quality metrics.
Enhance Your MySQL XML Import Procedures using Prepared Statements 04/14/2014
In the Importing XML Data into MySQL Tables Using a Stored Procedure article, Rob Gravelle outlined some ways to work around MySQL's restrictions on stored procedures to import XML data into your MySQL database tables. Today's article covers how to use a Prepared Statement, including error handling and validation, as well as handling additional XML formats.
Oracle 11.2 Outer Join And Index Issue 04/10/2014
With a product as complex as Oracle some bugs are bound to be present. Some of these bugs are show-stoppers, and others aren't, but it does teach you to pay careful attention to the results a query delivers. Even though queries are syntactically and logically correct you can't be certain that Oracle won't do something 'behind the scenes' that can produce the wrong answer.
Microsoft Azure SQL Database Security - Firewall Configuration 04/07/2014
Marcin Policht reviews security related challenges of Microsoft Azure Software as a Service-based SQL Database, focusing in particular on the SQL Server and database-level firewall access control functionality and methods that can be employed to implement it.
SQL Server 2014 In-Memory OLTP Dynamic Management Views 04/03/2014
Greg Larsen provides a quick primer of the new Dynamic Management Views (DMVs) to help you better understand and manage your In-Memory OLTP tables and your Instances that support In-Memory OLTP tables.
An RMAN Catalog: Right or Wrong? 03/31/2014
Do you really need an RMAN catalog to successfully recover your Oracle database? There are those that think so -- but they would be wrong. Read on to find out what you need to recover your database without a catalog.
MongoDB 2.6 Improves Open-Source Database Performance 04/08/2014
Index Intersection, text search and performance gains land in MongoDB 2.6 release
Percona Aims at MySQL Leadership by Hosting Conference 04/04/2014
After taking over from O'Reilly Media, Percona is positioning itself as an industry thought leader by owning the MySQL event.
Delphix Updates Its Stand-Alone Data Virtualization Product 04/01/2014
NEWS ANALYSIS: Delphix stands alone as a data virtualizer and as a result is owning a new sector that more and more large enterprises are discovering.
6 Steps for Fighting SQL Injection 03/25/2014
Database usage is on the rise, as well as the applications that interconnect databases, meaning that SQL injection should still be a top concern for IT security pros.
Trustwave Taking Aim at Database Security 03/03/2014
A Trustwave security researcher details database security issues and defensive techniques.
Cloud Database Startup NuoDB Gets $14.2 Million Investment 02/28/2014
NuoDB is a single, logical database that can be deployed via the cloud in multiple locations simultaneously.
Tesora Launches to Focus on OpenStack's Trove DBaaS 02/14/2014
The name change from ParElastic to Tesora signifies the company's commitment to the OpenStack Trove database-as-a-service (DBaaS) project.
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.
More Database News...