Black Hole Routers

Got your attention? I like this topic because it sounds like something from outer space =) MS KB 314825 explains a curious issue that you may encounter on your networks and how to identify a black hole router. When a network router receives a packet that is larger than the size of the Maximum Transmission…

SQL Server Restore Errors

  Working in the development/testing environments that I do, this is an error I see frequently as developers are moving/copying staging or test databases from one SQL instance to another.  The error can pop up when you try to restore a database on top of an existing database of the same name:   System.Data.SqlClient.SqlError: The…

Welcome

Welcome to my SQL Server blog!  The idea here is to share my everyday experiences with SQL server – what questions or issues did I run into today?  How were they solved?  How could they have been avoided?  What should I be looking for next time?  I’ll post about anything I find useful, interesting or…