We use git on TFS and switched from SSMS to VS Code (with mssql and powershell extensions).

I find VS Code to be much better than SSMS. It supports...

I've come across this article and a few others that suggest it is a limitation of PIVOT that you can't PIVOT more than one column. I am not sure I...

The reason I love Linux is because it is free. But it isn't free as in free beer. It is free as in free speech.

My approach would be to not try and use REPLACE in this way because I imagine that this list of models is constantly changing.

Instead create your own key for models...

I import a lot of flat text and I would use BULK INSERT to do it from the server side and BCP to do it from client side. BCP doesn't...

I think if you found someone using GUID's for table names my guess is the tables were created by some program and not by a DBA or developer.