Monthly Archives: February 2010

Promoting T-SQL scripts keeping control of changes

Posted on February 25, 2010 by

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

Posted on February 11, 2010 by

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, clustering, database, recovery, sql, SQLServerPedia Syndication