Monthly Archives: July 2009

Recovering suspect databases but what if you cant remove the old one

Posted on July 22, 2009 by

The other day a fellow dba was having a problem with removing a corrupt database from a SQL Server and was failing to remember that the physical architecture of SQL Server is actually quite simple. Every time he tried to … Continue reading →

Posted in datafiles, filesystem, recovery, setup, sql

Checking your Constraints… to check your Integrity

Posted on July 22, 2009 by

Something that you probably don’t need to do every day is to change the data in the foreign key field. Generally, depending upon how your application is designed these would be relatively irrelevant and are simply just a mechanism to … Continue reading →

Posted in integrity, sql, SQLServerPedia Syndication | 1 Comment

choosing the right distro at last it has been found

Posted on July 19, 2009 by

For a long time now (10 years) I’ve been trying hard to get into Linux and there has always been a major obstacle hit along the way to make me put the OS back on the shelf for another day. … Continue reading →

Posted in linux, setup