Monthly Archives: July 2009

T-SQL: Change Collation on your LIKE Clause Using COLLATE

Ever have trouble matching unicode letter equivalents in your T-SQL queries? For example, when you want “Québec” and “Quebec” to be equivalent in your text search query? This is where specifying Accent Insensative Collation (The “AI” in all those collation codes) comes … Continue reading

Posted in MS SQL Server, T-SQL | Leave a comment

August 2009 IT Toolbox Column for TechNet Magazine

The August 2009 issue of TechNet Magazine is out on the website. Check out my IT Toolbox column here: August 2009 TechNet Magazine IT Toolbox In this issue I covered: Notepad++: Replace Your Text-File Editor Check it out and let … Continue reading

Posted in Microsoft TechNet | Leave a comment