SSMS Default File Encoding

Claudio Silva shows how to make UTF-8 the default file encoding for SQL Server:

The file that is used to create a new query window has ANSI encoding but when I save the file on the PowerShell script I save it as UTF-8 because the client have comments on the code with unicode characters.

On this process, the unicode characters are replaced by some symbols.

Read on for the solution.

Related Posts

Changing Query Store Report Interval

Arun Sirpal wants to change the report interval for a Query Store report: While not specific to SQL Server 2019 (I was using this version to do some testing) I was struggling to find how to change the time period of analysis for the Query Store reports within SSMS. This is not a ground breaking […]

Read More

Stats Time Versus Plan Operator Time

Erik Darling explains why SET STATISTICS TIME ON can give you different timing results from what the execution plan states: Here are the relevant details: SQL Server Execution Times: CPU time = 3516 ms,¬†¬†elapsed time = 3273 ms. What looks odd here is that CPU and elapsed time are near-equal, but the plan shows parallelism. […]

Read More

Categories

June 2018
MTWTFSS
« May Jul »
 123
45678910
11121314151617
18192021222324
252627282930