Azure Data Factory and Soap, an opera?

Getting data from an API can be hard, especially when you're trying to get data from a so-called Soap interface. This is a bit of an antique way to distribute data to online applications and has a lot of challenges. I've read a few blogs on this subject but funnily enough, they're all using the … Continue reading Azure Data Factory and Soap, an opera?

T-SQL Tuesday 155, Dynamic SQL

This month, Steve Jones (T) invites us to write about the way dynamic SQL helped us solve a problem. Case For one of our customers, we've had an interesting case. They have multiple schemas in the database and the schema's contain a lot of tables with different use cases. To grant user groups (not individual … Continue reading T-SQL Tuesday 155, Dynamic SQL

Fun ROWNUM() case, get n’th row from dataset.

Last week, one of my coworkers had a nice case. From a dataset, he needed the third row based on an indicator and a timestamp. That sounded a bit vague so I started out with creating a table that contained some records with the columns he'd have to filter on. CREATE TABLE dbo.demo ( id … Continue reading Fun ROWNUM() case, get n’th row from dataset.

Azure Infrastructure as Code

If you've been working with Azure for more than a few months, you'll find that deploying resources with the portal is a tedious, time consuming and, at times, a frustrating excercise. It's the best starting point you can get, because the portal will show you a lot of options and offers a easy learning curve. … Continue reading Azure Infrastructure as Code