I’d like to make you aware of an issue that may occur after installing Service Pack 1 for SQL Server 2012. Some of the symptoms are: The Windows Installer process (MSIExec.exe) repeatedly starts and attempts to repair specific SQL Server assemblies. Your...

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

The scenario was that we saw sluggishness on the initial load of a Power View Report and also when we went to use one of the filters on the report - like a Pie Chart Slice. For the given report the customer had showed us, the initial load was taking 13...

I was working on a 2005 to 2012 upgrade issue and came across an interesting issue which I thought of sharing with you guys.   Whilst running an upgrade from 2005 SP4 to 2012 RTM (and/or slipstreamed copy) it failed half way through, giving the error...

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