This month, Kevin Chant has a really fun writing challenge for us. Not only is it a very inspiring call to write about SQL Server (my choice), but it's also a crossover between T-SQL Tuesday and the Festive Tech Calendar. It's like opening a digital present! Kevin created a very nice image that shows the … Continue reading T-SQL Tuesday #181 The Data Platform Present
This blogpost will be introductory to version control within Microsoft Fabric. If you've got the basics of this under control, you're welcome to refresh your knowledge in this blog or check out our points of view. Alternatively, you can dig into the blogposts by Kevin Chant who has a lot of good posts on this … Continue reading DP-700: Configure version control
By the time you read this, I'm guessing the big #MSIgnite announcements were yesterday. You can use that hashtag to find most of the posts on social media. And there were many, very cool, announcements! Let me quickly take you through my favourites. Databases! As I still love the DBA work, announcing SQL Server 2025 … Continue reading Top Highlights from #MSIgnite 2024
I had an interesting morning trying to connect Dynamics to a Data lake. As you might know, there was a feature where Dynamics would create a Data lake for you. This choice will cease to exist quite soon and to offer alternatives, you can create an Azure Synapse Link or Fabric Link. This blog will … Continue reading Creating Azure Synapse Link for Dynamics: Step-by-Step Guide
I just can't seem to stop doing this, checking the limits of Microsoft Fabric. In this instalment I'll try and find some limits on the data warehouse experience and compare them with the Lakehouse experience. The data warehouse is a bit different compared to the Lakehouse, so I'll be digging into that one first. Then … Continue reading Testing Microsoft Fabric Capacity: Data Warehouse vs Lakehouse Performance
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
Reitse's blog 