Tag: SQL Server
-
Setting up Azure Data Factory Integration Runtime for On-Prem Connections
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…
-
Direct Custom SQL Query Denodo from Power BI M Query
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…
-
Visual Studio Dev Essentials to download and install SQL Server Developer Edition
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.