Collation

Change the Instance Collation by Rebuilding Databases in SQL Server 2017

  • Article

As a part of my DBA activities, I do a lot of SQL Server installations every week. Most of the time, I install the instance with the default collation. A collation is a configuration setting in SQL Server that determines how the database engine should read the data. SQL Server has huge list of collations […]

5 (1)

2020-08-03

7,707 reads

Questions About SQL Server Collations You Were Too Shy to Ask

  • Article

Of course we all like our colleagues to think that we know everything there is to know about SQL Server Collations. However, the truth is that it is a rather complicated topic to fully understand and the cost of getting collation wrong can be great. If only one could ask certain questions on forums or at conferences without blushing. Help is at hand, because Robert Sheldon once again makes the complicated seem simple by answering those questions that you were too shy to ask.

2017-06-15

3,969 reads

Blogs

Daily Coping 21 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

#PowershellBasics: Bulk insert.

By

In my last post I talked about invoke-sqlcmd. It’s a nice easy way to...

Lambda Architecture in data systems and possible meaning of this name

By

(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists...

Read the latest Blogs

Forums

Azure data factory tutorials

By browlciba

Hi all I was wondering if anyone knows where to go for help with...

The actual file SQLServerManager15.msc is missing from my computer

By Jocar26

I did a fresh install of Windows 10 Pro and loaded SSMS on it. ...

PostgreSQL Date And Time Part 2

By Shivayan Mukherjee

Comments posted to this topic are about the item PostgreSQL Date And Time Part...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers