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)
14,547 reads
Manvendra Singh explains step by step how to change the server level collation setting for an existing SQL Server instance.
2016-04-27
3,428 reads
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
Script to identify the most expensive queries on your database server using the Query...
In this post we're going to go through the steps to set up Always...
Hi I have a situation where I am testing two versions of the same...
I'm looking for best practice here and these are Azure VMs by the way....
Does anyone know if Azure absolutely requires windows clustered services to support availability groups?...
Ask SSC