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, but were introduced in a later version. One of them is AT TIME ZONE, which you can use the convert dates between time zones, as demonstrated […]
Tag: syndicated
Speaking at SQLBits 2022
I’m delighted to announce I’ll be speaking at the SQLBits conference in March 2022! I’m not delivering one session, but two this time. Well, actually, for one session I’m co-presenting with Mala Mahadevan. I’m really looking forward to this session, as it’s a not-well known topic (I hadn’t heard about it till Mala told me […]
T-SQL Tuesday #143 – Short code examples
It’s this time of the month again! T-SQL Tuesday is a monthly blogging party on the second Tuesday. This month’s topic is “What are your go to handy short scripts?” brought to you by John McCormack. What are those little short bits of code that you can’t live without? I’m talking about little snippets that […]
Webinar – Improve SQL Server Data Quality in SSIS
On the 5th of October 2021 I’ll be giving a webinar about improving data quality of contact data (names, addresses, emails etc) using the Melissa Data Tools. I’ll be doing half an hour of technical demos, while Jeremy of MSSQLTips.com will take for another half our of the business value of the Melissa software. Data […]
Speaking at dataMinds Connect 2021
In October I’ll be speaking at the dataMinds Connect conference. This event is very dear to me, because it’s a home match, since it’s a Belgian conference, and also the biggest Microsoft Data Platform conference in the BeNeLux. it’s the first in-person event for me this year (fingers crossed the situation only improves till October!) […]
Upcoming Webinar – Intro to SSIS – Advanced Topics
On July the 22th at 9PM CET I will give the second part of the “Introduction to SSIS” webinar series on the MSSQLTips.com website. If you’ve never worked with SSIS before, it helps if you’ve seen part 1. The abstract: In this webinar, we build upon the Getting Started with SSIS webinar. You already know how to […]
Dynamic Datasets in Azure Data Factory
With “dynamic datasets” I mean the following: a dataset that doesn’t have any schema or properties defined, but rather only parameters. Why would you do this? With a dynamic – or generic – dataset, you can use it inside a ForEach loop and then loop over metadata which will populate the values of the parameter. […]
Azure Data Factory and the Exact Online REST API – Getting around the 10 Minute Limit
This is the final blog post of this series on how to extract data from the Exact Online REST API with Azure Data Factory. I’ve you followed along with the previous posts, you’ve seen how you can request new refresh/access tokens from the API, how you can extract data from an endpoint for multiple divisions […]
Azure Data Factory and the Exact Online REST API – Dealing with Pagination
Some endpoints don’t have that much data, both others certainly will, for example financial transactions. The REST API limits the number of records it returns, and for most endpoints this is 60 records. After the first 60 records, you get a link at the bottom of the response that points to the next 60 records. […]
Azure Data Factory and the Exact Online REST API – Retrieving Data from an Endpoint
Finally we’ve come to the core of this blog post series: extracting data from a REST API endpoint. Just to recap, you need the following: an access token that is currently valid. See this blog post. a list of divisions. See the previous blog post. As an example, we’re going to read from the Projects […]