This blog won't be very long and will describe a connection issue I experienced with a customer including the solution and some context why this solution worked. I hope this saves you time when dealing with the same error. Issue The customer can connect to the Azure Sql database with Sql Server Management Studio (SSMS) … Continue reading Fixing Azure SQL Client Connection Timeouts
Welcome back to this mini series on Azure Sql Server with Copilot. In the previous posts I wrote about a general introduction of this toolset (click here for more) and had some fun in the Azure Portal getting stuff done (click here for more). In this third part, I'm going in for the data and … Continue reading Sql Server and Copilot. What the query it this? Part 3, query editor
Welcome back! In part one (click here), I've introduced Azure Sql Copilot. In this second part, I'm going to take you along in the Azure portal experience. I'll write about my personal experiences, opinions and the different angles you can use to connect with your database. Let's dig in! For this first part, I’m putting … Continue reading Sql Server and Copilot. What the query it this? Part 2, portal experience
Welcome to a series of three blogs where I'm going to explore Azure Sql Copilot. This series will portray a lot of my experiences trying out Azure Sql Copilot. The first blog will feature a short introduction and an introduction on Copilot security. The following blogs will focus on a lot of testing. Remember, AI … Continue reading Sql Server and Copilot. What the query it this? Part 1, introduction
This blog will be a quite short one compared to the other blogs as it's more of an overview to show you the capacity of Fabric ingesting CSV files in their native format into a Lakehouse and ingesting SQL data into a table structure inside the Lakehouse. Simple, straightforward stuff without any form of modification. … Continue reading Fabric Lakehouse Data Ingestion: CSV vs. SQL Scenarios
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
Blog Alert! Arun Ulag shared some neat new developments on #MicrosoftFabric at the keynote. Here are my first thoughts on them! #mvpbuzz #FabCon
When I thought of this subject last year, I was really on the fence if it would work or not. Part of me was convinced it would elicit some response from the community, part of me was convinced people would be looking for a 'happy' start of the year and might not want to think … Continue reading T-SQL Tuesday 170 write up: learning from abandoned projects
Last week the big announcement came at Microsoft Ignite, Fabric is GA. Very cool, a lot of noise again for this shiny toolbox, but do we need to abandon everything and focus solely on the new toys? Before I'll answer that question, let's look at a few moving parts of Fabric. Integration The most important … Continue reading Microsoft Fabric GA, and now?
Reitse's blog 