In the previous article, I introduced a simple way to implement Row-Level-Security implementation for Microsoft SQL Server 2016 database with Active Directory. Here, I’ll show you a more efficient way to implement RLS when you deal with millions of records in your database and thousands of users in your active directory. Below is the original
In this article, I’ll explain a basic use case of Row-Level-Security implementation for Microsoft SQL Server 2016 database. The AdventureWorks Database supports a fictitious, multinational manufacturing company called Adventure Works Cycles. This company sells products around the world. Sales are ordered from five different countries like Unites States, Germany, United Kingdom, Canada, France and Australia.
Hector Villafuerte speaking on SQL Saturday South Florida Saturday, Jun 10, 2017 Conference http://hectorv.com/wp-content/uploads/2017/06/RLS-SQL-Saturday-1.pptx
The following is a series of articles that explain how we can use Row Level Security (RLS) and Active Directory across all BI technologies, database and tools in the corporate environment. The goal is to create an integrated and a comprehensive data access control across multiple database technologies using different BI Tools or Apps. SQL
Table or Matrix for Side by Side Column Comparison with columns with different formats in the same column.
Note: This article was updated with a new formatting feature released. See the updated version of this article: Table or Matrix for Side by Side Column Comparison with columns with different formats in the same column. (Updated) Note: As of now, April 2017, Power BI does not support different formats for the same column