The pros and cons of Partial Projects and Database Project References

This blog post assumes you are using Visual Studio 2010. However, most of the information is relevant to Visual Studio Team System 2008 Database Edition GDR. We get a lot of questions on the forum for which the answer is to use partial projects and/or database project references. Before you choose one or the other…

4

T-SQL IntelliSense in Visual Studio 2010

One of the cool new features in Visual Studio 2010 is T-SQL IntelliSense. Yes, I know you’re thinking, “it’s about time.” Well, when we were implementing this functionality we had to made some difficult decisions about what we would support. So I thought it would be helpful to describe what T-SQL IntelliSense will/will not do…

1

Visual Studio 2010 SQL Database and DAC Projects (DBPROJ) – Project Properties

This post describes all the properties that may be configured in SQL Server, SQL Database and Data-tier Application Component (DAC) projects and how to go about setting them. Specifically, the properties that are defined and persisted in the DBPROJ file and the msbuild target files it references as well as the DBPROJ.USER file. People that…

1