Cloud & SQLSailor

Cloud, Databases & Beyond!

Month: October 2009

  • Information_Schema – A real friend

    We can query Information_Schema for many purpose :   Select * from Information_Schema.Columns where Column_Name like ‘%%’   Select * from Information_Schema.Tables where Table_Name like ‘%%’


  • Sample back up strategy – Best explanation from MSDN

    Sample Backup Strategy The following illustration shows the easiest backup strategy under the full recovery model. In the illustration, a full database backup, Db_1, and two routine log backup, Log_1…


  • Different RAID levels used for data file configurations

    1. RAID 0 – This is called as disk striping as data is written across the disks.Read write operations are fast but there is no fault tolerance. 2. RAID 1…