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
This month Deepthi Goguri invites us (the community) to write about two topics: our favourite new feature of SQL Server 2022 and your new years resolutions. You can find her blog here, her LinkedIn profile here and she's also on Twitter here. Favourite new SQL Server 2022 feature Most of my work is in data … Continue reading T-SQL Tuesday #159 – What’s Your New Favourite Feature?
A few days ago, I heard someone stating that Group By was much quicker than Distinct. Less disk impact, less memory etc.So, I thought I'd find out if it's true or not because I found it interesting. I always thought there was no difference. I tested a single small table and found no difference in … Continue reading Distinct or Group By?
Getting data from an API can be hard, especially when you're trying to get data from a so-called Soap interface. This is a bit of an antique way to distribute data to online applications and has a lot of challenges. I've read a few blogs on this subject but funnily enough, they're all using the … Continue reading Azure Data Factory and Soap, an opera?
It's the end of the year, the beginning of a new one. Time to look back and see what happened and plot a course forward. 2022, the downs Let's get started with the bad stuff, get it over with. As some as you know, my mother got diagnosed with Alzheimer's disease. This is a process … Continue reading 2022 in review, 2023 in preview
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 