Monday, 18 June 2018

PL/SQL Subprograms

Subprograms are named PL/SQL blocks that can be called with a set of parameters. PL/SQL has two types of subprograms, procedures and functions.

Friday, 15 June 2018

Azure SQL Database - Transparent Data Encryption

In one of our recent articles published on this forum, we described the main characteristics of row-level security - a new feature introduced in Azure SQL Database V12 as well as in SQL Server 2016 Community Technology Preview 2. As we pointed out, this was another sign that the trend manifested by a lack of feature parity between these two products, with the cloud service placing distant second behind its well-established on-premises counterpart is consistently declining. In this article, we will review another security-related feature known as Transparent Data Encryption, which also exemplifies this trend, although, unlike row-level security, it made its first appearance long before Azure SQL Database emerged as a potential substitute for a full-fledged SQL Server installation (more specifically, it became available starting with its 2008 version).

Wednesday, 13 June 2018

Azure SQL Database - Row-Level Security

One of the benefits of using Azure-based Platform-as-a-Service and Software-as-a-Service offerings is considerably quicker access to newly developed capabilities, frequently becoming available long before they are incorporated into traditional, full-fledged products. In addition, the trend manifested by lack of feature parity between these two areas, with the cloud apps placing second behind their well-established on-premises counterparts is consistently declining and in some cases even reversing, with the cloud taking over as the dominant force in software development and implementation efforts. This trend is reflected by the number of features introduced recently in Azure SQL Database. We will focus in our article on one of them, known as row-level security, included in both Azure SQL Database V12 and SQL Server 2016 Community Technology Preview 2 (CTP2).

Monday, 11 June 2018

PL/SQL Packages

A package is a schema object that groups logically related PL/SQL types, variables, and subprograms. Packages usually have two parts, a specification (spec) and a body; sometimes the body is unnecessary. The specification is the interface to the package. It declares the types, variables, constants, exceptions, cursors, and subprograms that can be referenced from outside the package. The body defines the queries for the cursors and the code for the subprograms.