Browse by Tags

• DatabaseReferences
• DBUnitTesting
• DevConnections
• SQLConnections
• teched
• TFS
• tsbt-db
• VSDB
• VSDB2008GDR
• vsdbpro
• VSTS
• VSTS-DB

• More Team Developer + Data Edition Merge Information

  Per October 1st 2008 MSDN subscribers who own or buy a new Visual Studio Team System Developer license are entitled to also install the Visual Studio Team System Database Edition, and  MSDN subscribers who own or buy a new Visual Studio Team System Read More... Posted Friday, October 03, 2008 2:25 PM from Data Dude | (Comments Off) Filed under: VSTS, vsdbpro, VS2008, tsbt-db, VS2005, VSDB, VSTS-DB, VSDB2008GDR

• Team Developer + Team Data = Team Developer!

  In today's press release titled: " Visual Studio 2010 and .NET Framework 4.0 Overview " we announced the merge of the Developer Edition and Database Edition SKU's.   Better Together – Visual Studio Team System Development Edition Read More... Posted Tuesday, September 30, 2008 8:06 AM from Data Dude | (Comments Off) Filed under: VSTS, vsdbpro, VS2008, tsbt-db, VS2005, VSDB, VSTS-DB, VSDB2008GDR

• Trace Helper

  This is the last part of the 3 part diagnostics series. This part will introduce you to a little helper utility that I wrote to make configuring the diagnostics and tracing options a lot simpler and more accessible. As discussed in the previous two blog Read More... Posted Monday, August 18, 2008 8:16 AM from Data Dude | (Comments Off) Filed under: vsdbpro, VS2008, tsbt-db, VS2005, VSDB, VSTS-DB, VSDB2008GDR

• Event Monitor

  In part 2 of diagnosing problems I want to introduce you to an other build-in diagnostics tools that we might ask you to run with tracking down problems, the "event monitor". The event monitor is one of those tools that we use during development Read More... Posted Monday, August 18, 2008 6:49 AM from Data Dude | (Comments Off) Filed under: vsdbpro, VS2008, tsbt-db, VS2005, VSDB, VSTS-DB, VSDB2008GDR

• Diagnosing Problems

  How to diagnose problem inside Visual Studio Team System Database Edition is the subject for this blog post. When the product does not behave as expected we might ask you to create a trace of the activity that you are performing and send us the resulting Read More... Posted Monday, August 18, 2008 5:56 AM from Data Dude | (Comments Off) Filed under: vsdbpro, VS2008, tsbt-db, VS2005, VSDB, VSTS-DB, VSDB2008GDR

• 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 Wednesday, April 30, 2008 3:50 PM from Data Dude | (Comments Off) Filed under: vsdbpro, VS2008, tsbt-db, VS2005, VSDB, DatabaseReferences, VSTS-DB

• 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 Sunday, February 17, 2008 3:33 PM from Data Dude | (Comments Off) Filed under: vsdbpro, VS2008, tsbt-db, VS2005, VSDB

• 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 Saturday, February 16, 2008 4:31 PM from Data Dude | (Comments Off) Filed under: vsdbpro, VS2008, tsbt-db, VS2005, VSDB, DBUnitTesting

• 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 Friday, January 04, 2008 4:42 PM from Data Dude | (Comments Off) Filed under: vsdbpro, VS2008, tsbt-db, VS2005, VSDB

• 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 Wednesday, December 19, 2007 10:53 AM from Data Dude | (Comments Off) Filed under: vsdbpro, VS2008, tsbt-db, VS2005, VSDB

• 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 Wednesday, December 19, 2007 10:24 AM from Data Dude | (Comments Off) Filed under: vsdbpro, VS2008, tsbt-db, VS2005, VSDB

• 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 Wednesday, December 19, 2007 5:48 AM from Data Dude | (Comments Off) Filed under: vsdbpro, VS2008, tsbt-db, VS2005, VSDB

• 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 Wednesday, November 07, 2007 12:54 PM from Data Dude | (Comments Off) Filed under: VSTS, TFS, teched, vsdbpro, VS2008, VS2005, DevConnections, SQLConnections

• 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 Thursday, October 18, 2007 2:44 PM from Data Dude | (Comments Off) Filed under: vsdbpro, VS2008, tsbt-db, VS2005