It has been a while since I did any programming, but I was reasonably good at it.

Certainly if I asked an AI to generate some code for me to do...

I am retired now, but I always thought upgrading in place is a brave thing to do. Brave as in risky, too risky to do for a production instance.

I once...

This will start a bit off-topic but I will get to MS eventually...

My introduction to computing was in what is now called year 11, but back then was year 5...

I wouldn't be surprised if Broadcom owned both z/OS and Windows by 2035

Times have moved on and we are now looking at EOL of Windows 10 and where to go after that.

But first a bit of history. Unlike Steve, I really liked...

Yes, the thumbprint needs to be the same on all the nodes.

I don't have an environment to test this, but I did have a fileshare on a SQL cluster in the past so I hope I can remember it all.

To have...

I don't have an environment to try this out but Johan's response may be part of the answer.  But there are some fundamental issues that need to be overcome.  I...

I found it is best to create the SPN manually, and assign to it the permissions it needs.  Doing things this way also requires that you use the same port...

• This reply was modified 7 months, 4 weeks ago by EdVassie.

This happened to me, but in reverse.

I used to have some expertise in DB2, both on mainframe and *nix.  I attended and spoke at conferences for DB2 and was very...

Once you have a function that works, include the WITH SCHEMABINDING clause in the function definition. It will run much faster.

From your command it looks like you are using SQL native backup. There are other backup products out there (eg SQL Litespeed) that have as part of their USP the...

When upgrading to a new version of almost anything there are likely to be winners and losers. SQL Server is sadly no exception. New code that improves a majority of...

Your organisation really does need someone whose job is to focus on DB performance and availability. The normal job title for this role is DBA.

There are a lot of aspects...

If this is a sensitive system that your organisation may rely on as evidence in a court case, then be aware that deleting or changing any data in the audit...