Viewing 15 posts - 1 through 15 (of 53 total)
We have one particular server that seems to cause a similar issue and the only way round it was to change the client timeout in the connection string in the...
June 9, 2022 at 2:28 am
The SQL Server Browser isn't required for the default instance if it is running on 1433.
You wouldn't be able to connect to a named instance on 1433 nor a default...
October 25, 2021 at 7:29 pm
I already had some of them and have just managed to get all but Vol 2 using google but they are all about SQL 2000 to SQL 2008 so you...
July 29, 2021 at 8:44 pm
Just stumbled across this while googling Change Tracking so I thought I would add that you can grant View Change Tracking at the schema level.
March 18, 2021 at 9:46 pm
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...
February 3, 2021 at 3:07 am
The security patches change the build level so it stands to reason that they are cumulative.
January 27, 2021 at 7:48 pm
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...
November 16, 2020 at 12:57 am
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...
September 8, 2020 at 12:43 am
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...
September 7, 2020 at 10:23 pm
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...
September 7, 2020 at 10:10 pm
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...
July 6, 2020 at 8:42 pm
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...
October 11, 2019 at 9:37 pm
2 out of 73 are physical.
The majority of our SQL servers, including Prod ones, have been virtualised for at least 10 years.
March 20, 2019 at 3:19 pm
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...
December 12, 2018 at 1:32 pm
Viewing 15 posts - 1 through 15 (of 53 total)