Azure Database Support Blog
Home
Options
301
Ricardo_NS_Marques on 05-22-2020 02:44 AM
966
FonsecaSergio on 05-15-2020 09:52 AM
1,812
FonsecaSergio on 04-08-2020 05:36 AM
1,185
Mustafa_Ashour on 04-04-2020 08:29 AM
708
Jose_Manuel_Jurado on 03-25-2020 06:51 PM
2,498
Jose_Manuel_Jurado on 03-21-2020 08:46 AM
632
Jose_Manuel_Jurado on 03-20-2020 12:54 PM
752
Jose_Manuel_Jurado on 03-17-2020 02:02 PM
457
Jose_Manuel_Jurado on 03-12-2020 10:11 AM
1,020
Jose_Manuel_Jurado on 03-11-2020 01:54 AM
773
Jose_Manuel_Jurado on 01-27-2020 04:09 AM
697
Jose_Manuel_Jurado on 01-16-2020 10:28 AM
626
Jose_Manuel_Jurado on 01-15-2020 12:18 PM
605
Jose_Manuel_Jurado on 01-13-2020 08:18 AM
1,032
Jose_Manuel_Jurado on 12-30-2019 04:25 AM
1,257
Jose_Manuel_Jurado on 12-20-2019 04:06 PM
1,126
Jose_Manuel_Jurado on 12-20-2019 03:48 PM
743
Jose_Manuel_Jurado on 12-02-2019 02:02 PM
1,103
FonsecaSergio on 11-27-2019 09:37 AM
662
Jose_Manuel_Jurado on 11-18-2019 12:04 PM
766
Jose_Manuel_Jurado on 11-17-2019 04:42 AM
587
Jose_Manuel_Jurado on 11-15-2019 10:12 AM
897
FonsecaSergio on 11-15-2019 09:45 AM
666
Ricardo_NS_Marques on 11-06-2019 09:44 AM
Latest Comments
I'm wondering if the line print 'create certificate MY_Certificate from binary = 'should have been print 'create certificate ''' + @certName + ''' from binary = ' Also the line with CERTPRIVATEKEY, should have printed something, I think.In my case, it does not. The docs states that 3 parameters must...
0 Likes
@balineprem some part of this can be checked on Log Analytics and you can use a tool like Azure SQL Analytics (Preview) at least for SQL and SQL MI. But as Synapse may have its particularities and if you are having issues I recommend opening a Support Case for further investigation and advisory.
0 Likes
Hi @sreedxc please follow the link at the first line in this article ... it will lead you to the procedure page where you can download the code to create the maintenance procedure. here is the link again for your convenience: https://blogs.msdn.microsoft.com/azuresqldbsupport/2016/07/03/how-to-maint...
0 Likes
i followed the steps and getting error error Couldnt find stored procedure dbo.AzureSQLMaintenance . How to fix this error>
0 Likes
Hi @FonsecaSergio ,It's nice to see you through this platform and all the three series of articles are very good. I have one request, could you please let me know is there a way to find the idle sessions (connection to the database persists but no activity since days), long running queries or heavy ...
0 Likes