SQL Server 2008 R2 cluster setup fails on mount points

(Update from Monday morning, the workaround shown below works for me) Another day, another set up problem (sigh) I was installing a second SQL 2008 R2 instance on a new cluster today. The first one had gone well without incident but the second one had a crucial change in that it used mount points. It… Continue reading SQL Server 2008 R2 cluster setup fails on mount points

Example of SQL Server collation usage and problems

I was discussing with some developers this week why SQL Server collation mattered and what are typical things that can go wrong. This is a huge topic and is an often over looked feature of database and server design, especially when you want to build applications that run in multiple geographic locations and that should… Continue reading Example of SQL Server collation usage and problems