Database Management & Programming News, Articles & Tutorials for Database Administrators
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.
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...