I’ve just started to learn logic apps and Power Automate since Dec 2023, so I’m pretty new. However I’m sharing some challenges I faced and that I could solved somehow.
Get notification on Synapse Pipeline failures
I do love working in Synapse as I think this is a highly integrated orchestration tool that really contains almost everything that’s needed for a data engineer. However just as all tools it also has some missing pieces. One of those pieces is the alerting functionality at least a native build in alerting functionality. This…
SQL Query is not enabled for On-Prem SQL Server
One of my current jobs required to pull the latest ID of a SQL table from an on-prem server. I thought it will be an easy one but finally it really wasn’t… let see why: To get the biggest ID from a SQL table is pretty easy with a SQL script, it is only like SELECT…
Override When Created/Modified trigger on SQL Server
I’ve recently fallen into trouble when I wanted to setup a new workflow in Logic Apps. The scenario was pretty simple. Do something when a new Item is created in an on-prem SQL Server data table. This scenario was one of the basic methods learning materials was covering so I’ve started the creation of the…
Adam's Perspective on Data 