As I understand it if you are using mirroring on SQL server and have failover setup you can adjust the connection strings of your applications that use it so they ...

SANTA CLARA, CA--(Marketwired - May 11, 2016) - ScaleArc, the leading provider of database load balancing software, today announced its latest version of ScaleArc for SQL Server broadens support for ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

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

While the cloud continues to grow in popularity for many, if not most, enterprise applications, IT departments remain reluctant to trust public clouds, including the Google Cloud Platform, for ...

DBAs have many options for how to ensure high availability (HA) for SQL Server. Some of these options are available in the different versions and editions of SQL Server itself. Some are available in ...

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