Azure SQL Database

Options
607
MarisaBrasile on 08-06-2020 10:17 AM
1,066
MarisaBrasile on 08-05-2020 11:49 AM
1,261
urmilano on 08-05-2020 07:00 AM
1,300
MarisaBrasile on 07-30-2020 09:00 AM
1,809
Shoham Dasgupta on 07-27-2020 12:19 PM
939
MarisaBrasile on 07-23-2020 09:16 AM
3,266
Dimitri_Furman on 07-23-2020 07:30 AM
1,930
Morgan_Oslake on 07-23-2020 07:00 AM
949
MarisaBrasile on 07-21-2020 09:05 AM
794
MarisaBrasile on 07-16-2020 09:00 AM
1,475
MarisaBrasile on 07-14-2020 09:00 AM
902
MarisaBrasile on 07-09-2020 09:39 AM
2,090
Anna Hoffman on 07-07-2020 09:00 AM
5,438
Mohamed Kabiruddin on 07-06-2020 06:24 PM
1,128
MarisaBrasile on 07-02-2020 09:00 AM
1,741
MarisaBrasile on 06-30-2020 10:41 AM
804
MarisaBrasile on 06-25-2020 09:48 AM
1,282
MarisaBrasile on 06-18-2020 11:57 AM
3,057
Dimitri_Furman on 06-16-2020 07:45 AM
2,428
MarisaBrasile on 06-02-2020 09:00 AM
3,770
Denzil Ribeiro on 05-29-2020 01:50 PM
1,828
MarisaBrasile on 05-28-2020 09:51 AM
2,755
Adrian_Rupp on 05-26-2020 12:22 PM
2,142
MarisaBrasile on 05-21-2020 09:48 AM
3,675
weiqingtu on 05-15-2020 06:06 PM
3,684
MarisaBrasile on 05-14-2020 04:43 PM
5,328
Danimir Ljepava on 05-14-2020 03:58 PM
3,300
Danimir Ljepava on 05-14-2020 03:57 PM
1,298
DavidTrigano on 05-13-2020 10:57 AM

Latest Comments

AzureSQL is indeed very useful. The blog was quite interesting. Looking forward to more of such blogs. @MarisaBrasile
1 Likes
@AmolAgarwalSQL I understand, but IMHO the limitation is more bound to how MSI is handled on the SQL side. With other types of Azure resources I can set privileges using MSIs directly in my ARM template, so I'm guessing that the user deploying the template needs to have basically Directory Readers r...
0 Likes
@arek-avanade SQL needs to talk to AAD to verify the AAD user that you are about to give access too. SQL can't talk to AAD with SPN token itself as AAD does not allow that, so only way for SQL to talk to AAD is to use MSI. And AAD only allows that if MSI has Directory Readers permissions. So, in sen...
0 Likes
Thanks @AmolAgarwalSQL. Now I understand 'server identity' is just like MSI that I usually assign to my App Services. I realized there is a serious limitation in the above solution - if server identity needs to be part of Directory Readers role and I want to run all of this from build pipeline, that...
0 Likes
@arek-avanade , #1. There is no portal support currently in sql blade where you see server identity. If you go to AAD blade -> Enterprise applications -> all applications . In drop down select application type = all applications, there if you give server name, you can see the identity. #2. There is ...
0 Likes