In this post, I will explain how to setup and use Row-Level Security (RLS) which is available from SQL Server 2016 and on Azure SQL database. RLS enables you to control access to rows (records) in your database table, restricting employees to ONLY access rows related to their department, region or any other criteria required … Continue reading SQL Server Row-Level Security (RLS)
Category: SQL Server 2016
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 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 and … Continue reading Index 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 … Continue reading Invoking R script file in SQL Server 2016
Sergio and Sabrina Zenatti 