13. Server less SQL Pool Overview in Azure Synapse Analytics

[@anandgupta7273]

Dear Maheer, I wanted to express my deep appreciation for the incredible Azure videos you create on your KZbin channel. Your content has been an invaluable resource in my learning journey, and I have benefited greatly from the courses I have taken from your channel. I have also enthusiastically recommended your channel to others, and they have expressed their admiration for your expertise and teaching style. Recently, I have noticed a growing trend during phone calls and interviews where the topic of Azure Data Lake Storage (ADLS) in conjunction with Azure Services arises. It has become increasingly important to have a strong understanding of ADLS and its integration with other Azure services in order to succeed in these discussions. Therefore, I would like to kindly request that you consider creating a series specifically dedicated to ADLS. Such a series would be immensely beneficial not only to me, but also to your dedicated viewers. Once again, I extend my heartfelt gratitude to you, Maheer, for the remarkable effort you put into creating valuable content. Your commitment and passion for sharing knowledge have made a significant impact on the Azure community. Please continue your exceptional work, as it truly inspires and empowers aspiring Azure professionals like myself. Thank you once again, and may you continue to thrive and achieve great success.

[@alfredsfutterkiste7534]

Hands down the best information on synapse on youtube. What I especially like is that you show little details and reiterate on formerly mentioned concepts to reinforce learning. You are doing more than just the typical rattling off the documentation that other youtubers do on new subjects like AZ. Very good job.

[@WafaStudies]

Thank you so much for your kind words 🙂

[@prachirandive.7195]

Thank you for the quick,crisp and useful information

[@WafaStudies]

Welcome 😊

[@himanshutrivedi4956]

Wonderful..Thank you so much rock star for starting this series..

[@WafaStudies]

Welcome 🤗

[@sirojiddinsobirov5508]

Awesome, your rock bro!

[@WafaStudies]

Thank you ☺️

[@rajdeepsinghborana2409]

Sir please make videos , how to Connect Spark with Kafka and processing live data in Azure 🙏🏻

[@deepak0417]

Awesome going

[@WafaStudies]

Thank you 😊

[@KaustubhTendulkarpro]

If you highlight sql query n run then it will execute the highlighted one I think. Hence, it was showing error. Otherwise, your query was correct. So I think we can highlight n execure part of the sql query or we can run the complete query without highlight. Please correct me.

[@elhamfallah3801]

you are really great. thanks a lot

[@WafaStudies]

Thank you 😊

[@iamnottrader]

Hi Thanks for your video, Is it possible to implement encryption at rest for serverless sql pull, and decrypt the data while reading ?

[@erpoojadak]

In enterprise applications serverless or dedicated sql pool is recommended?

[@mutayabsandhu673]

Very informative, cleared my views on Serverless. Can you share any resources for learning serveless pool?

[@lib133]

Hello Maheer. First of all: thank you for the amazing content! this tutorial series is great! I was hoping you could help me understanding something. It's not clear to me what the "schemas" section of the "database" created in a serverless pool represent. I understand that this db doesn't actually have any storage and it just provides an interface for us to use TSQL. but what about the schemas? when I create a db, there are some schemas already, but these schemas do not have any tables, at least I can't see them nor query them. Can you elaborate this aspect? I think it would be a great complement to this video

[@rodneychan1227]

After creating a Synapse workspace - How do I grant another user access to the built in serverless SQL pool? The user can login to Synapse but they are hitting an error "unauthorized" when trying to open the built in SQL pool

[@NasimaKhatun-jb7qo]

Hi, Can you tell me if adf linked service can connect to serverless sql pool(buit-in)

[@WafaStudies]

Yes we can connect. The way we connect to SQL server it's same. We should use serverless SQL end point as server name in linked service

[@rijubajracharya2996]

Hello Maheer. I really appreciate for your help in giving information related to ADF and Synapse Analytics. All your videos are really informative and useful. I have a question regarding Synapse. Can we able to import CDM format file ? The column header and rows (csv) comes in separate files in folder. If we read just csv there would be no header information. Do you know how we import the header too from manifest file? Thank you in advance.

[@cebabu]

Hope you are doing well. I have JSON object stored in ADLS in hierarch. I am unable to read JSON data using external tables(CETAS). Could you please share link/videos to read JSON data.

[@ajaykumar-rh2gz]

Sir... Please teach us Databricks and how to perform a transformation

[@ManishSingh-if9nj]

Hello Maheer ..Thanks for such a informative video ..We are using serverless pool in Synapse platform ..Cost was one of the reason to choose serverless pool ..Now realizing it has got lot of limitation .1 Dynamic data masking not possible with serverless 2. all prebuild DMV you cant run on serverless ..3. Can't run script to do Workload Management ..Do you have any suggestion ..

[@parthiban.s4291]

Notes should linked to vedios please sir do it

[@soumikdas7709]

Hey man there are too many ads in your video. Most irritating .

[@Pratik_Tortikar]

Dude, buy youtube premium. The maker also has to earn, you can't get everything for free. This guy is already doing awesome job. So just buy youtube premium and start learning.