Showing posts with the label SQL

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…

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…

Loading tables by using BIML and meta architecture

Case How can we simplify the process of loading database tables and reduce the time needed to creat…

Use BIML and csv files to create tables

Case The case is about importing flat files (CSV’s) without the necessity of metadata. Because BIML…

Create and populate Time Dimension

Case We have sensors in our building that output data every minute which we want to use in a dimens…

Creating a comma separated list of related records

Case I have a list of teacher and student combinations with one combination per record and I want t…

Sorting in SQL vs sorting in SSIS

Case When I join two flows in SSIS, the flows need to be sorted. According to the Performance Best …

Search for ColumnName

Case I'm searching for the right column in a large Microsoft SQL database. Is there a way to fi…

Load More That is All