Service Release 1 is HERE!

Visual Studio Team Edition for Database Professionals Service Release 1

EXEC dbo.LongTermMemory__Archive — Wed, 25 Jul 2007 08:42:14 GMT

Just a quick note for those of you who are lucky enough to work with VSDBPRO. Service release 1 is available,

re: Service Release 1 is HERE!

hoodg — Thu, 26 Jul 2007 10:50:57 GMT

Confused about DataDude - I use VS professional. Is Datadude just another addin allowing me to create db projects, or is it a completely separate dev product? Does it require team foundation server? If I wait for VS 2008 is it included in the professional version?

Thanks for any clarifications.

VSTS Links - 07/26/2007

Team System News — Thu, 26 Jul 2007 18:15:07 GMT

The Accentient Blog on Using Project to enter "Resources". GertD on Service Release 1 is here! Grant...

re: Service Release 1 is HERE!

Djeepy1 — Mon, 30 Jul 2007 18:35:26 GMT

Hi,

I'm pleased to see SR1 available because I needed it for variables support. But I'm surprised to see that variables can only be used in a restricted context.

There is my need in post-deployment scripts :

IF $(DEBUG) = 1

Begin

--test data for development environment

INSERT INTO dbo.myTable VALUES('some data')

End

But $(DEBUG) used as described upper generates an error at parsing.

The workaround I use is :

Declare @debug as int

select @debug = cast('$(DEBUG)' as int)

if @debug = 1

print 'DEBUG MODE!!!'

Anymore smart solution ?

re: Service Release 1 is HERE!

gertd — Fri, 10 Aug 2007 19:51:25 GMT

The pre-processor only expand variables and includes and does not have the notion of conditionals. This is only because we wanted to stay compatible with the infrastructure used by SQLCMD.EXE and SQL Server Management Studio.

We do have a strong need for conditional support based on variables, so we are going to add this in the Rosario release, but by doing that we are breaking compatibility with SQL Server 2005 and 2008 in this area.

-GertD

New Service Release and Power Tools for Visual Studio Team Edition for Database Professionals

Noticias externas — Tue, 14 Aug 2007 22:05:14 GMT

The team that builds Visual Studio Team Edition for Database Professionals (or “DBPro” for short!) has

New Channel 9 Video: DBPro Service Release and Power Tools

Brian Keller: Technical Evangelist for Team System — Tue, 14 Aug 2007 22:08:30 GMT

Gert Drapers and I recently sat down to film a Channel 9 interview showcasing the new Service Release

Data Dude : Database Documentor

SimonS SQL Server Stuff — Fri, 17 Aug 2007 00:17:35 GMT

If you want to document your database you've got to see Gert Drapers on Channel9. Data Dude is answering

Data Dude : Database Documentor

SimonS' SQL Server Stuff — Fri, 17 Aug 2007 00:17:42 GMT

My blog has moved to sqlblogcasts.com/blogs/simons

The full version of this post can be found here.,...

Visual Studio Team Edition for Database Professionals Service Release 1

EXEC dbo.LongTermMemory__Archive — Thu, 27 Sep 2007 18:29:31 GMT

Just a quick note for those of you who are lucky enough to work with VSDBPRO. Service release 1 is available

re: Service Release 1 is HERE!

Martin Douglas — Fri, 19 Oct 2007 23:48:08 GMT

Is there support for UPDATE FROM syntax with SP1? It appears the parser does not handle an alias well. This leads to hundreds of warnings for me. Snippet from a sample:

update

[Security].[dbo].[AdUsers]

set

userid = s.userid,

domain = s.domain,

status = s.status,

...

from

[Security].[dbo].[AdUsersStage] s

where

[Security].[dbo].[AdUsers].guid = s.guid

and

[Security].[dbo].[AdUsers].lastupdate < s.lastupdate

The stage table is aliased as "s" since it has columns identical to those in AdUsers.

The warning thrown is:

Warning 1 TSD3006: The relationship from [Procedure] dbo.admsp_adsynch cannot be resolved between the following possible identifiers: [Column] Security.dbo.AdUsersStage.s, [Column] Security.dbo.AdUsersStage.userid, [Column] Security.dbo.AdUsers.s. C:\Documents and Settings\douglma\My Documents\Visual Studio 2005\Projects\Test\Security Database\Security Database\Schema Objects\Stored Procedures\dbo.admsp_adsynch.proc.sql 22 11 Security Database