Here you will learn about the key differences between the binary and SQL/Windows collations. You will see that even with all sensitivity flags enabled, SQL/Windows collation cannot behave the same way as the binary collations.
2024-03-15
1,475 reads
2022-06-29
456 reads
2022-03-30
541 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)
20,246 reads
2020-04-23
828 reads
2019-10-28
534 reads
2019-01-18
676 reads
2018-06-26
869 reads
2018-01-18
823 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
With the PBIR format of Power BI reports, it’s much easier to make report...
By Steve Jones
As we close out the year, I decided to drop this post here and...
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Hi, I have created a multicolumn paginated report, which includes a subreport that I...
I have this script that puts all of the output from query to a...
Hi, after i copy in ssis my excel file to a secured folder, its...
What is Terraform (from Hashicorp) used for in technology?
See possible answers