Is DesignDB In Use?

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’; A side effect of acquiring the application lock is that only a single Visual Studio instance can open the…

1

Cleaning up DesignDB Leftovers

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 files…

1

DesignDB Location

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…

2

Visual Studio Team System 2008 Database Edition

  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…

17

The Data Dude Meets Team Build

At DevConnections and TechEd Europe every attendee has been receiving a special issue of CoDe Magazine, featuring “Data Programmability“. In this issue you will find an article on how to get started with Team Build and VSDBPro, please check out http://www.code-magazine.com/Article.aspx?quickid=990712152.  If you are interested in this particular subject also be sure to check out…

5

External Changes…

What happens when you make changes outside the scope of your project? What if you edit a file inside Notepad or sync your source code from your SCC system, either from the command line or from the VS IDE? Most users assume that the project automatically get updated as soon as the file is save on…

3

Data Bound Generator vs. Sequential Data Bound Generator

The Power Tools v1.0 release adds a new data generator, named the “Sequential Data Bound Generator”. Since there already exists a data generator named the “Data Bound Generator” this yields the question what the difference is between the two is and when to use either one of them. Data Bound Generator The Data Bound Generator,…

3

SQL Connections 2007

Like every DevConnections conference for the last 6 years, I will be there presenting on a combination of SQL Server and Visual Studio for Database Professionals topics. On November 5th I will be hosting a full day workshop on DataDude (aka Visual Studio Team Edition for Database Professionals). After that I will be presenting on four…

1

Channel 9 video Covering Power Tools & Service Release 1 Functionality

Before I left for vacation, I did a quick video recording for Channel 9 together with Brian Keller showing off the new functionality in the Visual Studio Team Edition for Database Professionals Power Tools and Service Release 1. You can find the video at this location https://channel9.msdn.com/showpost.aspx?postid=334261 Brian also released a video he did with Sachin…

1

Power Tools Download Link

They are here! Dependency Viewer Refactoring Move Schema Expand Wildcard Fully Quality Name Refactor in to strongly typed DataSet definitions Refactor Command Generator Data Generation Sequential Data Bound Generator Editors for the Data Bound Generator, Sequential Data Bound Generator and RegEx String Generator to make configuration easier The RegEx editor also tries to interpret your CHECK CONSTRAINTs…

11