Azure Database Support Blog

  • 277Blog Articles
Options
669
Diego_N on 10-28-2020 09:04 AM
342
MelaniaNitu on 10-28-2020 07:37 AM
734
Thamires_Lemes on 10-23-2020 09:55 AM
820
Thamires_Lemes on 10-23-2020 09:29 AM
1,134
Jose_Manuel_Jurado on 10-21-2020 04:26 PM
1,091
Jose_Manuel_Jurado on 10-21-2020 03:50 PM
1,185
MelaniaNitu on 10-20-2020 01:28 AM
1,425
MelaniaNitu on 10-20-2020 01:28 AM
1,195
MelaniaNitu on 10-20-2020 01:28 AM
623
FonsecaSergio on 10-08-2020 06:48 AM
621
Jose_Manuel_Jurado on 09-30-2020 05:22 PM
565
Jose_Manuel_Jurado on 09-30-2020 03:56 PM
677
Mousa_Janini on 09-29-2020 04:24 AM
633
Jose_Manuel_Jurado on 09-11-2020 11:57 AM
715
Jose_Manuel_Jurado on 09-11-2020 11:36 AM
974
Jose_Manuel_Jurado on 09-11-2020 07:11 AM
738
Jose_Manuel_Jurado on 09-11-2020 02:54 AM
891
Jose_Manuel_Jurado on 09-10-2020 04:46 PM
1,441
FonsecaSergio on 08-06-2020 04:28 AM
2,899
FonsecaSergio on 08-04-2020 04:15 AM
981
Mousa_Janini on 07-27-2020 06:52 AM
1,334
Jose_Manuel_Jurado on 07-01-2020 11:46 AM
838
Jose_Manuel_Jurado on 06-22-2020 06:55 AM

Latest Comments

So, when the logs are not written how do we get alerts? where is the alert coming from and what metric is triggering this alert?
0 Likes
Hi @Myat_Thet , yes, you can wrap the execution in a loop that go trough each database. you need to make sure the procedure created in each database as we have no cross-database query ability for Azure SQL DB. however, I would suggest you to use Elastic Jobs instead, there you can target the databas...
0 Likes
Hi @Yochanan_MSFT Your article is very helpful and thanks for providing very detail information.Is it also possible to loop all databases in the given SQL Server instead of passing specific database name as below? $AzureSQLServerName = "<ServerName>"$AzureSQLDatabaseName = "<DatabaseName>" This is b...
0 Likes
The other way around would be interesting too ;) Let Azure Synapse SQL-on-demand query Azure SQL DB. So that we can enhance the flat files on blob via SQL-on-demand with some lookup tables stored in Azure SQL DB.
1 Likes
@KMS2222 you may need to open a case to further investigate this issue
0 Likes