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

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

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

Database mirroring is a new feature being introduced with SQL Sever 2005. Without using any special hardware, it allows you to duplicate (real time mirroring) a production database on another SQL ...

SQL Server 2005 is so packed with new features that it can be hard to keep track of it all. Like a tightly packed peloton of Tour de France riders, the new capabilities of SQL 2005 may appear as a ...

I have tested out Database Mirroring in SQL Server 2008, and on the surface it works much like SQL Server 2005 SP1. The user interface is almost identical. The pros and cons are still the same.

We've had SQL 2005 mirroring running successfully for a while now, but the issue I have is our applications reference the primary server by name directly and when the mirror fails over to box #2 I'm ...

At Microsoft's Ignite digital event this week, the company is announcing the private preview of SQL Server 2022, the next version of its three-decades-old relational database management system (RDBMS) ...