There is a limit on the number of rows that can be displayed in a SSMS pane. This is because SSMS is not intended as a reporting tool.

You can check...

For us mere humans, we read IssueNo = 2 as the first condition to be satisfied, and think the convert(...) should only be done if condition 1 is true.

For SQL,...

USE statements can be tricky. I suggest splitting your code into two procs, one to test status and one to do actions.

You could make the test status proc a bit...

If there is no budget for monitoring tools that implies your business does not care if the service is up or down, it just wants things on a 'best-efforts' basis. ...

I am clutching at a straw here, as I have not seen this ctual problem.

I am wondering if there is some level of server-to-server authentication happening that is causing the...

My approach would be to try to isolated where the problem occurrs.

• Does it happen with all connections.
• Does SSMS connect ok.
• Is the problem connection from a process that...

If SQL reports an error, even if you think it is a false positive, you have a problem you need to deal with.

IMHO if you know that a new version...

I do not know DbDefense in any way, but I do know a bit about XPs.

The support for XPs will not disappear overnight. With the current SQL release cycle if...

Jeffrey is definitely on to something.

You can check this by looking at the SQL log on the node that is starting up, this will tell you how long it is...

Most of us know Murphy's law that 'anything that can go wrong will go wrong', but fewer of us realise that Murphy was an optimist.

Back in 2018 we had implemented...

You are going to have to do some troubleshooting.  What do your install logs say about the problem. If you don't know where to find the logs, check out the...

I agree that network issues can be a problem when doing a backup to a remote location, but if the network works correctly then having the backup stored remotely has...

• This reply was modified 10 months, 2 weeks ago by EdVassie.
• This reply was modified 10 months, 2 weeks ago by EdVassie.

To start with, you will test this all out in Dev, yes? This will give you the process to use for Production.

For an AG, all servers in the AG need...

Without knowing what happened, it does smell a bit like locking.

Before retirement I made fairly extensive use of columnstore indexes, but I also had snapshot isolation active. SI did a...

• This reply was modified 11 months ago by EdVassie.
• This reply was modified 11 months ago by EdVassie.

What you are asking for is why I developed SQL FineBuild. If you want it can automatically set up SQL Server 2019 on a cluster complete with AG and distributed...