Azure Database Support Blog

Options
1,586
jaigarcimicrosoft on Feb 02 2024 10:54 AM
1,272
Jose_Manuel_Jurado on Jan 16 2024 08:36 AM
1,400
Jose_Manuel_Jurado on Jan 16 2024 04:46 AM
1,266
Jose_Manuel_Jurado on Jan 16 2024 04:14 AM
1,846
jaigarcimicrosoft on Jan 16 2024 01:50 AM
1,928
Jose_Manuel_Jurado on Jan 14 2024 04:30 AM
2,010
Jose_Manuel_Jurado on Jan 13 2024 01:29 AM
1,258
Jose_Manuel_Jurado on Jan 11 2024 10:06 AM
1,513
Jose_Manuel_Jurado on Jan 11 2024 03:50 AM
896
Jose_Manuel_Jurado on Jan 08 2024 11:26 AM
1,829
Jose_Manuel_Jurado on Jan 08 2024 01:14 AM
2,402
Jose_Manuel_Jurado on Jan 07 2024 01:06 AM
1,639
Jose_Manuel_Jurado on Jan 05 2024 01:46 AM
1,291
Jose_Manuel_Jurado on Jan 03 2024 11:21 AM
1,478
Jose_Manuel_Jurado on Jan 03 2024 02:46 AM
1,406
Jose_Manuel_Jurado on Jan 03 2024 02:00 AM
1,491
Jose_Manuel_Jurado on Jan 02 2024 03:53 AM
1,929
Jose_Manuel_Jurado on Dec 27 2023 11:04 AM
1,840
Jose_Manuel_Jurado on Dec 22 2023 01:57 AM
1,720
Jose_Manuel_Jurado on Dec 21 2023 10:55 AM
2,056
Sabrin_Alsahsah on Dec 18 2023 03:09 AM
1,839
Jose_Manuel_Jurado on Dec 17 2023 01:33 AM
1,529
Jose_Manuel_Jurado on Dec 16 2023 04:07 AM
1,607
Jose_Manuel_Jurado on Dec 15 2023 10:14 AM
1,563
Jose_Manuel_Jurado on Dec 06 2023 03:05 AM
2,361
Jose_Manuel_Jurado on Dec 01 2023 11:26 PM

Latest Comments

@phSTC don't see anything wrong in terms of the configuration. But what I can see is that the error message states that an access token was not found on the response from Entra (aka AAD). If the access token was not granted to the managed identity, then it is not possible to connect to the remote Az...
0 Likes
@luisaranda Thank you - I believe I have enabled "system managed Identity"I now understand to use "name of my managed instance" - my step #3I still have issue - test connection failsMy steps#1. turned on System assigned managed identity #2. verify my SQL MI has a configured - Entra Admin >> it does ...
0 Likes
@phSTC azuresqlmi2 is the name of my managed instance. In your environment, the name should be adjusted to the name of your managed instance. Before running this TSQL script you have to make sure you have enabled the "system managed identity" of the SQL MI in the Azure Portal. The azure platform wil...
0 Likes
I am having difficulty creating the linked server on my system.A connection test gives result: Failed to authenticate the user '' in Active Directory (authentication option is AcvtiveDirectoryMSI).Would you please unpack your statement - I think this step is throwing me:First, I created a contained ...
0 Likes
Hi!In part 1 you said that minimizing logical reads is critical to query performance. The article below shows that a 96% reduction in logical reads results in a saving of only 200ms. Please see the link below and add your comments about it there:https://www.mssqltips.com/sqlservertip/7911/sql-server...
0 Likes