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: DECLARE @value nvarchar(512), 2: @rc int; 3: EXEC @rc = [master].[dbo].[xp_instance_regread] N’HKEY_LOCAL_MACHINE’,N’Software\Microsoft\MSSQLServer\MSSQLServer’,N’DefaultData’, @value output–…

1

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 stored procedures, the user could no resolve the reference to the extended stored procedures….

2

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 development processes it becomes even more obvious that there is room for improvement in this area. When…

10

RTM of VSDB 2008 GDR R2

The QFE rollup release for the Visual Studio Team System 2008 Database Edition GDR release is now available. You can download the SETUP.EXE from the regular location. (http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed) If you have the VS2008 RTM version of the Database Edition or the RTM version of the VSDB 2008 GDR release installed, this setup will automatically upgrade…

10

FIX: Blank Unit Test Designer Problem

If you are running in to the following problem when creating unit tests when using database projects, there now is a fix! Consider the following scenario, you have you database project (.dbproj) open and requesting the creation of a Database Unit Test by right clicking on for example a stored procedure objects inside Schema View….

2

VSTSDB Blog Site

The Visual Studio Team System Database Edition team has created a new blog site to keep you informed and update about the latest developments. Please check out: http://blogs.msdn.com/vstsdb Thanks, -GertD

1

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 a new place to publish my DataDude contributions to…

2

Data Generator for SQL Server Sparse Columns

Genevieve, tester on the “DataDude” team, has created a new Data Generator which allows you to populate a random set of sparse columns through the use of an XML column set column. She posted it on the VS Code Gallery, http://code.msdn.microsoft.com/columnsetgenerator. -GertD PS: Dank je wel Genevieve!

2

Final Language Release of the GDR

Today we released the last language, Russian, of the planned localized versions of Visual Studio Team System 2008 Database Edition GDR. This brings the total count to 10 (including English). You can download the Russian edition of the GDR from the following location: http://download.microsoft.com/download/A/2/C/A2C861C5-93F6-400A-9FE6-256D3161005C/Readme.mht http://download.microsoft.com/download/A/2/C/A2C861C5-93F6-400A-9FE6-256D3161005C/setup.exe You can select the language of your choice from the…

2

File Level Build Warning Suppression in the GDR

One of the small, but hard to discover new features in the GDR release is the ability to suppress warnings at the file level. Just to be very clear, this is suppression of build level warnings, not of static code analysis or deployment warnings! Imagine you have a procedure that references a temp table that…

7