Ranga Babu
email masking function

Implementing Dynamic Data Masking in Azure SQL database

July 30, 2019 by

In this article, we will review Dynamic Data Masking in the Azure SQL database. Dynamic Data Masking is a feature to limit the sensitive data to the non-privileged users by hiding the data of a column. Data is not masked and stored in the disk. Masking is applied to the result set returned to the user. The users with “db_owner” permission on “UNMASK” permission can still see the unmasked data when they query the table.

Read more »
Dinesh Asanka
Selecting the mining struture from the available list

Introduction to SQL Server Data Mining

July 23, 2019 by

Prediction, is it a new thing for you? You won’t believe you are predicting from the bed to the office and to back to the bed. Just imagine, you have a meeting at 9 AM at the office. If you are using public transport, you need to predict at what time you have to leave so that you can reach the office for the meeting on time. Time may vary by considering the time and the day of the week, and the traffic condition etc. Before you leave your home, you might predict whether it will rain today and you might want to take an umbrella or necessary clothes with you. If you are using your vehicle then the prediction time would be different. If so, you don’t need to worry about the rain but you need to consider the fuel level you need to have to reach to the office. By looking at this simple example, you will understand how critical it is to predict and you understand that all these predictions are done with your experience but not by any scientific method.

Read more »
Daniel Calbimonte
SQL Server on-premises or SQL Cloud

SQL Server download guide

July 22, 2019 by

Introduction

This article serves as a SQL Server Download guide for both beginners and beyond. Some years ago, it was pretty simple to download the installer because you had all the components installed. Now, it is harder because you need to install several components, there are several versions and editions. This guide will help you to understand which version and edition needs to be downloaded.

Read more »
Ranga Babu
adding database to an existing failover group

Azure SQL Server auto-failover groups

July 18, 2019 by

In this article, we will review how to set up auto-failover groups in Azure SQL Server and how failover group is different from active geo-replication in Azure. Auto-failover group is an Azure SQL database feature that replicates one or a group of databases to the secondary Azure SQL server in the cross-region. We cannot have a secondary server in the same region. This feature is used to failover all the databases in the failover group in case of disaster and the failover is automatic.

Read more »