Monthly Archives: July 2009

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

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 Backup and Recovery, Database, File-System, Setup

Checking your Constraints… to check your Integrity

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

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