Showing posts with the label SQL Server

Send a Database Query Result as Email via Logic App in HTML format using Azure Data Factory

(2020-June- 07)  It is a very simple concept, you have a database query result, either a direct d…

SQL Server data flow into Excel template with Power Query function-based parameter

(2018-July-15)  Your case is to create an Excel template with data extracted from a backend SQL Ser…

Geometry Objects in SQL Server using Latitude/Longitude coordinates

(2018-Mat-31) Support for spatial geometry functions was initially introduced in SQL Server 2008 a…

Get Data experience from Excel to Power BI and SQL Server Analysis Services 2017

(2018-Jan-20) It has been a long journey for the Excel data integration tool Power Query from its e…

When it’s cold outside, perhaps Power BI heat maps can warm you up

(2018-Jan-13)  You never know how the weather will behave itself, especially when the temperature g…

Load More That is All