When SQL Server 2005 is released to manufacturing in the next few months, Microsoft will take the exceptional step of designating one of its high-profile features as being intended for evaluation only ...

Get the lowdown on SP-1's added features, including fully supported database mirroring, bug fixes, and add-ons for SQL Express. What's more, SP1 not only contains bug fixes, but also delivers ...

Learn how to optimize performance of the source database and mirrored database from SQL Server in Microsoft Fabric. This article includes important steps to optimize performance of the source database ...

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 ...

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 ...