31Oct 2008 by Grant Fritchey No Comments

VSTSDBE RC0 Install

Tools, Visual Studio
I've downloaded and started the install. The first screen I'm seeing is not filling me with confidence. The executable that is currently running is called "DBProRepair.exe" However, the installed completed without any issues. Just for giggles, I tried opening my PASS presentation (created on CTP 17). If it worked, I wouldn't have to recode. Ah, well, no joy. Not that I expected any. Oh, but the Conversion Report that comes up afterwards is very informative. Reverse engineer against the AdventureWorks2008 database went off without a hitch. All the objects imported into the database with no issues too. So far, so good. Created all the projects. No issues. I'm configuring for a deployment now. We'll see how that goes. Builds worked fine. I forgot to change the deploy action the first…
Read More
31Oct 2008 by Grant Fritchey No Comments

Visual Studio Team System Database Edition GDR RC

Tools, Visual Studio
I'm a bit late to notice this, but Gert Drapers announced on Monday that the release candidate for VSTSDBE, or good ole VSDB as I've decided to call it, is now available. I figured they'd do something during the Professional Developers Conference (where supposedly a new printing of my book was being given out). Now I need to get on the stick & upgrade my virtual... maybe. According to the post, functionality hasn't changed. Maybe I should just leave everything alone on my machine until after PASS... Nah! I'll post progress for the uninstall, the install and the recreation of the compound project.
Read More
12Sep 2008 by Grant Fritchey No Comments

VSTS 2008 Database Edition GDR CTP 16

Tools, Visual Studio
CTP 15 utterly hosed the virtual device I had it on. I tried uninstalling, but it just wouldn't come off clean. I finally have rebuilt the virtual and reinstalled everything except VSTSDB GDR. Having learned my lesson (the hard way as usual), I started a differential on my virtual for the install of CTP 16 so that I can roll back and install the release candidate and the release as they come out without having to go through that whole rebuild thing again. While Gert & crew are still making some changes, the fundamentals are still there so my presentation at PASS should work fine as currently defined. The only problem I ran into was that I couldn't get the database to deploy by simply clicking on the deploy menu…
Read More
07Mar 2008 by Grant Fritchey No Comments

Unit Testing Database Code

Tools
Steve Jones, in his daily email from SQL Server Central, supplied a link to a terrific article in the MSDN magazine. Apply Test-Driven Development to your Database Projects. It was written by Jamie Laflen who is a Tech Lead on the DBPro team.  I've written a couple of articles on database unit testing, but none of them touch this. It's the new gold standard for introducing the topic to beginners (and lending a helping hand to experienced users). It's worth a read, or even two. I'm going to go back and review it a couple of times with Visual Studio open and a project running. No word yet on new virtuals. I'm going to work on another set of tests that I have to run. More on that later.
Read More