Azure Synapse Serverless vs Dedicated SQL Pool

Not sure on whether to choose Serverless versus SQL Dedicated Pools with Azure Synapse Analytics? Brad Schacht joins Patrick to talk about how to make the choice and get going with your data!
Serverless SQL Pool
learn.microsoft.com/azure/syn...
Dedicated SQL Pool
learn.microsoft.com/en-us/azu...
Brad Schacht:
Twitter: / bradleyschacht
LinkedIn: / bradleyschacht
Blog: bradleyschacht.com/
📢 Become a member: guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#AzureSynapse #sqlpools #GuyInACube

[@donavindrummond5146]

Would love to see some deep-dive detail about using both serverless and dedicated sql pools to handle different layers within a data lake when building a data platform.

[@Elkhamasi]

Keep them coming. I am learning synapse and this was helpful

[@matheusosa]

That video was very informative! Great great video!

[@teluguoffice5498]

Hey, I am just checking same concept on Internet and got your notification in KZbin. Its awesome.

[@coding3438]

Usually great stuff but this video seemed like a pure marketing stuff from the channel. Of course dedicated gonna be much more powerful because of strict schema and way more compute available. But it’s also very expensive.

[@JuanHernandez-pf6yg]

Very useful. Thank you.

[@culpritdesign]

Amazing content! 🔥

[@mohamedtarek-gh4fr]

As always, wonderful, I like this channel the most this video is very wonderful, very helpful, very informative again you were great Guys (in the cube :) )

[@premcst]

Great stuff . I am trying synapse and other Azure offerings .. These short videos are great .. Can you also do a video so we can understand which is the efficient way to do ETL and load to PBI ..

[@culpritdesign]

This looks great for data virtualization for raw sourcing into the data warehouse.

[@germanareta7267]

Great video

[@rudroroy1054]

Q: how can I automate the pausing of the dedicated pool? Does it come with scheduling options?

[@lucasshipsides1510]

awesome video, i had no idea autopause was a thing!

[@bibianasalazar7576]

It will be nice if we have some cost and capability comparison on premise, serverless and dedicated sql. Is the principal question a manager or a customer asks when offering this kind of solution.

[@djibrildione4612]

Great Video, I would like to know if we can expose the serveless External Tables or View Via API for web application to consume? is Data API builder an option?

[@vinaynagrani7954]

What I found is that External Tables on serverless sql pool are like views. So you can't perform any DML operations in serverless sql pool which defeats the basic requirements of a DB

[@joneskiller8]

Can you talk about the pricing for the Serverless Sql Pool, thanks!

[@sasanknimmagadda2010]

Ya this is definitely a good introduction to understand the difference between Dedicated vs serverless SQL pool. You should have added about Spark SQL pool also... what is that and how is that different?

[@7anishok390]

Hi Please help me. I have created an external table in the synapse lake database, Now I like to load the records from the external table into the dedicated SQL pool table. Please advice on the procedure.

[@qaz56q]

Is there a possibility to connect Synapse SQL Dedicated Pool from Powerbi using service principal?

[@sherifffruitfly]

Note: with columns that take on values that are very large (e.g. json bits stored in col values), the simple syntax demo'd here won't work. This is because the inferred data type is varchar(8000). To bring back larger strings, you'll need to schematize the data in the query via the WITH construct, setting such cols to varchar(max) data type. Why varchar(max) isn't the default inference is beyond me.

[@aspnerd]

Why was dedicated 2 seconds vs. Serverless at 30 seconds? Is the hardware not the same on the back end? What’s the difference?

[@takistewart3404]

Assuming you can meet SLAs with each. I guess cost is the biggest contributing factor

[@CrimsonTheOriginal]

Our issue with Serverless is its wildly inconsistent. 2m row table 30 seconds to load and then 5 mins later that same 2m row dataset now takes 7 mins. Any way we can address this?

[@MDevion]

Nope this is the downside is sharing resources with other users.....

[@rob5800can]

Lot of heavy breathing on that mic bro. Haha

[@foxware5587]

Again!

[@MDevion]

Dedicated pools are just too expensive for any serious DWH stuff. Also its just Parallel Data Warehousing in the cloud, which is a horrible application to begin with. For me, I never use dedicated pools, I either use serverless or a Azure SQL DB. Now the downside with the Azure SQL DB is that microsoft enforces a recovery model of FULL, instead of SIMPLE like we had on onpremise. But that is on purpose, or simply no one would ever use dedicated pools as the difference would be too small. The whole MPP never sold me and it always performed like shit or could be done WAY better with some custom code. There some many improvements left for Microsoft to do in Azure, but some will be against their own business interest. Despite all the negativity in this post, I do love serverless SQL pools and its a huge step in the right direction. P.s. Also the presenter is DEAD wrong on dedicated pools. You dont choose this because of performance. You choose this as it fits your scenario. It is NOT faster at all, its faster at CERTAIN workloads. To make this comparison in with the serverless and dedicated Power BI load is very misleading.

[@bibianasalazar7576]

Thanks so much for sharing this point of view. 😀

[@terryliu3635]

Fully agree! Microsoft needs to figure out the future for dedicated sql pool! It might fit some specific scenarios however so far building the next gen enterprise data platform during recent years, I’ve not seen one case yet that we have to leverage the dedicated sql pool. In my opinion, Microsoft probably eventually have to sunset that!

[@darins]

Have you used incremental refresh in PQ on an ASA Serverless SQL pool?

[@iulianbina7910]

Reserved 3 year is 300 dollars per 100DWU per month. Pay as you go is 1000+ Dollars So I guess that is a huge difference. Dedicated makes sense when you reserve it for 3 years. Sure... you don't get the option to turn it off but the workloads suited for this kind of service is intended for high availability just like direct query reports. But that means you do your data modeling in SQL and keep it minimal in PBI

[@tryfonmichalopoulos5656]

The heavy breathing though; gotta go see a doctor man

[@mandarnandre7387]

Please dont breath on mic man, It feels like you are brething in my ears 🥹🥹🥹 I am just hating it 😡😡 Please do something, I can't concentrate on what the guest is saying