Power BI for Large Databases with new Composite Mode presentation by Hector Villafuerte at the South Florida Power BI User Group. Today’s enterprise business analytics requires run complex analytic queries against large datasets stored in different sources like Azure SQL Database, Azure Analysis Services, Azure SQL Data Warehouse, Apache Hive, Apache Spark. In this session,
This is the presentation for my session at SQL Saturday, South Florida, June 9 2018 Link to download PPT: Download Presentation
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