In a previous blog entry, I talked about the new FILESTREAM data capability in SQL Server 2008 where we can store Binary Large Object (BLOB) data on the file system but have it transactionally part of ...

// disclaimer = based on SQL2008 and mirroring of two SQL DB's on different physical boxes with a witness.<BR><BR>"Pull the plug" would work in the disclaimer setup above (the witness detects one SQL ...

I have been testing out Database Mirroring in SQL Server 2008. There are numerous enhancements in 2008, mainly under the hood in the name of performance and reliability but still worth testing out. I ...

Without using any special hardware, it allows you to duplicate (real time mirroring) a production database on another SQL Server at a different location. In addition, if the first server should become ...