May 2009 - Posts

• 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 Read More... Posted Friday, May 29, 2009 4:23 AM by AllenMWhite | 3 Comments Filed under: Database Administration, SQL Server 2008

• 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 Read More... Posted Tuesday, May 26, 2009 7:03 AM by AllenMWhite | 5 Comments Filed under: Database Administration, SQL Server 2008