This seems to be good SQL join resource.
Here is are some extensions to SQL Server Management studio that look like they might be pretty useful. For some reason the “Run one script on multiple databases” feature catches my eye…
Get the software here: SSMS Tools Pack
From the website:
SSMS Tools PACK is an Add-In (Add-On) for Microsoft SQL Server Management Studio and Microsoft SQL Server Management Studio Express.
It contains a few upgrades to the IDE that I thought were missing from the Management Studio:
This could potentially be a really useful technique for certain kinds of deployment or migration tasks. The article describes a procedure to easily produce scripts to create your database schema and then populate the new schema with the data in your source database.
The article is here