Changing the default collation for a database will only change the collation of the system tables. Any columns that have already been created will retain their collation. In fact it's...
SQL Server has a pretty good set of supplied tools. You probably don't need to spend money on lots of additional software unless you have a specific need.