Forum Discussion

red_data_machine's avatar
red_data_machine
Copper Contributor
Aug 08, 2024

Appropriate Data Store

Hi all,

 

I am an ex-sql server dba now getting my hands dirty again and building a new system. I have been using azure sql which is working absolutely fine for the small datasets however I will be importing some timeseries data - I've imported around 77 million records a month. Azure SQL seems to be ok when appropriately indexed but when I imported the data into a Azure Synapse Dedicated SQL Pool it seemed much faster out of the box. This is a relatively expensive solution though and Big Query probably offers a similar experience for cheaper (as claimed by google). 

I haven't seen much information online around Azure Synapse Dedicated SQL Pools so I'm wondering if that is an area microsoft is pushing in the future or if there a better alternative within Azure.

I want to continue to query the data via sql which i can with Azure Synapse Dedicated SQL Pools and also Big Query,

Any advice please?




Resources