MS SQL Server

Some links that have been useful to me. The documentation that comes with SQL Server is pretty good, although sometimes there aren't enough examples. Never forget to search Google and MSDN when Books Online doesn't suffice.

Create a view that retrieves data from a linked server: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_94fn.asp

Using linked servers: http://www.swynk.com/friends/boyle/linkedservers-2.asp

Securing a SQL Server: http://www.devx.com/codemag/Article/10290

Dynamic SQL: http://www.algonet.se/~sommar/dynamic_sql.html

What to do if sqlserver goes to 100% and you don't know why: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=1955

Howto reduce the size of the transaction logs - http://dbforums.com/arch/179/2003/8/882748

Recovering from a deleted log file (a brutal experience, don't ask) - http://www.spaceprogram.com/knowledge/sqlserver_recover_from_deleted_log.html

Recovering a database from suspect/emergency mode - http://www.eleks.lviv.ua/en/?topic=technology&secondary=Technology

With InfoPath: http://www.databasejournal.com/features/mssql/article.php/3070881

Awesome SQL database comparision tool!

http://www.adeptsql.com

This tool rocks! I used it to update two MSSQL ^? databases (on seperate servers) that are almost the same, but because of development and fixes happening on either one were out of sync. AdeptSQL Diff very quickly compared the 108 stored procedures, 48 tables, and the various keys and indexes. It's a breeze to diff individual objects or data, and update either database, delete objects, etc.

Back to Databases