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

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.

Managing SQL Server Services with PowerShell 03/24/2014

PowerShell provides a command-line shell and scripting language (built in the .NET Framework) especially designed for administrative task automation and configuration management. Read on to learn how to manage Windows services related to SQL Server, either on a local machine or remote machine, using PowerShell cmdlets.

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
Load Testing in a Big Data Environment 03/20
Big Data: Integration with Little Data 02/17
Disaster Recovery and the Big Data Application 01/16