Browse by Tags

• DatabaseReferences
• DBSchema
• Declarative Database Development
• MSBuild
• setup
• sqlcmd
• training
• troubleshooting
• tsbt-db
• VSDB
• VSDB2008GDR
• vsdbcmd

• 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 Tuesday, December 01, 2009 11:48 AM from Home of the Data Dude | (Comments Off) Filed under: tsbt-db, VSDB, VSDB2008GDR, DBProj.com

• SqlCmdVars.exe

  This post announces the availability of a small helper utility that will allow you to maintain your database.sqlcmdvars files from a command line tool. Description: What is the scenario? If you are using vsdbcmd.exe to deploy your schema, you include...( Read More... Posted Sunday, August 02, 2009 10:46 AM from Home of the Data Dude | (Comments Off) Filed under: sqlcmd, VSDB2008GDR, DBProj.com

• 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 Thursday, July 30, 2009 8:37 AM from Home of the Data Dude | (Comments Off) Filed under: VSDB, setup, VSDB2008GDR, troubleshooting, DBProj.com

• VSDBCMD.EXE Return Codes

  Quick one based on a forum question where somebody asked how to detect if VSDBCMD.EXE failed or succeeded inside a batch file. VSDBCMD.EXE does not return a very elaborate amount of information, there are just two return values 0 and 1, where zero indicates...( Read More... Posted Wednesday, July 22, 2009 6:09 AM from Home of the Data Dude | (Comments Off) Filed under: VSDB2008GDR, DBProj.com, vsdbcmd

• Agile Database Techniques

  I am happy to announce that there is a new class dedicated to VSDB. “ Agile Database Techniques ”, is a 3-days course that provides students with the knowledge and skills to properly manage the SQL Server database development lifecycle in an agile environment....( Read More... Posted Thursday, July 09, 2009 10:16 AM from Home of the Data Dude | (Comments Off) Filed under: training, tsbt-db, VSDB2008GDR, DBProj.com

• 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 Monday, June 22, 2009 9:21 AM from Home of the Data Dude | (Comments Off) Filed under: sqlcmd, VSDB, VSDB2008GDR, DBProj.com, MSBuild

• 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 Thursday, June 11, 2009 10:10 AM from Home of the Data Dude | (Comments Off) Filed under: tsbt-db, VSDB, DatabaseReferences, VSDB2008GDR, DBProj.com, DBSchema

• System Objects in TEMPDB

  Today a user send me a question how to resolve reference of system objects inside tempdb? My first thought was this should get resolved by loading the master.dbschema file. However this did not resolve the issue, so time to ask for an example, which slightly...( Read More... Posted Thursday, June 11, 2009 9:17 AM from Home of the Data Dude | (Comments Off) Filed under: tsbt-db, VSDB, DatabaseReferences, DBProj.com

• 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 Saturday, June 06, 2009 8:58 AM from Home of the Data Dude | (Comments Off) Filed under: tsbt-db, VSDB, Declarative Database Development, DBProj.com