Hi Theo, could you please confirm if the JSON file in your portal is not being updated anymore ?

Hi Theo,

Is the JSON not being updated now ? 🙁

I don't see information about latest SQL patch for 2017 (CU 26) and SQL 2019 (CU13)

Regards,

Sajal Bagchi

Thank you so much. You are a saviour !! 🙂

One small request- if you could also include KB number in your Json as I had to strip KB from URL to list it in separate field, which is not...

set nocount on;
DECLARE @Object AS INT;
DECLARE @json1 AS TABLE(Json_Table NVARCHAR(MAX));
DECLARE @jsondata NVARCHAR(MAX);
DECLARE @json AS NVARCHAR(MAX);


EXEC sp_OACreate 
     'WinHttp.WinHttpRequest.5.1', @Object OUT;
EXEC sp_OAMethod @Object,'open',NULL,'get','http://sqlbuilds.ekelmans.com/sqlbuilds.json','false';
EXEC sp_OAMethod...

• This reply was modified 2 years, 8 months ago by  sajal19866.
• This reply was modified 2 years, 8 months ago by  sajal19866.
• This reply was modified 2 years, 8 months ago by  sajal19866.

First of all thanks Theo for putting your efforts !

I have automated SQL patching in our environment and I had been using data from the tables tblBuildList and tblBuildListImport from...

We are facing the same issue, where restore job is taking way longer than what it used to take before. Tried to manually restore the log file after pausing the...

We faced exactly the same issue and found Database Auto_Close Option is set to 'True'. We set it False and put database offline and online. The error message stopped popping...