I also have been concerned that decreasing trust will result in decreasing capabilities in technology.

Libertarianism is a philosophy that is gaining popularity, but it is also one that results in...

As Ken says, these are very likely being produced by whatever process your infrastructure team is using to back up the entire server estate (all servers, not just SQL).

There definitely...

There are always performance winners and losers when you upgrade SQL server, but mostly you should have winners.

It is good that you have identified key queries that will be losers....

This will work and can be a good way to minimise downtime at cutover.

I would ask why you are going for SQL2017 rather than SQL2019 or SQL2022. In your position...

• This reply was modified 1 year, 6 months ago by  EdVassie.
• This reply was modified 1 year, 6 months ago by  EdVassie.

One problem you will have to deal with is authentication.  My old place wanted to do something similar and authentication was the biggest problem.

Microsoft allow a greater range of identity...

Likewise,

You can lead a user to data but you can't make them think.

Maybe you should ask them to name a sport where the winning team from 20 years ago could still be a winning team today using the same players.

Their formerly winning...

• This reply was modified 1 year, 7 months ago by  EdVassie.

I would not do this. If pushed very very hard by my management to do this I would resign.

The risks of having an unrecoverable system are very high. I remember...

I was hoping you would answer the questions I gave regarding host and client OS. It means I have to guess things with this response.

SQL2005 can be installed on W2000...

• This reply was modified 1 year, 7 months ago by  EdVassie.

I am assuming you are trying to connect to the SQL cluster via the virtual base only. You do not use any instance name when connecting to a SQL cluster.

If...

I am not sure this is a SQL2005 problem, or that it is any type of a problem.  When you connect to a clustered instance surely you should connect via...

The only constant is change.  Domain knowledge covers the gap between the perfection of everything being exchangeable (fungible) for the ideal widget for today, and the reality of keeping an...

The first time I presented at a conference, the speaking in front of an audience was not a problem.

I think a large part of that was in the years before...

The application team are saying the database is the problem. Do they have any evidence to prove this.

A well written API will have debug facilities that can produce a trace...

I have had to do similar things, such as changing the clustered index column or 'correcting' varchar(max) to varchar(pick-a-number). Sad to say my bedroom wall is covered in scribblings, I...