A quick reference to replace or perform find and replace with an SQL command – for MSSQL.
UPDATE dwsystem.dbo.dwserver SET name = REPLACE(name, 'PRESENTATIONVM', 'DWSERVER');
UPDATE dwsystem.dbo.dwserver SET connection = REPLACE(connection, 'PRESENTATIONVM', 'DWSERVER');
UPDATE dwsystem.dbo.dwserver SET settings = CAST(REPLACE(CAST((settings) AS nvarchar(max)), 'PRESENTATIONVM','DWSERVER') AS NText);