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
Here are the slides of my presentation at South Florida Code Camp 2018 on February 10th, 2018. Recently released toolsets for AWS Lambda and Azure Functions are finally making “serverless” application development available to C# developers. Join me to explore the different features and development process of an Alexa Skill with .NET using the most
After developing some skills using AWS Lambda, C# and the AWS Toolkit for Visual Studio. I encounter some advantages and disadvantages in the development Tools for the skills I’d like to develop . This post shows the steps to develop an Alexa Skill using Azure Functions. Alexa with Azure Functions Microsoft’s Serverless Computing equivalent to
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.