Azure DNS is Microsoft’s hosting service for DNS domains. It allows users to manage their infrastructure and related related domain information in one central place. This alone could be a decent argument for Azure DNS. But one of the key benefits is the tight integration with Azure’s resources: Azure DNS aliases provide dynamic references to Azure resources and can be created at the zone apex level. This provides key benefits such as automatic updates of the DNS record set when an underlying IP address changes thus preventing dangling DNS records, load balancing of the apex domain, and direct reference to Azure Content Delivery Network endpoints. ...

There are different access tiers for blobs residing in Azure Storage. These tiers include Hot Cool Cold Archive The storage tier is set on the storage account level. Options differ with respect to storage and access cost, minimum storage duration, and latency (time until data is retrieved) and are thus suited to different scenarios. Hot This tier is optimized for frequent read or writes. It is thus suited for actively used data. It incurs the highest storage cost, but lowest access cost and is the default option when creating storage accounts. ...

A recent project of mine involved determining duplicate CRM objects across Salesforce and Hubspot. I utilized duckdb for my data processing and found this neat little text function duckdb provides: strip_accents(string). It does exactly what it says: Strip accents from a string. Thus Mühleisen becomes Muheisen. This feature saved me from manually defining a map of umlaut characters and replacing them in a bunch of places. SELECT strip_accents(first_name) as first_name_normalized, ... FROM salesforce.contacts Neat! ...

The dlt team has been on a global roadshow for the last few weeks, making the stop in their home-city of Berlin last Tuesday. The evening was packed with presentations, guest speakers, and product demos. And even though one speaker fell ill, it went well over the planned schedule. If it was up to me, it could have continued for a good while longer - I was really fascinated by the insights shared from the members of the community. It was really cool to put a face to the names you typically see in Slack or in articles. ...

Oh wow this actually works. Pretty neat. Let’s see what I will come up with…