In dbt, you can link your project to a github account, which is obviously the right thing to do. By default, the project uses the main branch. But what...
2023-05-05 (first published: 2023-04-24)
41 reads
Because my Windows machine apparently decides to install updates over night (and thus reboot my machine), it has happened that I lost the query that I was writing for...
2023-04-28 (first published: 2023-04-20)
132 reads
Those of you who follow me on social media (twitter | LinkedIn | mastadon) or who read my blog here, might be familiar with my catchphrase “STAR SCHEMA ALL...
2023-04-06
97 reads
Disclaimer: The publisher – Packt – sent me a free copy of the book for the intended purpose of a review. At the time of writing, the book is...
2023-03-15 (first published: 2023-03-05)
510 reads
Recently I had to read some REST API data using an Azure Logic App. The data itself comes from AFAS, a Dutch SaaS ERP company. In general, the process...
2023-03-13 (first published: 2023-02-26)
239 reads
I’m pleased to announce that I’ll be talking about how you can migrate your SSIS skills to Azure Data Factory at Data Saturday Rheinland. At the time of writing...
2023-02-24
16 reads
I’m excited to announce I’ve been selected again as a speaker for Techorama 2023. Techorama is one of the biggest Microsoft-focused events in the European mainland, and it’s always...
2023-02-14
15 reads
When working in business intelligence, data engineering or data in general, there are some “mantras” that are being adopted by the larger community as “best practices”. For example, I...
2023-02-14 (first published: 2023-02-13)
43 reads
For the first workdays of this new year, I had the pleasurable task of resetting a bunch of passwords. The passwords belong to Azure AD users, service principals, SQL...
2023-02-15 (first published: 2023-02-01)
511 reads
I was writing some dynamic SQL that generates some SQL statements to load my facts and dimensions into a data warehouse. Some of those SQL statements can become very...
2023-02-17 (first published: 2023-01-31)
612 reads
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Comments posted to this topic are about the item Going Native with Fabric Spark...
Which of these are valid OPENQUERY() uses?
See possible answers