SQL Server Row-Level Security (RLS)

In this post, I will explain how to setup and use SQL Server Row-Level Security (RLS). RLS is available from SQL Server 2016 and also on Azure SQL database. RLS is used to control access to rows (records) in your database table, restricting employees to ONLY access rows related to their department, region or any … Read moreSQL Server Row-Level Security (RLS)

Index Related Dynamic Management Views and Functions

Dynamic Management Views (DMV) was introduced in SQL Server 2005 and every SQL Server release Microsoft introduces additional DMVs, which helpsĀ to provide information about the health of a Server instance, performance and Server issues. There are two types of DMV, the first type is server-scoped DMV which requires VIEW SERVER STATE permission on the Server … Read moreIndex Related Dynamic Management Views and Functions

Invoking R script file in SQL Server 2016

The sp_execute_external_script is a stored procedure to execute script at an external location. The system sp_execute_external_script stored procedure was introduced in SQL Server 2016 and only supports R language. This post, I will show how to invoke an R script file in SQL Server 2016. Prerequisites Install SQL Server 2016 with R Server Enable External … Read moreInvoking R script file in SQL Server 2016