Archive for February, 2008

Selecting “SQL_Latin1_General_CP1_CI_AS” Collation in SQL Server

Monday, February 18th, 2008

Recently, I have had to install a named instance of SQL Server 2005 along side a default instance of SQL Server 2000. The 2000 server had the following collation configured: SQL_Latin1_General_CP1_CI_AS. For testing purposes, we had to make sure the new instance had the same collation setting.

Determine SQL Database Collation Setting

Friday, February 15th, 2008

If you want to determine the Collation setting for a particular database in SQL Server: Open Query Analyzer (or SQL Management Studio) Select your database Execute the following query: SELECT DATABASEPROPERTYEX(db_name(), ‘Collation’) SQLCollation; Hope this helps.

Check SQL Collation Setting

Friday, February 15th, 2008

I have needed to check my SQL Server Collation settings recently. Here is a SQL Query to find your server’s collation setting. SELECT SERVERPROPERTY(‘Collation’) AS ‘Collation’ Hope this helps.

My Fake Band

Thursday, February 7th, 2008

So Brian alerted me to an Internet fad that I was unaware of… the creation of my own fake band. Here are the details: So, the latest internet meme (fad) that’s going around is the band album cover theme. You pick random words and pictures from Wikipedia and Flickr and combine them to create your […]