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…
Showing posts with the label SQL
Geometry Objects in SQL Server using Latitude/Longitude coordinates
byHOIT
(2018-Mat-31) Support for spatial geometry functions was initially introduced in SQL Server 2008 a…
Loading tables by using BIML and meta architecture
byHOIT
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
byHOIT
Case The case is about importing flat files (CSV’s) without the necessity of metadata. Because BIML…
Create and populate Time Dimension
byHOIT
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
byHOIT
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
byHOIT
Case When I join two flows in SSIS, the flows need to be sorted. According to the Performance Best …
Search for ColumnName
byHOIT
Case I'm searching for the right column in a large Microsoft SQL database. Is there a way to fi…