I'd also like to add that AI can also give bad advice. Before making ANY changes to the system, you should fully understand the advice being given. Like if AI...

Lots of resources on dynamic SQL, but the basics of it are that you are storing your SQL TEXT in an NVARCHAR variable and then passing it to the stored...

My opinion - The first and second query are not going to be changing much, if at all as there is no logic in them, so duplicating them across 2...

I would recommend you reach out to Plesk Obsidian. It could be that their installer changes the default config file for MySQL or possibly even passes the configuration straight through...

Sounds to me like you are using the wrong version of VS to work with that DTSX. I would try an older version of VS. I wouldn't try to upgrade...

Just to add to what MMartin1 said, branches are good to learn early on so you can try to avoid merge conflicts or code overwriting. Multiple people working on the...

I know you say to forget my first thought, but restrict access. Give them access to a test environment with close to live data so they can play around. My...

As a guess - did the person who installed SSMS install it using an admin account on the machine and install all of the components as "all user" not "current...

A lot to unpack there, but to summarize git is included with VS, but there is no server associated with it. So all the git stuff would be local which...

I would argue that by doing that you may be wasting space. For example, you said you have a 1 TB disk for TempDB, but if TempDB never goes over...

As far as I am aware, there is no source control module for report builder. But that being said, there is no reason you need visual studio either. There area ...

why would you want to turn off autogrow? Autogrow is there so you don't need to manually grow if an unexpected query runs that causes database growth? I mean, with...

Maybe I'm a bit slow here, but is there a reason you need all of that?

With REPLACE, if the character doesn't exist in the string, it should return the string,...

Most people on this forum are English speakers, but I will do my best with google translate to try to help.

If I am not mistaken, READPAST is not a valid...

My understanding is that with write heavy databases, RCSI can help as the read operations are no longer blocked by the writes. That being said, you are going to see...