In this article, I’ll show the implementation of Row-Level-Security (RLS) with SQL 2016 and any .NET application like Web MVC, Web Forms, Web API, Windows App, etc. In previous articles, I showed you how to implement RLS in SQL 2016 and how client tools like Excel or Power BI can take advantage of this security.
SSAS 2016 Tabular On Premise with Row-Level Security and Active Directory This is a series of articles related to RLS (Row Level Security), started with http://hectorv.com/bringing-security-where-data-lives We are going to implement RLS (Row-Level Security) in SSAS (SQL Server Analysis Services) Tabular mode. In our use case: Adventure Works Internet Sales, the goal is to restrict access
Table or Matrix for Side by Side Column Comparison with columns with different formats in the same column. (Updated)
There was extra effort to create this kind of report in PowerBI, back in April I published an article to implement different formats in the same column. Table or Matrix for Side by Side Column Comparison with columns with different formats in the same column. Now, tt is extremely easy to have same result
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