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

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.

Oracle: Can Adaptive Cursor Sharing Plans Depend On Execution Order? 11/24/2014

Adaptive cursor sharing is a great feature that can tailor execution plans to bind variable values.  Read on to see how it behaves when query order is reversed and if it chooses 'bad' execution plans.

Lead and Lag Functions in SQL Server 2012 11/20/2014

Arshad Ali discusses how to use CTE and the ranking function to access or query data from previous or subsequent rows. He also shows you how to leverage the LEAD and LAG analytics functions to achieve the same result without writing a self-join query using CTE and ranking function.

IT Budget Planning for Big Data 11/17/2014

Big data software, hardware, application suites, business analytics solutions ... suddenly, it seems, IT enterprises are deluged with vendor offerings that solve problems it didn't know it had. As you dive into what will most likely be your largest IT project of the year, ensure that you have planned and budgeted for the following items that are unique to big data implementations.

Oracle: Deferred Segment Creation And Tablespace Restrictions 11/13/2014

Oracle offers Deferred Segment Creation for tables and indexes, which allows users with no access to a tablespace to create tables and indexes successfully.  Read on to see why this is a problem.

Manage your MySQL Data on the Go with Navicat Cloud and iOS 11/10/2014

Gone are the days that a Database Administrator (DBA) spends his or her time between a desktop workstation and database server(s). Today, DBAs require tools that will allow them to perform administrative tasks wherever they may be and lately, the trend has been towards applications specifically targeted to mobile devices, since that is what people always have with them.

Database News

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.

Google Releases Cayley Open-Source Graph Database 06/27/2014

Cayley will be used to help Google continue to refine the idea of linking data together in graph databases, including Google's Knowledge Graph.

Database Monitoring Key to Reducing Security Breaches 06/13/2014

Only 48 percent of respondents to a recent survey indicated that they test or validate third-party software to ensure it's not vulnerable to SQL injection.

Oracle Launches In-Memory Option for 12C Database 06/10/2014

The 12C In-Memory Option is aimed at enabling ISV applications to accelerate performance by orders of magnitude for several use cases.

Review: Microsoft SQL Server 2014 05/29/2014

Integration with Microsoft's Azure and new business intelligence and Big Data tools are among the most striking features of SQL Server 2014, finds reviewer Paul Ferrill.

Oracle Expands Open-Source High-Availability with MySQL Database Fabric 05/27/2014

MySQL Fabric is a new open-source tool included in MySQL Utilities 1.4

Big Data Survey: Big Data Growing Quickly 05/22/2014

A survey of Big Data professionals indicates that, while confusion remains, the market sector is growing quickly.

More Database News...

Recent Headlines
How to Maintain Enterprise-Level Service with Oracle Standard Edition 11/26
Oracle: Can Adaptive Cursor Sharing Plans Depend On Execution Order? 11/24
Oracle: Deferred Segment Creation And Tablespace Restrictions 11/13
Lead and Lag Functions in SQL Server 2012 11/20
Monitoring Azure SQL Database 11/06
Removing Rows with the DELETE Statement in SQL Server 11/03
MS Access
IT Budget Planning for Big Data 11/17
Preparing Your Enterprise for Big Data 10/16
Integrating Big Data into the Enterprise Data Warehouse 09/15

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