Should also be renaming the DB, as a select query on an old connection string could still access the database.

This is where a calendar table would come in very handy, the one I use is from the below link

https://www.sqlservercentral.com/scripts/date-calendar

You would then want to add an additional index on the...

It all depends how easily transferable your skills in Oracle are to SQL, they are two completely different products at the end of the day and while I appreciate they...

BIG NOTE - The current product based certifications and the MCSA/MCSE/MCSD etc exams are all being retired as of 31st Jan 2021.  So if you are wanting these certification you...

@sterling3721 - lac is (forgive the dialect - I believe Indian/Gujarati) for thousand

@sethumail2000-2 - those two indexes, are essentially left key subsets, I would very much recommend removing the index...

Please post screenshots and a walkthrough as by default when you script a table via the gui it only scripts the table.  not the procedures also.

What tool are you using as SSMS doesn't do that by default.

If it is within SSMS what plugins do you have?

A connection string change that's not been made, opens a select to the database and works.  How will you know of rouge connections which need to be changed if the...

What is the error?  What is failing?

All the network connectivity is in place? Firewall rules between sites etc.

You can establish a SSMS session from the LocalServer to the RemoteServer?

What network...

Not necessarily, it is the old "it depends", for example ReportServer database for SSRS has to be in a specific collation for it to work, which is always different from...

One option using groupby and having

select 
row_number() over(partition by  NumeroContrat order by NumeroContrat desc) as classement, 
*
from Gestion_Stats.dbo.produit
where 
numerocontrat in 
(
  select 
  ...

removed - attachment didn't show when writing original, this option wont meet requirements

Three options

1. Rebuild the system databases using the database collation.  Note you will need to backup all databases, logins, server side objects etc and replay them

2.  Create new DB with...

You would need to setup database mail if not already done so

Then you will need to create a piece of SQL to meet the requirements.

If the query uses transactions you...

What is the operating system in use here, is it Server 2016 or above?

You also aware that clusterless availability groups wont provide the automatic HA/DR, they are purely designed for...