I was teaching a class and during an interesting discussing an attendee told me that views with a filter took a long time to produce results, even if the result set itself was quite small. I wanted to test this out for myself to see what was happening. I'll take you along this short journey … Continue reading View with a where clause
In my previous blogs, I've written about Fabric and all the cool things it can do. Thing is, my load tests were based on files. Either CSV or Delta. But in reality, a lot of data comes from an on-premises database server. In reality, you might connect to a SQL 2008 instance or maybe even … Continue reading Microsoft Fabric, connect to your on-premises SQL Server
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
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
Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB Business Critical tier. Click here for information about the set-upClick here for the scripts I’ve used Intro My last blog was about the Hyperscale tier, this week we’re back at more regular … Continue reading Azure SQL Database Performance comparison part 8 of 9: Business Critical
Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB Hyperscale tier. Click here for information about the set-upClick here for the scripts I’ve used Intro So far, my blogs have been on the different Azure SQL DB offerings where there are … Continue reading Azure SQL Database Performance comparison part 7 of 9: Hyperscale
Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB General Purpose Provisioned tier. Quite a mouth full. Click here for information about the set-upClick here for the scripts I’ve used Intro In my previous blog, I wrote about the serverless tier, … Continue reading Azure SQL Database Performance comparison part 5 of 9: General Purpose
Reitse's blog 