Monthly Archives: February 2010

Promoting T-SQL scripts keeping control of changes

An often overlooked part of promoting DML scripts is knowing what the intention is going to be before one is run. For instance if you work in an environment with a high throughput of DML script promotions then there is … Continue reading

Posted in SQL, SQLServerPedia Syndication

SQL 2008 MSDTC cluster problems, when coordinators collide

Well today I’ve just finished our (dual) production fail-over cluster (almost). All that is left is to remove one of the clustered drives and calve it into 5 LUNS. The reason being is that in SQL2008/ Windows 2008 it is … Continue reading

Posted in Availability, Backup and Recovery, Database, SQLServerPedia Syndication