Katmai: Variable Initialization and Assignment Operators

It’s    again. Today I’m going to go over two new enhancements related to TSQL variables and how they acquire their values. TSQL Variable Declaration and Initialization In SQL 2008, the syntax by which TSQL variables may be declared has been enhanced. It is now possible to initialize variables during the DECLARE statement. This initialization…

1

Best Practices : The Truth of the Schema is In The Database Project

Wednesday is at ZoDD. This is the day for focusing on the Whys behind the Hows of using Visual Studio Team System for Database Professionals, and for trying to provide some direction for dealing with different issues regarding the Application Development Lifecycle, as it relates to our product. I’m going to start this series out…

2

Getting DataDude, or What Do I Install Next?

Monday is at ZoDD. Monday’s we’ll be discussing some subject that relates directly to Visual Studio Team System for Database Professionals (aka DBPro) – a feature or a new Power Tool or a new piece of available functionality. Today I’m going to start off by addressing something that I get a lot of questions about…

1

Samples: Registering Extensions for VSTS.DBPro

Friday is at ZoDD, where I’ll try to bring you some working code samples that leverage features and functionality you can find in the currently released version of Visual Studio Team System 2005 for Database Professionals. Today begins a series of posts that will deliver on a long-standing, but all-too neglected promise I’ve been making…


Katmai: Looking into Row Constructors

  Thursday is   here at ZoDD, and today I’m going to be discussing the first in a series of posts covering features that show up in SQL Server 2008, using the latest Community Technology Preview, CTP4. This morning’s subject will be the new functionality they are calling Table Value Constructors, and sometimes, perhaps more clearly,…

2

Return of the Blogging Dead

  So, embarassingly enough, this blog has been devoid of activity for some time now. Well, let’s see if we can’t catch up on some of this. For those of you who have been patiently (and not so patiently) waiting for my downloads for Custom Data Generators and Custom Unit Test Conditions, stay tuned! That…

1

DBPro – Public CTP for Service Release 1 released.

Ok, let’s do the big news first… The One and Only Public CTP for DB Pro’s Service Release 1 – has gone live! Since we just RTM’d version 1 in December, this is a public CTP of our first Service Release. But it does more than address a few bugs. It has some cool new…


Datadude and the Text Filegroup

So, we had an interesting problem crop up from a European customer, and investigating it uncovered both a little known, um… feature in SQL Server, and a bit of a twist in our handling of it. The customer had a table that he was Reverse Engineering from his source database into a DBPro project. The…

1

Why not Insanity?

Writing the first entry in a blog has always seemed to be the hardest. Since this is a new year, and this is all about Something New, I thought I’d take the moment to blather about why I have made the change over from Dev to PM. I’m part of the Visual Studio Team System…

1