Thanks for the script. I had a quick play today and the it failed on the first job I tried it on 🙁

It doesn't handle single quotation marks well in...

The security patches change the build level so it stands to reason that they are cumulative.

Hopefully someone has a proper list for you but it would be something along the lines of:

Cancel automatic seeding for the distributed group (seeding mode = manual).

On SQL2P - ALTER...

• This reply was modified 4 years ago by  CC-597066.

Ideally all your SQL servers should show a green arrow.

I find that I have to enable a couple of firewall rules for Windows Management Instrumentation for that to happen, DCOM-In...

We tend to upgrade soon after a new version is out as the devs like playing with all of the new features. If you are going to May 2020 you...

A message is put in the SQL Server Log when it is changed that says what the old and new values are e.g.

Configuration option 'max server memory (MB)' changed from...

There is no problem running different versions of SQL Server on the same machine but you could potentially see issues if you then want to uninstall 2017 once you have...

I have been working at the same place for 14 years and many of the systems we still use predate me. One of our critical systems running on Informix will...

2 out of 73 are physical.

The majority of our SQL servers, including Prod ones, have been virtualised for at least 10 years.

I have used a similar process to downgrade some of our Enterprise servers without issue. As others have mentioned, you will have downtime to contend with but if that isn't...

Ha, I dream of 64GB! I currently have 6 servers with 4GB, 7 servers with 8GB and the rest (23) ranging from 12GB to 50GB.

Our SAP and BW...

We have a number of databases that get copied to a reporting server every night and just use backup and restore. 50GB isn't very large by today's standards so the...

When the package does its hourly run, it generally moves data in to an Archive table so it is only reporting or alerting on the current set of data. I...

I built an in-house monitoring system based on Rodney Landrum/David Bird's SSIS packages 10 years ago and it is still going strong today. I have expanded it quite a bit over...