Azure Archives - Visual BI Solutions

Fetching Historical Data in Azure Data Factory

by Aishwarya Arumugasamy | May 6, 2019 | Azure

Triggers are like job schedulers for the execution of pipeline runs in the Azure Data Factory. Presently there are three types of triggers that are supported in ADF. Schedule trigger: A trigger that executes a pipeline on an absolute schedule Tumbling window trigger:...

User-Defined Schema in Databricks

by Arjun Raja Sreedar | May 2, 2019 | Azure

If you’ve been working with CSV files in Databricks, you must be familiar with a very useful option called inferSchema while loading CSV files. It is the default option that is widely used by developers to identify the columns, data types, and nullability,...

Dynamic Data Masking

by Mohamed Ramees Raja | May 1, 2019 | Azure

This post is the continuation of Azure SQL security recommendations. In the earlier posts, we visited the concept of Row-level security for limiting user access to related data. Today, we will look at how to mask sensitive data using Dynamic Data Masking feature....

Row Level Security – Azure SQL Server Security Recommendations (Part 2)

by Mohamed Ramees Raja | Apr 25, 2019 | Azure

This post is the continuation of the Azure SQL Server security recommendations series. In my previous blog, we went through the filter predicate. In this blog, we will cover block predicate and highlight some of the best practices recommended by Microsoft. ...

Parameterize Connections in Azure Data Factory

by Mohamed Kaja Nawaz | Apr 24, 2019 | Azure

Azure Data Factory is a managed cloud service that is built for complex data orchestration processes and hybrid extract-transform-load (ETL), extract-load-transform (ELT), and data integration projects. In this blog, we will demonstrate how to parameterize connection...

Best Practices for Installing Tableau on Azure

by Shankar Narayanan | Apr 23, 2019 | Azure, Tableau

In our previous blog, we discussed the best practices for installing Tableau on VMware. Now let us take a look at the best practices for installing Tableau on Azure. Azure is one of the widely used Cloud Providers and a lot of companies use Azure for their Computing...