Search Suggest

SQL Server
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 database table output or a stored procedure returne…

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 Server database; it takes a few minutes and Power Que…

Geometry Objects in SQL Server using Latitude/Longitude coordinates

(2018-Mat-31) Support for spatial geometry functions was initially introduced in SQL Server 2008 and then it was greatly improved in Denali (SQL Ser…

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 early version as an external add-in component in 20…

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 gets dramatically changed from +10 to -10 within a …