Friday, 25 May 2018

Adaptive Query Processing in SQL Server


Adaptive query processing is the latest, improved query processing feature introduced in the SQL Server database engine. This method is available in SQL Server (starting with SQL Server 2017 (14.x)) and Azure SQL Database.

Wednesday, 23 May 2018

JSON Data Guide Enhancements in Oracle Database 18c

This article covers the enhancements to the JSON Data Guide functionality in Oracle Database 18c.

1. Setup

Create and populate the following table to provide some JSON data to work with. For the data guide functionality to work the table must include the IS JSON check constraint on the column holding the JSON data.

Monday, 21 May 2018

Schema Only Accounts in Oracle Database 18c

Schema only accounts don't allow direct connections, so administration of their objects is done via a DBA user or a proxy user.

Thursday, 17 May 2018

Introduction to Oracle Database

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.