Hi Ozzie,

Every once in while i check in to see if anyone has problems with the last version of the script, and adapt it when needed.

But thusfar everyone seems happy...

Hmmm.....

Interesting article Jeff!

For the life of me, i would never have considered the impact of Format on out larger OLTP loads.

Knowing you being rather thorough, one question question was left...

Hmmm....

Correct me if i'm wrong; if JAVA is not installed on that SQL server, there should be no environment to load the log4j.jar into?

In that case the sql server should...

Hi Sajal,

I have added a new Json file to my website with the KB column you wanted:)

grtz, Theo.

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

Hi Darryl,

No, the purpose of this script is to update a table on one of your central SQL management servers with the list of all available patches for all SQL...

• This reply was modified 3 years, 4 months ago by  Theo Ekelmans.

Hi Sajal,

I have spoken with the author of the https://sqlserverbuilds.blogspot.com/website, and we agreed upon stopping with screenscraping, hence the move to sqlserverbuilds's google docs.

Does your WGET still have...

• This reply was modified 3 years, 4 months ago by  Theo Ekelmans.

And as promised, here is the new script that will download SqlServerBuild's google TSV file and import it into the original data model of this article:

Use ServerInfo
GO
ALTER...

• This reply was modified 3 years, 4 months ago by  Theo Ekelmans.

Yup,

That fixes the missing last line.

Thanks 🙂

<updating script>

• This reply was modified 3 years, 5 months ago by  Theo Ekelmans.

Hi Guys,

Like the admin of SqlServerBuilds site said...  There is a now better way than screenscraping to get the data from his awesome site ! 🙂

The code below is just...

• This reply was modified 3 years, 5 months ago by  Theo Ekelmans.
• This reply was modified 3 years, 5 months ago by  Theo Ekelmans.
• This reply was modified 3 years, 5 months ago by  Theo Ekelmans.

Hi Tim 🙂

Just checking... you did download the latest version of the script ?

http://www.ekelmans.com/FTP/Web/ImportSqlserverbuildsBlogspotCom.sql

• This reply was modified 3 years, 5 months ago by  Theo Ekelmans.

I have been looking at the code, and I think this could also be used to create rollout scripts for the jobs on new SQL servers from a template SQL...

• This reply was modified 3 years, 10 months ago by  Theo Ekelmans.

Wow...

I never thought about using a restore of msdb in this way. ??

I'm going to paste a link to this article in our operations wiki as a "howto"

Thanks for this...

Hi Bob.

This article also applies to VM's, even the cloud ones. If for some reason the underlying infrastructure has an issue that impacts your "local" drive this scenario will happen.

I.E,...

Hi Ant....

There is a caveat here.... if the local disk with the tempdb fails, SQL will *not* initiate a failover. My colleague Twan and I have written an article detailing...

For those DBA's that would like to see a traceflag added to alter the behaviour of SQL on this problem, please upvote on this link

https://feedback.azure.com/forums/908035-sql-server/suggestions/42354733-sql-cluster-does-not-failover-on-loss-of-local-dis