Using SQL On Demand with Serverless Compute in Synapse Analytics

Azure Synapse Analytics provides a way to do analytics with Serverless compute and SQL On-Demand. There are many ways to leverage this technology to reduce cost and for flexibility. In this video we take a look at how to leverage SQL On-Demand for Ad-hoc queries, ETL in pipelines and how to connect from Power BI!
If you enjoy this video and are interested in formal training on DAX, Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Mitchell30" to receive a discount at check out when purchasing On-Demand Learning classes from pragmaticworks.com/pricing/
#PragmaticWorks #MitchellPearson #MitchellSQL
~-~~-~~~-~~-~
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
• Free Power Apps Compon...
~-~~-~~~-~~-~

[@seanomeara745]

It would be great to see a video on best practices for data lake folder structures in relation to SQL Serverless directory parsing. How to set them up, what tools to use to maintain etc.

[@rmya9590]

The way you explain concepts are very clear. I watched some of your videos here on TH-cam, got impressed and purchased pragmatic works yearly subscription. I couldn’t find any your videos there unfortunately ☹️ other trainers are equally good but you are my favourite!!

[@PragmaticWorks]

That's awesome, appreciate the positive feedback! We try to rerecord the classes quite often to keep them up to date with changes so a lot of time classes I recorded originally have been rerecorded by someone else on the team who was available to update the course :) Thanks again! -Mitchell

[@alfredsfutterkiste7534]

Great video :)

[@fabiofmaia2011]

Nice video! Can we encrypt data at the container level on ADSL2? I mean column data level not Encryption at rest. On the SQL Serverless poll level, do we have only Hashbytes? Is there a way to encrypt sensitive data? Thanks

[@followmanish]

Can you talk more about that error which you run into while connecting to PowerBi, I am having same issue, can you guide to how resolve it

[@changalrayudu3151]

Hello Sir!
can we able to include the google maps in the powerapps

[@amitnayak4029]

please let me know when ever the data or record is deleted from the entity in the dynamics. how do we get to know which records is deleted and how to identify the deleted records in serverless pool

[@rajanikrishnam3748]

How do we connect to synapse pool using SSIS to pull data into Azure SQL DB(BI environment)

[@dmitrywroclaw9165]

So, in the end tried to connect and shows no results. Looks useless. How to get results in Power BI ?

[@sadaqatem]

Show me a single video where i can insert data to same table you just created in serverless please?