SQL PFE has a Pre-Con at the PASS Summit!

At the 2014 PASS Summit in Seattle on Tuesday November 4, Denzil Ribeiro and I (Tim Chapman) will be giving a Pre-Conference seminar entitled “Troubleshoot Customer Performance Problems like a Microsoft Engineer.”  In this full-day session Denzil and I will cover a plethora of troubleshooting tools and methodologies that we use as field engineers when confronted…


Connection Pooling for the SQL Server DBA

  There are a handful of questions that DBAs get in the wild that aren’t necessarily under the jurisdiction of the typical DBA.  One of those aspects is connection pooling.  Far too often application teams, or network admins, or <insert non-DBA professional here> approach the DBA with questions regarding connection pooling, and whether or not…


How to: Restoring SQL File stream Data

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?”  The thought process is pretty much the same, but…