{ "errorCode": "2108", "message": "{\"error\":{\"code\":\"AuthorizationFailed\",\"message\":\"The client 'xxxxxxxxxx' does not have authorization to perform action 'Microsoft.Sql/servers/databases/pause/action' over scope '/subscriptions/xxxxxxxxxxxxxxx/resourceGroups/xxxxx/providers/Microsoft.Sql/servers/xxxxx/databases/xxxxxxx' or the scope is invalid. If access was recently granted, please refresh your credentials.\"}}", "failureType": "UserError", "target": "Web1", "details": [] } can you solve this error
@1vasudevarao8 ай бұрын
Hey Mark, This rest api will expire? When I try to do the way you are doing.... I'm getting authentication error, even though I provided all required access
@1vasudevarao8 ай бұрын
It worked...
@MyZive Жыл бұрын
Maybe you should try not riding in the middle of the lane
@sebikkos Жыл бұрын
Exactly
@robjfarley Жыл бұрын
Glad you’re okay.
@mathewjamesn Жыл бұрын
Good one. Thanks
@danielwelenc Жыл бұрын
Hi Mark! Is there a way to disable enforced dependencies on MVs?
@AmberBhanarkar Жыл бұрын
From where did you get the server name at 7:27?
@ayyappagorrala7350 Жыл бұрын
just what i was looking for. Thanks mate!
@bellahao1344 Жыл бұрын
technically meaningless
@jovanai2 жыл бұрын
Thank you so much! This is exactly what I needed.
@ToanNguyen-wc9dr2 жыл бұрын
Thank for your sharing. Could you help to share how to move SQL Pool to another Subscription?
@bantasingh14702 жыл бұрын
Thanks for sharing.
@masoudpesaran97212 жыл бұрын
Very interesting point
@mitrareddy79462 жыл бұрын
I am getting an error that the database has no stored procedure 'EXPLAIN'. How to resolve this issue?
@MarkPryceMaher2 жыл бұрын
The explain works on a statement level (select/update/delete/etc). A proc can have many statements.
@alexphatelevich3876 Жыл бұрын
@@MarkPryceMaher The same error ... Could not find stored procedure 'EXPLAIN'. SSMS 18.2 , SQLSERVER standard edition : 2019
@MarkPryceMaher Жыл бұрын
@@alexphatelevich3876 EXPLAIN is a feature of the dedicated SQL pool, it isn't supported in SQL SERVER.
@jamieclarke26947 ай бұрын
The EXPLAIN part only worked for me in Azure Data Studio, not in SSMS, in case that helps anyone.
@ateekain57392 жыл бұрын
Can Synapse simultaneuosly connect to two azure cosmos DB at a time and query them together.
@MarkPryceMaher2 жыл бұрын
I dont see whay not, two linked services.
@hochun8362 жыл бұрын
in ssms ui, is there a way to show "table value function" ?
@parthasarathyrangarajan61842 жыл бұрын
I am not able to see , but can use them ...you found any solution?
@imthi82 жыл бұрын
How to connect a Synapse Serverless view from the Data Flow (ADF).Do I have to create a linked service ?
@MarkPryceMaher2 жыл бұрын
Just connect to it in exactly the same way you would connect to a sql server/sqldb.
@RamaKrishna-lu2he3 жыл бұрын
Excellent demo Mark, thanks for the demo
@mithunpuneet31873 жыл бұрын
Can we create PowerShell without using Automation account?
@MarkPryceMaher3 жыл бұрын
Yep, or course you can. The automation account is just a way of executing the powershell.
@mithunpuneet31873 жыл бұрын
@@MarkPryceMaher Thank you Mark! Can you please make a video? I tried running the script, here below is the link for the same :- docs.microsoft.com/en-us/answers/questions/492302/pauseresume-dedicated-sql-pool-using-power-shell.html?childToView=495402#answer-495402
@MarkPryceMaher3 жыл бұрын
Doh! I apologise - I get carried away and forgot to make us full screen for about 7 minutes!
@CoopmanGreg3 жыл бұрын
Good video plus the subtle humor :)
@MarkPryceMaher3 жыл бұрын
Glad you enjoyed it!
@travischristensen7463 жыл бұрын
Maybe this was answered already, but after choosing authentication MSI and for the resource, where does this link come from 'management.core.windows.net'. I'm very new to Azure so i'm still learning a lot
@MarkPryceMaher3 жыл бұрын
I got it from a friends video - but if you pick MSI , put the wrong info in. You will see an error message and it will tell you what it should be in the error message. The actual details are on this page : docs.microsoft.com/en-us/rest/api/azure/ - Scroll down and find 'Request URI'
@travischristensen7463 жыл бұрын
@@MarkPryceMaher Thank you for the response.
@travischristensen7463 жыл бұрын
@@MarkPryceMaher thank you, I got it working, now I'm just trying to figure out how to parameterize the url, because we use arm templates
@sherifffruitfly3 жыл бұрын
Trying to do this with the ADF-built-into-synapse and not getting success. When I get to the role assignment part @ 8:56, i can't find the managed identity - nothing shows up under data factory or the other services. Is there a different process for the ADF that's BUILT IN to synapse?
@MarkPryceMaher3 жыл бұрын
The MSI is the name of the workspace.
@sherifffruitfly3 жыл бұрын
@@MarkPryceMaher thank you!
@GuruVideoAC3 жыл бұрын
The board is distracting than helping.
@romangaleev51503 жыл бұрын
Hey Mark, I faced with an issue : AuthorizationFailed","message":"The client 'XXX' with object id 'XXX' does not have authorization to perform action. Thoughts?
@itsobzcure3 жыл бұрын
I'm also getting same error
@romangaleev51503 жыл бұрын
@@itsobzcure Hey man, I found out that this approach is outdated and dosn't work. Please use PowerShell scripts and put them into Automation Account Runbook part.
@BlackSmith11553 жыл бұрын
@@romangaleev5150 wondering why you think it's an outdated solution? It's just working fine if implemented correctly! I got your same error initially, for the servername make sure it's just the name not name.database.windows.net (hope that helps)
@daivdbruce3 жыл бұрын
Nice explanation Mark. Please make more videos on Synapse
@MarkPryceMaher3 жыл бұрын
Thank you, I will
@ukasz22633 жыл бұрын
0:40 virtual-chat-girls.online
@MarkPryceMaher3 жыл бұрын
The back to the future doc is called 'Back in Time' -> www.amazon.co.uk/Back-Time-Steven-Spielberg/dp/B01835ABCU/ref=tmm_aiv_title_0?_encoding=UTF8&qid=1606345662&sr=8-8
@miklosboros69423 жыл бұрын
Great! Do you have any solution for synapse workspace and dedicated SQL pool? Thanks for your help!
@miklosboros69423 жыл бұрын
I found the solution : docs.microsoft.com/en-us/rest/api/synapse/sqlpools/resume But you helped a lot, thank you very much!!!
@MarkPryceMaher3 жыл бұрын
Yes, its possible. Its identical if you do it from Intergrate (The ADF stuff thats built into Synapse workspace) But you will notice the API version has changed. Thanks for the link.
@sanniepatron82603 жыл бұрын
excellent, thanks for the video, I am just having some problems to configure the server because I am using SQL endpoint "name.sql.azuresynapse.net" and it's not working, do you have some advices for that?
@yaroslavfomenko28034 жыл бұрын
Thank you, it helped a lot!
@MarkPryceMaher3 жыл бұрын
Glad it helped!
@ramarajudatla65444 жыл бұрын
how to get data from Synapse SQL pool (data warehouse) to python jupyter notebook
@fabiocarello65424 жыл бұрын
Thank you Mark! Just to be clear. This procedure creates a brand new SQL Pool directly into the Workspace starting from an external one. But does not move the original one. So in order to clean-up all the resources and optimize costs it's needed to delete the external pool. Am I right?
@MarkPryceMaher3 жыл бұрын
Yes, it creates a copy. So yes, you need to delete the old one. There will be a better process by GA.
@dawidtaciak3 жыл бұрын
@@MarkPryceMaher : hi Mark, it seems that there is no such enhanced migration process yet in place after GA. If we are creating a copy of existing database on the same server is connection string staying the same (or initial catalogue will change into the new pool name)?
@poojadhonde31694 жыл бұрын
Great!!
@arulmouzhiezhilarasan85184 жыл бұрын
Nice to know these things Mark Pryce-Maher! Thanks for sharing these know-how things, Sharing is always Caring!
@MarkPryceMaher3 жыл бұрын
My pleasure!
@vasantharajaselvaraj55434 жыл бұрын
Nice
@the.activist.nightingale4 жыл бұрын
This is GOLD
@MarkPryceMaher4 жыл бұрын
Thanks
@amitjaju90604 жыл бұрын
Hello Sir, How can I pause/resume azure SQL datawarehouse through automate process. Thanks for your help in advance
@MarkPryceMaher4 жыл бұрын
Oh no! I have done the video, but not uploaded it to youtube yet. I'll sort it out and get it updated.
@MarkPryceMaher4 жыл бұрын
Double Doh! I did upload it. Its here. kzbin.info/www/bejne/laS6nHx5bpx0kJY
@mqdesigns33198 жыл бұрын
+Mark Pryce-Maher Brother Its Giving an Extra Option on My Device in Installation.. Offline Registration Of Microsoft R Open? What Should I Do?? Help Please