Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » VSDBPro   (RSS)

Tech·Ed 2008 Developers

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 Read More...
Posted Thursday, May 29, 2008 1:10 PM by gertd | 0 Comments

MSDB Reference Projects

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, Read More...
Posted Tuesday, April 29, 2008 10:50 PM by gertd | 1 Comments

VSDB 2005 Service Release 1 Roll-up Package 1 (KB941278)

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 Read More...
Posted Tuesday, March 11, 2008 6:36 PM by gertd | 2 Comments
Filed under: , ,

Database Compatibility Level

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 Read More...
Posted Saturday, February 16, 2008 9:33 PM by gertd | 3 Comments
Filed under: , , , ,

Apply Test-Driven Development to your Database Projects

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 Read More...
Posted Friday, February 15, 2008 10:31 PM by gertd | 1 Comments

Lorem ipsum

This morning I received email from the owner of the DbProGenerators project on CodePlex announcing the availability of the LoremTextGenerator, which is a data generator that creates Lorem ipsum texts. Please check out the CodePlex project site at http://www.codeplex.com/DbProGenerators Read More...
Posted Wednesday, February 13, 2008 11:11 AM by gertd | 1 Comments
Filed under: , , , ,

Self Referencing

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: Read More...
Posted Thursday, January 03, 2008 10:42 PM by gertd | 4 Comments
Filed under: , , , ,

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' Read More...
Posted Tuesday, December 18, 2007 4:53 PM by gertd | 1 Comments
Filed under: , , , ,

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 Read More...
Posted Tuesday, December 18, 2007 4:24 PM by gertd | 1 Comments
Filed under: , , , ,

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, Read More...
Posted Tuesday, December 18, 2007 11:48 AM by gertd | 2 Comments
Filed under: , , , ,

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 Read More...
Posted Wednesday, November 21, 2007 3:26 PM by gertd | 13 Comments
Filed under: , , ,

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 Read More...
Posted Tuesday, November 06, 2007 6:54 PM by gertd | 5 Comments

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 Read More...
Posted Wednesday, October 17, 2007 9:44 PM by gertd | 3 Comments
Filed under: , , ,

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 Read More...
Posted Tuesday, September 04, 2007 10:48 PM by gertd | 3 Comments
Filed under: , ,

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 Read More...
Posted Sunday, September 02, 2007 10:07 AM by gertd | 1 Comments
Filed under: ,
More Posts Next page »
 
Page view tracker