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

3,693 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

Goal Progress–November 2020

By

This is my report, which continues on from the Oct report. It’s getting near...

Azure Synapse Analytics is GA!

By

(Note: I will give a demo on Azure Synapse Analytics this Saturday Dec 5th...

5 Things You Should Know About Azure SQL

By

Azure SQL offers up a world of benefits that can be captured by consumers...

Read the latest Blogs

Forums

Polybase

By Admingod

I am trying to configure polybase scale out, what ports do you recommend? Is...

Get data from last line and merge into data stream before removing

By Bruin

This script reads thru a file and removes the last line, but before it...

Firewall access for Availability Group listeners

By webrunner

Hello experts, I have a noob question as I never feel like I understand...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers