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

Cartesian Joins in Oracle: The Nullable Column Problem 04/27/2015

NULL values in a table can cause Oracle to decide to use a Cartesian join with large data sets.  Read on to see one way this can be addressed.

CONCAT and STUFF Functions in SQL Server 2012 04/20/2015

The difference between the CONCAT function and the STUFF function lies in the fact that CONCAT allows you to append a string value at the end of another string value whereas STUFF allows you insert or replace a string value into or in between another string value. Read on to learn more about these functions and their real life usage.

Disaster Recovery and Big Data 04/16/2015

Big data applications are not usually considered mission-critical: while they support sales and marketing decisions, they do not significantly affect core operations such as customer accounts, orders, inventory, and shipping. Why, then, are major IT organizations moving quickly to incorporating big data in their disaster recovery plans?

More Than Oracle Knows What To Do With 04/13/2015

In Oracle 12c an interesting problem arises with ANSI joins, star expansion and tables with 500 columns or more.  Read on to find out what happens and how you can work around the problem.

Generating Reports on MySQL Data 04/09/2015

Rob Gravelle provides an overview of reporting tool types as well as some practical experience in report building using the reporting facilities of the Navicat for MySQL database administration GUI.

Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Preparing OS Image 04/06/2015

There are several different approaches to automating deployment of SQL Server Infrastructure-as-a-Service (IaaS) virtual machines in Microsoft Azure. Marcin Policht examines an approach that involves uploading or creating a custom operating system image, including a pre-staged SQL Server installation, which is well suited for scenarios where you want to deploy a custom-configured SQL Server instance to multiple virtual machines with minimal effort and maximum consistency.

Database News

IBM Opens Watson Analytics to Public Beta 12/04/2014

After an early beta of IBM's Watson Analytics pulled in 22,000 early testers, Big Blue is now opening the service to everybody.

Splice Machine Ships Version 1.0 of Hadoop RDBMS 11/19/2014

Splice Machine takes its Hadoop relational database management system (RDBMS) to general availability.

Amazon Claims New Aurora DB Engine Screams With Speed 11/12/2014

NEWS ANALYSIS: Aurora may become a formidable competitor for comparable database engines by MySQL, SAP, Oracle, Teradata and EMC.

OpenStack Juno Cloud Features Trove Database-as-a-Service Updates 10/12/2014

The upcoming open-source OpenStack Juno cloud platform will now support more databases and database features.

Couchbase Launches v3.0 of Its NoSQL Database 10/10/2014

Couchbase 3.0 introduces more than 200 new features and enhancements, including major extensions to its core architecture.

IBM Tweaks DB2 With BLU Acceleration for Big Data 10/03/2014

IBM has updated its DB2 with BLU Acceleration in-memory solution to handle transactional data as well as analytical workloads.

Microsoft to Cut Azure SQL Prices This Fall 08/27/2014

Microsoft is getting ready to slash prices by up to 50 percent after Azure SQL's new service tiers are made generally available next month.

Microsoft Entices Oracle Shops With SQL Server 2014 Migration Tool 07/25/2014

The company focuses on SQL Server 2014's in-memory capabilities in its bid to siphon enterprise database workloads from rival Oracle.

Oracle Big Data SQL Connects Various Data Sets for Analysis 07/16/2014

This can run a single SQL query on Oracle's own 12C database at the same time as in Hadoop and NoSQL data stores.

Couchbase Raises $60 Million to Fuel NoSQL Database Efforts 06/30/2014

 Investors continue to be confident in the prospects of NoSQL database technology.

More Database News...

Recent Headlines
Cartesian Joins in Oracle: The Nullable Column Problem 04/27
More Than Oracle Knows What To Do With 04/13
Hitting The Oracle Target 03/30
CONCAT and STUFF Functions in SQL Server 2012 04/20
Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Preparing OS Image 04/06
T-SQL Programming Part 13 - Selecting Data Using the TOP Clause 04/02
MS Access
Disaster Recovery and Big Data 04/16
Exploding the Myths of Big Data 03/16
Another Look at Tuning Big Data Queries 02/16

Thanks for your registration, follow us on our social networks to keep up-to-date