If you come from an SQL Server background, mirroring will be familiar to you. It may be good or bad, but hopefully not at a nightmare level. Whatever your association with database mirroring, it is also available within Microsoft Fabric. What is mirroring If you're not coming from a SQL Server background, or any data … Continue reading DP-700 training: Implement mirroring
Some time ago, I wrote a number of blogposts comparing the different Azure SQL options to give you some idea about performance, differences between tiers and differences between the Stock Keeping Units (SKU's). This was done by creating data in the database itself and review the metrics. This works fine and gave a good overview … Continue reading Loadtesting SQL, the sequel
Data security is the most important part of our job as data engineers and data architects. There are very few use cases where people need to see all the data in full detail. I know, customers take a different view on this but in reality, do they really need every single detail? No, they do … Continue reading DP-700 training: data masking
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
After an almost full week of travelling, learning and meeting people, time for a short write up. Hello Stockholm! Or even hello Schiphol. When I walked up to the gate, it took the best part of a minute for the first Microsoft person to walk up to me and ask if I was on my … Continue reading Experiencing Microsoft Fabric Conference in Stockholm
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
Or maybe I should say, with some complications. Or challenges. When I got the job to restore a bacpac file, I didn't think much of it. Because it's quite easy. Get the bacpac and restore it with Azure Data Studio or Sql Server Management Studio. Get coffee, done. Then I got these requirements: The bacpac … Continue reading Restoring a bacpac file, but differently.
Or, how SQL Server behaved differently than I expected but managed to process quite a lot of rows before giving up. Let's begin We have a customer that would like to see the actual value of their stock in a table. They buy their stock at different times and at different prices. Calculating the stock … Continue reading SQL Server Common Table Expressions, a tale.
Reitse's blog 