2022-06-29
446 reads
2022-06-29
446 reads
2022-03-30
531 reads
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 […]
2022-12-26 (first published: 2020-08-03)
16,354 reads
2020-04-23
826 reads
2019-10-28
529 reads
2019-01-18
671 reads
2018-06-26
864 reads
2018-01-18
818 reads
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
In some scenarios we can find different SQL Server collations between the server instance and its databases. Douglas P. Castilho explains a simple way to correct the collations in a few steps.
2017-04-11
3,262 reads
It’s me again with my apparently semi-annual blog post. This time we’re going to...
By Steve Jones
I saw an article on this and realized I had no idea how to...
In this blog post I wrote a tip about fixing the PostgreSQL backup failure...
Hello, I am deploying SQL 2019 Enterprise edition with AOAG ( without windows clustering)....
Hello @all, i am facing a problem and can not find a solution... I...
We are used to the job activity monitor in SQL server allowing quick checks...