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
» Slideshows
» 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

Unique Records In Oracle 02/11/2016

There are several ways to ensure unique records in an Oracle table, but are some better than others?  Read on to see how each method compares.

Searching on JSON Values in MySQL 7 02/08/2016

The MySQL 5.7.7 JSON Lab release introduced a native JSON datatype, which opened the door for handling JSON data in ways that were previously impossible. Several new functions assist in the selecting of data from a JSON document. We covered a few of them; in this article Rob Gravelle shows you some additional functions for searching on JSON values in MySQL 7.

Introduction to Azure SQL Database Elastic Database Pools 02/04/2016

Traditional deployments of Azure SQL Database involve identifying projected resource requirements and selecting individual Azure SQL Database instances. For fluctuating workloads, this frequently results in over- or under-provisioning. To address this challenge, Microsoft offers another approach to sizing Azure SQL Database that relies on Elastic Database Pools. Read on to learn more.

Exploring SQL Server 2016 Always Encrypted – Part 4 – Encrypting Existing Data 02/01/2016

Greg Larsen explores the different ways that you can encrypt your existing confidential data using Always Encrypted Columns in SQL Server 2016.

Exploring SQL Server 2016 Always Encrypted – Part 3 – Differences between Deterministic or Randomize Encryption 01/25/2016

In this third article of the exploring SQL Server 2016 Always Encrypted series, Greg Larsen looks at the differences between an Always Encrypted column that uses an encryption type of Deterministic and those that use encryption type of Randomized.

Oracle's ANSI Join Syntax Can Result In Wrong Results 01/21/2016

Oracle can still have issues with ANSI join syntax, producing sub-optimal translations and possibly wrong results.  Read on to see how Oracle processes ANSI join syntax and how that translation process can create some problems.

Database News

Oracle MySQL 5.7 Database Nears General Availability 10/19/2015

Dell Updates Toad DB Tool Lineup for Collaboration 06/23/2015

Toad lineup now offers support for SAP's HANA in-memory database, as well as improved capabilities for IBM DB2 and Hadoop.

Microsoft SQL Server 2016 Public Preview Boosts Database Security 05/28/2015

On-premises or in a cloud-hosted virtual machine, organizations can now take an early version of the company's next database for a spin.

Google Launches Managed Cloud Database Service 05/06/2015

The technology behind Cloud Bigtable is the same one powering Gmail and other Google apps.

More Database News...







Recent Headlines
Oracle
Unique Records In Oracle 02/11
Oracle's ANSI Join Syntax Can Result In Wrong Results 01/21
Memory Leak in 11.2.0.1 on AIX: Shared Cursors Are Not Behaving 01/11
more...
MS SQL
Introduction to Azure SQL Database Elastic Database Pools 02/04
Exploring SQL Server 2016 Always Encrypted – Part 4 – Encrypting Existing Data 02/01
Exploring SQL Server 2016 Always Encrypted – Part 3 – Differences between Deterministic or Randomize Encryption 01/25
more...
MS Access
more...
DB2
Load Testing Your Big Data Application 01/14
Big Data Performance Tuning 12/21
Integrating Big Data Applications into Operational Environments 11/23
more...