This is a long read and I spent a pretty long time going through videos and articles compiling this into one post. Not something I would have done usually. But I do think that sometimes having it all in one place is easier to access than splitting into multiple articles. I hope the TOC helps group things. Azure AD is Microsoft’s cloud-based identity and access management service. Lots of words. But do they make sense? ...
Background I have been using Logic Apps to transfer data from one database to another. Of course, there is business logic in the queries run on the source database. And in such a case, maybe Azure Data Factory might have been a better choice. It very well could be. But for now I have been using a logic app, that simply runs a pretty big query, fetches the results and inserts into my destination database after some checks on the data present in the destination database. It works. However, using your Logic App to do some data related operations, especially to a SQL database, requires some wisdom. ...
What are Azure Logic Apps? Azure Logic Apps are an Azure service that lets you visually build integrated solutions to connect several different apps and services together, and comes with a click and select interface. It enables you automate business processes without writing any code at all! What is business process? A business process or workflow is a sequence of tasks that produce some sort of outcome, which may be some data, decision, notification. ...
I began my software development career on Linux. I am and have always been very comfortable with the command line and do not really care if I have to open up the command line on Windows. However, in the Windows world, command line used to suck. I think that is a polite way to put it. It truly sucked so bad that developers from a Linux background, often wondered how windows even got this far. It had a weird window size limitation and used to open only halfway through your wide screen! ...