Used sqlcompare and datacompare from redgate for some years now, relatively low cost tool that should be in every dba's toolkit - in terms of ROI it'll save you so...

If the database has lots of indexes and triggers it suggests that referential integrity is probably handled by the triggers. Not having clustered indexes is probably a bad idea as...

There are still times when obscuring the underlying code may be needed, for example on web facing sql servers.

encryption, limited permissions are one way, dll's probably the best -...

Any user can read the stored procedures, you need to remove the permissions to syscomments in the database which will stop viewing of the code. However, even with encryption your...

Rule 1 always have a backup !!!

These are the notes I have on suspect databases - in general terms don't expect too much, but these are the best known options...

It's possible to force a rebuild of a system table by changing the fillfactor on the clustered index - this then forces a rebuild. My msdb gets hit by around...

The type of business obviously has a significant role .. in my case I work within the mortgage lending industry and not being there means no business, e.g. customers just...

One other point about expectations is the that the business often tend to downplay theirs, especially when cost is involved, until something goes wrong .. then you find out about...

The main issue with Raid 5 is that it requires 4 i/o's per disk write, that effectively puts quite a brake on the throughput of your data array. ( i/o's...

DR is the process and planning of the recovery and continuation of the system/enterprise in the event of a disruption to service with the minimal loss of data and the...

Raid 5 is only suitable for a read only database.

In all the hiogh performaing oltp environments I've worked I've always used raid 10, right back from sql server 6.0 and...

I often wondered about that, if I read a series of non-contiguous 8k pages does sql server actually bring in the pages or use read ahead to bring in an extent .....

I've always set data to 8k for oltp database to match the page size for random reads etc. logs & backup drives I've always set to 64kb.  Means most defrag...

You could place the commands to set msdb into a proc and run the proc at startup automatically.

One might ask what point there is in having a SQL Server that does not allow access ???? Well I guess it would be secure.

To be blunt it sounds like...