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?

​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?  Read More

​