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 Holiday Planning! 12/15/2014

Your big data repository won't simply add another twelve months of data over the next year. More data is coming, more categories of data will be created, and your analytical environment must expand to fit future needs. But size alone won't be your only problem. In the rush to accumulate a sufficient amount of valuable data and implement a business analytics environment that can produce usable results, several items may have been ignored, postponed, or simply forgotten. These missing details can make or break your company in the future.

Do You Really Need Oracle Optimizer_index_cost_adj Set? 12/11/2014

Performance is the watchword with a database and indexes can be a major part of that performance equation.  Oracle provides the optimizer_index_cost_adj parameter but do you REALLY need to set it differently than the default?  Read on to see what may happen when you do.

An Overview of the MySQL Performance Schema 12/08/2014

MySQL's Performance Schema provides a way to troubleshoot a lot of common performance issues without having to rely on specialized third-party solutions.  The fact that it uses regular SQL is also a big plus! Join Rob Gravelle as he explores the Performance Schema.

Using the MERGE Statement to Perform an UPSERT 12/04/2014

The term UPSERT has been coined to refer to an operation that inserts rows into a table if they don’t exist, otherwise they are updated. To perform the UPSERT operation Microsoft introduced the MERGE statement. Not only does the MERGE statement support the UPSERT concept, but it also supports deleting records. Greg Larsen discusses how to use the MERGE statement to UPDATE, INSERT and DELETE records from a target table.

Introduction to Azure SQL Database Scalability 12/01/2014

One of the primary advantages of Platform-as-a-Service (PaaS) solutions offered by Microsoft Azure is the ease with which scaling can be implemented. While SQL Database facilitates both vertical and horizontal scaling approaches, scaling it out is considerably more challenging. In this article, we will provide a high-level overview of both vertical and horizontal scaling methods available with Azure SQL Database.

How to Maintain Enterprise-Level Service with Oracle Standard Edition 11/26/2014

For business executives looking to save on information technology costs, it may seem like a win-win scenario in Oracle database environments to transition from Oracle Enterprise to Standard Edition. However, executives making this decision may not always be aware of or truly understand how transitioning from Enterprise to Standard Edition will affect the delivery of critical IT services, ultimately creating the potential to impact end user efficiency and revenue.

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
Do You Really Need Oracle Optimizer_index_cost_adj Set? 12/11
How to Maintain Enterprise-Level Service with Oracle Standard Edition 11/26
Oracle: Can Adaptive Cursor Sharing Plans Depend On Execution Order? 11/24
Using the MERGE Statement to Perform an UPSERT 12/04
Introduction to Azure SQL Database Scalability 12/01
Lead and Lag Functions in SQL Server 2012 11/20
MS Access
Big Data Holiday Planning! 12/15
IT Budget Planning for Big Data 11/17
Preparing Your Enterprise for Big Data 10/16

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