In case you are coming to the Developer edition of Tech·Ed next week, we have a lot of exiting things for you. As you can see below there are many sessions, hosted in both the developer and database tracks. Breakout sessions, chalk talks, panel discussions and hands-on lab, all covering Visual Studio Team System Database Edition. It all ...

The reference projects needed to resolve objects that reside inside an MSDB database have been posted on the MSDN Code Gallery site. You can find them on: http://code.msdn.microsoft.com/dbpromsdbsamples We did not post .dbmeta files but stub projects, because .dbmeta files require the collation to match with your environment. This would result ...

Visual Studio 2005 Team System Database Professional post Service Release 1 (SR1) roll-up package 1, is now available. For a list of issues that are fixed, please see knowledge base article KB941278. You can download the roll-up from the Microsoft Connect site ...

VSTS-DB, both the 2005 and 2008 version, makes an assumption with regards to database compatibility levels, which can cause problems in certain use cases.   The assumption is that the DesignDB instance used for validation of the schema inside the project is set to a 80 compatibility level when using a SQL Server 2000 project and to 90 when ...

This months issue of MSDN Magazine features a great article about how to use and extend Database Unit Testing written by Jamie Laflen who is the developer and tech lead in my team responsible for Database Unit Testing, Data Generation, SQL Code Coverage and Build & Deploy. So this information comes straight from the source! Check out: ...

Lately we have been getting questions about self-referencing database calls. What I mean with that is that you are referencing SQL objects using a 3-part name while referencing objects that reside inside your current database context. For example: 1: use Northwind 2: go 3:  4: SELECT * FROM Northwind.dbo.Categories 5: go Just ...

When Visual Studio Team System Database Edition opens a design-time validation database, it acquires an exclusive application lock on the DesignDB database using the following code. 1: EXEC @rc = sp_getapplock N'TSDATA', N'Exclusive', N'Session', 0, N'dbo'; .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: ...

In the ''DesignDB Location'' blog post I described where the design-time validation database are created. The attentive reader would have wondered when design-time validation database file get cleaned up, since we create them at project creation time and attach or re-create at project open time. So when do they get removed? The answer: DesignDB ...

As you might know Visual Studio Team System Database Edition uses a local SQL Server database instance to validate the correctness of the code inside the database project. When you create a project a local scratch database is create for validation purposes, when you close project the database gets detached and when you re-open the project it gets ...

  Now that Visual Studio 2008 is available, the question arises what has changed for Visual Studio Team Edition for Database Professionals in the 2008 edition? Not much is the answer. Since our first release was done completely out-of-band while other teams were actively working on the Visual Studio 2008 release, our main goal was to ...