Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
Database Tools
SQL Scripts & Samples
» Database Forum
» Sitemap
Free Newsletters:
News Via RSS Feed

follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2

Database Management & Programming News, Articles & Tutorials for Database Administrators

Featured Database Articles

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.

Database News

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...

Recent Headlines
Oracle 11.2 Outer Join And Index Issue 04/10
An RMAN Catalog: Right or Wrong? 03/31
Oracle Parallel Processing: 'New' and Improved 03/13
Microsoft Azure SQL Database Security - Firewall Configuration 04/07
SQL Server 2014 In-Memory OLTP Dynamic Management Views 04/03
Managing SQL Server Services with PowerShell 03/24
MS Access
Big Data Quality Metrics 04/17
Load Testing in a Big Data Environment 03/20
Big Data: Integration with Little Data 02/17