After installing Visual Studio 2010 Service Pack 1, I noticed that intellisense had stopped working in SQL Server Management Studio 2008 R2. The issue was noted in Scott Guthrie’s blog, a few weeks ago. I discovered today that a hotfix is available from Microsoft as a part of SQL Server 2008 R2 cumulative update 7. I’ve installed update 7, and verified that intellisense works again.

As I’m an avid reader, I decided to start sharing weekly recaps of my reading list. This will often include articles I’ve found interesting, but also items related to the projects I’m currently involved with. The subject matter may vary, but I hope others will find them useful, or better yet as a way to sharpen your saw.

The past week has been all about design. I’ve been reading one of my favorite books again, Patterns of Enterprise Application Architecture. Recently, I’ve been thinking about ways to create a web service layer over fine-grained API.  In order to reduce the number of remote calls from client applications over a distributed network, I’ve been revisiting the Remote Façade pattern, which allows you to create a coarse-grained interface over a fine-grained API. Additionally, you may also find the article on Data Transfer Objects useful.

Here are a few more articles that I read:

Software components: Coarse-grained versus fine-grained

Data Transfer Object

Domain Objects Caching Pattern for .NET