A nice little change in SQL Server 2005 has been the ability to change the collation of the server. Back in the day, circa SQL 2000, changing collation and reinstalling SQL Server were pretty much the same thing. By pretty much, I mean the exact same thing. In SQL Server 2005 you can now do … Continue reading Change the Server Collation of SQL Server 2005
Month: October 2007
Restoring a Database with Symmetric Encryption
For those unfamiliar with encryption in SQL Server, this article is a nice introduction to symmetric encryption in SQL Server 2005. I've only used encryption a few times and it's definitely been the godsend that the article states. I referenced the article recently when I had to restore a database on a new server that … Continue reading Restoring a Database with Symmetric Encryption
Strate SQL 