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 SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
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

Using the ROLLUP, CUBE, and GROUPING SETS Operators 03/02/2015

Greg Larsen discusses the ROLLUP, CUBE and GROUPING SETS operators. These operators are used with the GROUP BY clause and allow you to create subtotals, grand totals and superset of subtotals. Read on to find out more about these additional GROUP BY operators.

My Oracle Cup Overflows 02/23/2015

Overflow data in an index-organized table is usually put in its own tablespace.  Sometimes it isn't; read on to see what overflow data is and how to change where it's located.

Getting Starting with Database Engine Tuning Advisor in SQL Server – Part 1 02/19/2015

There are different techniques to optimize the performance of SQL Server queries but wouldn’t it be great if we had some recommendations before we started planning or optimizing queries so that we didn’t have to start from the scratch every time? This is where you can use the Database Engine Tuning Advisor utility to get recommendations based on your workload.

Another Look at Tuning Big Data Queries 02/16/2015

Most large organizations have implemented one or more big data applications. As more data accumulates internal users and analysts execute more reports and forecasts, which leads to additional queries and analysis, and more reporting. The cycle continues: data growth leads to better analysis, which generates more reporting. Eventually the big data application swells with so much data and querying that performance suffers. How to avoid this?

Oracle: MERGE 'Monkey-business' 02/12/2015

Odd errors can result in odd 'solutions', and Oracle has one for the MERGE statement.  Read on to see what it is and what it fixes.

Guarding Your Data against Cyber Attacks 02/09/2015

In this new era of heightened stakes comes an increased need for a comprehensive security strategy. Rob Gravelle takes a look at how cyber-threats have evolved and what you can do to thwart attackers.

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
Oracle
My Oracle Cup Overflows 02/23
Oracle: MERGE 'Monkey-business' 02/12
Oracle: The Nuts And Bolts Of Basic Compression 01/26
more...
MS SQL
Using the ROLLUP, CUBE, and GROUPING SETS Operators 03/02
Getting Starting with Database Engine Tuning Advisor in SQL Server – Part 1 02/19
Managing Azure SQL Database Authorization 02/05
more...
MS Access
more...
DB2
Another Look at Tuning Big Data Queries 02/16
Managing the Big Data Technical Staff 01/20
Big Data Holiday Planning! 12/15
more...









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