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

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

SQL Server SQL Server 2005 introduced the much awaited Database Mirroring feature. OK, so we had to wait for SP1 for official support and for SQL Server 2008 for some enhancements like better ...

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

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

SQL Server 2012 introduces a lot of new features which, like the columnstore indexes I discussed last month, are inspiring a lot of excitement in the user community. However, there’s been a bit of ...

A step-by-step guide to using SAN-less failover clustering software to support SQL Server’s Always On Failover Clustering in the public cloud The thing about clouds is that they can change shape even ...