Reader jwwishart shared another way to find database collation in SQL Server 2005: a one line SELECT of collation_name from sys.databases.
SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf) – Part 2
A last resort for corrupt datafiles with no backup: emergency mode, single user, then DBCC CHECKDB with repair_allow_data_loss. Back up the files first.
SQL SERVER – 2005 – Connection Strings For .NET
SQL Server 2005 connection strings for .NET, ODBC and OLE DB with SQL Native Client: standard security, trusted connection and named instance examples.
SQL SERVER – Change Order of Column In Database Tables
How do you change the order of column in a database table? SQL Server has no direct way, and I explain when column order matters and when it should not.
SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf)
Can you restore database using corrupt datafiles when there is no full backup and both .mdf and .ldf are damaged? My honest answer and the one thing to try.
SQL SERVER – 15 Best Practices for Better Database Performance
Best practices for better Database Performance: keep only needed data, normalize tables, use lookup tables and small primary keys. I list 14; you suggest the 15th.
SQL SERVER – 2005 – Transferring Ownership of a Schema to a User
Transferring ownership of a schema to another user in SQL Server 2005 takes one ALTER AUTHORIZATION ON SCHEMA statement. A reader asked, so here it is.