In this blog post I will look at how you can add a mount point to a Windows Server Failover Cluster and use that mount point for SQL Server 2005 and later installations. I already have the SQL FCI setup and configured, so at this point...

It is not uncommon to have multiple copies of the same database on a single instance or to restore copy of a database from one instance to another for testing. I was asked - “How does this work when I have filestream data in my database?” ...

In most cases, people utilize SQL Server features and capabilities in a common and typical usage pattern. But there are some instances where environments do something just a little different, or fill the bucket to the absolute brim. With...

Tom Stringer (@SQLife) was working on some HADR testing for a customer to simulate many availability groups and introduce significant load into the system to measure overhead and such. In his quest to do that he was seeing behavior that he couldn’t really...