Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » VSDB » DBProj.com   (RSS)

DefaultDataPath

VSDB uses the the ($DefaultDataPath) SQLCMD variable to represent the location where you would place your data and log file of your database. The deployment engine sets the value of SQLCMD variable by querying SQL Server using the following query: 1: Read More...
Posted Monday, November 30, 2009 5:48 PM by gertd | 0 Comments

VSDB 2008 Version Numbers

We frequently get asked how to identify the version a user is running with, so here is the list of Visual Studio Team System 2008 Database Edition releases. The information is retrieved using Help => About Microsoft Visual Studio inside the Visual Read More...
Posted Wednesday, July 29, 2009 3:37 PM by gertd | 0 Comments

Assigning MSBuild Properties to SQLCMD Variables

I am receiving the following question a lot: How do I propagate MSBuild properties to SQLCMD variables. In order to make the Visual Studio 2008 Team System Database Edition GDR release use the data from an MSBuild property inside a SQLCMD variable you Read More...
Posted Sunday, June 21, 2009 4:21 PM by gertd | 3 Comments

DBSchema file for SQL LiteSpeed XP’s

Based on a customer request I created a .dbschema file which contains the definitions of all the extended stored procedures used by SQL LiteSpeed 5.0 that live inside the master database. Since schema import does not import the definition of extended Read More...
Posted Wednesday, June 10, 2009 5:10 PM by gertd | 2 Comments

Declarative Database Development

Define What You Want, Not How You Get There!   If Not Exists… Database development is many aspects behind in comparison to regular application development. If you look how database development is integrated with regular application development or Read More...
Posted Friday, June 05, 2009 3:58 PM by gertd | 10 Comments

DBProj.com

Some of you already know or noticed through sites like LinkedIn or Facebook that per the beginning of this month I started in a new role inside Microsoft. I moved in to an Software Architect role, working on the new Directory Services stack. Hence I needed Read More...
Posted Thursday, February 19, 2009 6:37 PM by gertd | 2 Comments
 
Page view tracker