SQL Server – jack of all trades master of some

Setting up Azure Data Factory Integration Runtime for On-Prem Connections

January 12, 2021 by Vimal Vachhani

If you need to connect your Azure Data Factory to an on-premise SQL server you will need help Setting up Azure Data Factory Integration Runtime for On-Prem Connections Set up On-Prem Integration Run Time Click on Author & Monitor from Azure Data Factory Create two new linked services Linked Service to Database. Since we are … Read more

Direct Custom SQL Query Denodo from Power BI M Query

July 31, 2020July 30, 2020 by Vimal Vachhani

If you are planning to use Power BI on top of Denodo sometimes a base view or a Power Query won’t be enough. If you need to embed your own complex query to pull data from Denodo, there are a few items you must be aware of. See below on how to Direct Custom SQL … Read more

Visual Studio Dev Essentials to download and install SQL Server Developer Edition

March 28, 2019 by Vimal Vachhani

With the Microsoft BizSpark program now gone, so is the easy way to download and install SQL Server to your local machine for development purposes. Let’s take a look at using Visual Studio Dev Essentials to download and install SQL Server Developer Edition on your local machine for data development.