What's new in SQL Server 2019

Database Engine Enhancements on Windows

Enhancements in the SQL Server 2019 database engine are not limited to PolyBase and Big Data Clusters; many components of the database engine have new features and capabilities with this release. The following features are added or enhanced for SQL Server 2019 CTP 2.0.

Row Level Security in SQL Server 2016

Row Level Security (RLS) feature enables fine grained control over access to rows in a table. Access restriction is located and controlled in the database level rather than at the application tier. Any time the user access the table based on the restriction of RLS, the function is invoked and enforced by the security policy. This enables us to easily restrict the data based on the user identity or security context.


Setting up an Cloudera Cluster on AWS EC2 - Part 1

In this demo we will be configuring cloudera cluster on Amazon Web Services EC2 platform.

Prerequisites

    -   Sign up for an AWS account if you don’t have one.
    -   RHEL 7.5 Operating System
    -   2 Core Processor minimum 8 GB RAM - AWS Instances EC2

Setting up an Cloudera Cluster on AWS EC2 - Part 2

Step #1 Cloudera Manager Installation 

Start NTPD services 
Note: Perform this step on all servers

service ntpd start

Configure SQL Server Always On Availability Group on Linux

Overview

This post explains how to create an SQL Server AlwaysOn Availability Group (AG) for high availability on Linux.There are two configuration types for availability groups. High availability configuration uses a cluster manager to provide business continuity. This configuration can also include read-scale replicas.With Read-scale configuration, availability group can be created without a cluster manager for read-scale. The AG for read scale only provides read-only replicas for performance scale-out. It does not provide high availability.

Configure SQL Server AlwaysOn Availability Groups on Linux - Part 1

Install and configure a cluster resource manager - Pacemaker

SQL Server 2017 introduces two different architectures for availability groups. Always On availability groups provide high availability, disaster recovery, and read-scale balancing. These availability groups require a cluster manager. In Windows, failover clustering provides the cluster manager. In Linux, you can use Pacemaker.

Configure SQL Server AlwaysOn Availability Groups on Linux - Part 2

Install and Configure SQL Server on three cluster servers.

In Part 1, we saw how to install and configure pacemaker with corosync. In this post, we will walk through installation of SQL Server and Linux resource Agent.We will also prepare the security requirements for authenticating the replicas of the Always On Availability Group.

Configure SQL Server AlwaysOn Availability Groups on Linux - Part 3

Create the SQL Server 2017 AlwaysOn Availability Group

In this post, we will see Step-by-step Installation and Configuration of SQL Server 2017 Availability Groups on a Linux Cluster. In Part 2, we enable the Always On Availability Groups feature and configure the security requirements for authenticating the replicas of the Always On Availability Group. This post is a walk through the creation of the Availability Group and its corresponding listener name.

Configure SQL Server AlwaysOn Availability Groups on Linux - Part 4

Creating the SQL Server AlwaysOn Availability Group Resources on Pacemaker

Pacemaker concept is very similar to Windows Server Failover Cluster (WSFC).The cluster resource agent that is installed in Part 2 - mssql-server-ha - is the interface between Pacemaker and SQL Server. It tells Pacemaker about the status and health of the resource – in this case, the SQL Server Always On Availability Group - so the cluster can decide how to deal with it to maintain high availability.