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?