Collation, DateTime, SParse Column and XML

You may wonder why I keep writing collation topics in my blogs. I found our Books Online topics related to collation is not so clearly enough, and sometime it confuse our reader. I intend to present my idea related to collation in a series of blogs, and...

Today, I got following questions: " The documentation states that Datetime2 is unaware of the time zone. Does that still guarantee that when the clock gets adjusted for Daylight Saving Time this will not result in duplicate timestamps? I.e. is Datetime2...

The best way to avoid SQL Server's collation conflict issue is that avoid have different collations in your database schema. If your server and database have the same collation, you will never see the conflict collation issue. if all string columns in...

Today, I looked for SQL Server JDBC Driver's sendStringParametersAsUnicode, this parameter controls how Unicode String (Java only have Unicode string which is UTF-16 encoding) will be sending to SQL Server. As the name of this parameter indicate, when...