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?
Author: reitsees
Azure Data Factory and Soap, an opera?
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?
2022 in review, 2023 in preview
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
Azure SQL Databases part 10 of 9, round up
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
End of year planning: T-SQL Tuesday #157
It's the end of the year already, 2022 has really flown by. To see what we have left this year, Garry Bargsley (blog|twitter) has asked us what we have planned for the end of the year? It's been quite the year, but that's for another blog. But it does relate to what's planned for the … Continue reading End of year planning: T-SQL Tuesday #157
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 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
New Stars of Data
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
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 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
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 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
Azure SQL Database Performance comparison part 6 of 9: General Purpose Compute Optimized
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 Compute Optimized 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 General … Continue reading Azure SQL Database Performance comparison part 6 of 9: General Purpose Compute Optimized