Azure Database Support Blog
Home
Options
293
Ricardo_NS_Marques on 05-22-2020 02:44 AM
957
FonsecaSergio on 05-15-2020 09:52 AM
1,803
FonsecaSergio on 04-08-2020 05:36 AM
1,183
Mustafa_Ashour on 04-04-2020 08:29 AM
708
Jose_Manuel_Jurado on 03-25-2020 06:51 PM
2,483
Jose_Manuel_Jurado on 03-21-2020 08:46 AM
631
Jose_Manuel_Jurado on 03-20-2020 12:54 PM
752
Jose_Manuel_Jurado on 03-17-2020 02:02 PM
456
Jose_Manuel_Jurado on 03-12-2020 10:11 AM
1,020
Jose_Manuel_Jurado on 03-11-2020 01:54 AM
768
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
604
Jose_Manuel_Jurado on 01-13-2020 08:18 AM
1,031
Jose_Manuel_Jurado on 12-30-2019 04:25 AM
1,257
Jose_Manuel_Jurado on 12-20-2019 04:06 PM
1,125
Jose_Manuel_Jurado on 12-20-2019 03:48 PM
742
Jose_Manuel_Jurado on 12-02-2019 02:02 PM
1,098
FonsecaSergio on 11-27-2019 09:37 AM
662
Jose_Manuel_Jurado on 11-18-2019 12:04 PM
764
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