Parsing JSON in SQL Server with OPENJSON
Recently I had a piece of JSON of which I needed to extract data from to put into a table in Azure SQL DB. Unfortunately, the structure of the...
2022-03-28
36 reads
Recently I had a piece of JSON of which I needed to extract data from to put into a table in Azure SQL DB. Unfortunately, the structure of the...
2022-03-28
36 reads
Disclaimer: Apress gave me a free copy of the book to review. People that know me, also know I always give honest feedback 🙂 I had the pleasure of...
2022-03-23
7 reads
Azure Data Factory has a new activity introduced this week (around the 10th of March 2022 for you future readers): the Script activity! This is not to be confused...
2022-03-13
23 reads
AFAS is a Dutch business software company, proving companies with ERP and HR software-as-a-service. You can extract data from the service using a REST API (there are also SOAP...
2022-03-07
10 reads
We’re reading in some JSON files in Azure Data Factory (ADF), for example for a REST API. We’re storing the data in a relational table (SQL Server, Azure SQL...
2022-02-28
37 reads
Linting is a process where a code analyzer is run to find programmatic errors, bugs, “stylistic constructs” or anti-patterns. For example, in Python there are specific modules that help...
2022-02-28
27 reads
A new feature has been added to the Power BI Desktop toolset and it’s a very nice one. The official name is “DirectQuery for PBI datasets and AS”. It...
2022-02-25
10 reads
I’ve received some good news: Techorama is back with an in-person conference! I’m selected as a speaker and I’ll be talking about Azure Data Factory. Azure Data Factory (ADF)...
2022-02-22
1 reads
Recently I was working with a client who was still on SQL Server 2012. Support issues aside, there are some very useful T-SQL functions/clauses who didn’t exist in 2012,...
2022-02-17
For quite some time now, there’s been the possibility to lift-and-shift your on-premises SSIS project to Azure Data Factory. There, they run in an Integration Runtime, a cluster of...
2020-11-10 (first published: 2020-11-03)
586 reads
By Steve Jones
For those that attended my talk at Denver Dev Days, here are the slides:...
By Steve Jones
As a part of my AI experiments, I decided to ask CoPilot to write...
By Steve Jones
slipfast adj. longing to disappear completely; to melt into a crowd and become invisible,...
Comments posted to this topic are about the item Software Flexibility (Avoiding the next...
Our IT department contacted me recently and asked if they should change the default...