My Space In The Net

Microsoft SQL Server 2008: Spatial Data

White Paper: Delivering Location Intelligence with Spatial Data

Location Intelligence - Virtual Earth + SQL Server 2008 Spatial

Hannes’s Virtual Earth Blog

Link:  Rick Heiges -D-Day for SQL 2000 - April 8, 2008

Link: SQL Server 2005 Best Practices Analyzer

When editing the table schema in the SQL Server 2008 UI and the required change requires that the table needs to be dropped and recreated by default the UI will not let you make the change.

The kinds of changes that would require that the table be dropped and recreated would be inserting a column in the middle of the table, or changing the size of a column.

This setting can be overwritten by clicking on the Tools drop down menu and selecting Options.  Under the Designers menu option, select the “Table and Database Designers” menu option and uncheck the “Prevent saving changes that require table re-creation” option.  After clicking OK you will be able to save the changes.

Continuous Integration And Version Control for Databases - infoq.com

Get Your Database Under Version Control

Versioning Databases – The Baseline

Versioning Databases – Change Scripts

Versioning Databases – Views, Stored Procedures, and the Like

Adding simple trigger-based auditing to your SQL Server database

Versioning Databases – Branching and Merging

http://sqljunkies.com/Article/4067A1B1-C31C-4EAF-86C3-80513451FC03.scuk

http://www.styledesign.biz/weblogs/macinnesm/archive/2004/09/14.aspx