SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: May 2009

Changing Server Default Collation

An interesting problem develops when the standard default collation for SQL Server isn't appropriate. Working with clients here in the Czech Republic, I have to reset our lab systems server default collation to Czech_CI_AS, and I found it difficult to find out how to do this via Books Online. Since… Read more

3 comments, 1,597 reads

Posted in Allen White on 29 May 2009

Tracking Deprecated Features

This week I'm in Brno, Czech Republic leading an App Compat seminar for Microsoft clients here, and one of the things we need to look for in their applications is the use of deprecated features. I was poking around the sys.os_performance_counters DMV and discovered the [sqlinstance]:Deprecated Features object and found… Read more

0 comments, 457 reads

Posted in Allen White on 26 May 2009