Azure, SQL Server and related stuff. Some Powershell as well.
Blog alert! My colleague recently came to me with a fun challenge: why is their SQL Server Hashbytes conversion not working as expected? After some digging, I discovered significant differences between text data types when converting them. Check out my latest blog post to learn more about this interesting topic. #SQL #datahashing #techtalk #SqlServer #Microsoft
Now this is something completely different. I've never used Power Automate before and would never have thought to use it if it hadn't been for the 101 session by Alexander Klein at datasaturday Gothenburg. Issue For some reason, people like to invite me to meetings. That's OK if I can add to the fun, but … Continue reading Building an auto deny on meeting requests in Power Automate
Now, that's a title with a lot of terms. Github Actions You'll probably know Github as the website where you can store your code, be agile with all sorts of branches, merges etc and keep track of your issues. There are also actions which are roughly the same as Azure DevOps pipelines. Written in Yaml … Continue reading Using Github Actions to deploy Azure resources with Terraform
Captains log, stardate... No, wrong opening. I reported an issue yesterday with Microsoft Support and during the following call today (they're really quick to set up an initial meeting), the support engineer showed me where I can find a lot of logging information.Suppose you've got a notebook that has been run a few times. The … Continue reading Microsoft Fabric, Notebook logs
A few days ago, I heard the term table clone for the first time, it's preview release date was to be confirmed and I had no idea what it was about. Two days later, a video emerged where the table clone was explained on a high level. At that point, I started to wonder what … Continue reading Microsoft Fabric: shortcuts and table clones
This month, Erik Darling (T | L | B) asks us to write about code that made us feel a way. Rule is, it can't be your own code. That's good, because that usually makes me a bit sad when I review it. The moment I write it, I think it's brilliant though ;). Most … Continue reading T-SQL Tuesday #164: Code that made you feel a way
When Fabric released, there was a lot of noise around it. Many people have written blogs, created YouTube video's and all kinds of other interesting things to share the love of this new tooling. Well, new? Especially when you look at Fabric data warehouse, it's more of an iteration over Synapse Analytics Serverless Pools. As … Continue reading Microsoft Fabric, Data Warehouse first impressions
In my previous blog, I wrote about some first impression working with Fabric and mostly following the Lakehouse tutorial provided by Microsoft. Well structured as this one may be, the sizes are not like the sizes I'm seeing in the wild. So I decided to give Fabric a bit more of a challenge by letting … Continue reading Microsoft Fabric, fooling around with TPC-H data
This month, I hosted the Tsql2sday where I asked you to write about the most funny things you did with T-Sql. I'll happily admit it was a bit of a cheesy subject but you came out in numbers to write! Thanks for that. Before I dive into the blogs I found, send me a message … Continue reading Tsql2sday #161, the writeup
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?
Reitse's blog 