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
About two weeks ago I had the immense pleasure of speaking in Berlin for the first time. Now, I'm used to regular events like data saturday's and SQL Bits or dataMinds Connect as outliers because they're larger and different events. But speaking at this one is on a whole different level. As you might gather … Continue reading Speaking experiences at Data Moshpit (Berlin, Germany)
It's been some time since my last post on Azure Data Factory, but I had some fun this week and wanted to share the learnings. This blog will cover how I read files from an sFTP site, use the copy activity if the file hasn't been processed yet and write some data into a table … Continue reading Learning ADF Part 6
In one of my last blogs, I wrote about my first encounter with the Azure Hyperscale Serverless offering. Now it's time to dig a bit deeper and what it's up to. Disclaimer. Azure Hyperscale Serverless is in preview and one of the things that isn't active yet, is the auto shutdown. This means that it … Continue reading Fooling around with TPC-H data, ADF and Hyperscale Serverless
As some of you know, I've written a series of blog posts on Azure SQL Databases and there's an accompanying session that I had the honour of presenting a number of times. Now Azure keeps developing new offers and one of these went in public preview February 15th. An offer I hadn't seen coming. You … Continue reading Azure Hyperscale Serverless, first impressions
In the past 9 blogs, I’ve shown you all sorts of Azure SQL database solutions and gave them a little run for their money. I’ve tested a lot and written about them. This blog will be about the summation of the data and my views on the combined graphs. At the end I’ll wrap it … Continue reading Azure SQL Databases part 10 of 9, round up
Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB Managed Instance tier. Click here for information about the set-upClick here for the scripts I’ve used Intro So far, the blogs were about the really SaaS databases; the database is deployed and … Continue reading Azure SQL Database Performance comparison part 9 of 9: Managed Instance
It's the beginning of 2020. I've been to a number of conferences, gotten a feel for what's going on and what the different sessions are. From the short sessions to the full hour ones where speakers dive deep into a subject or explain in normal words what some feature can accomplish. Usually I'm learning something … Continue reading New Stars of Data
Reitse's blog 