Power Tools Installation Problem (error code 2738)

Some users have been reporting problems installing the VSDB Power Tools on Vista or Windows Server 2008 (applies to both 32 and 64 bit versions). When they run the Power Tools installer they are confronted with the following mysterious error message: Error code 2738 implies that the VBScript engine is not enabled. On some Vista…


Command line SQL Static Code Analysis

We have had a lot of requests from users asking us to make T-SQL Static Code Analysis available at build time and from the command line. The latest Visual Studio Team System 2008 Database Edition Power Tool release, adds this ability to the product through a new MSBuild task. In this blog post I will…


File Bound Generator

An other new addition to the Visual Studio Team System 2008 Database Edition – Power Tools release is the File Bound Generator. This data generator grovels through files inside a directory or optionally through its subdirectories, based on some search filter you provide and loads the content of the file in to a column value….


Data Generation Wizard

One of the new features in the Visual Studio Team System 2008 Database Edition – Power Tools release is the addition of the Data Generation Wizard. The Data Generation Wizard is an item template wizard that allows you to create and configure a data generation plan by pointing it at an existing database, which has…


Visual Studio Team System 2008 Database Edition Power Tools

The “DataDude” team is happy to announce the availability of the Power Tools for Visual Studio Team System 2008 Database Edition. The Power Tools for 2008 contains all the functionality we shipped in 2005 plus: Command line SQL Static Code Analysis execution through MSBuild, this was the biggest customer request, which is why I was…


Data Bound Generator vs. Sequential Data Bound Generator

The Power Tools v1.0 release adds a new data generator, named the “Sequential Data Bound Generator”. Since there already exists a data generator named the “Data Bound Generator” this yields the question what the difference is between the two is and when to use either one of them. Data Bound Generator The Data Bound Generator,…


Channel 9 video Covering Power Tools & Service Release 1 Functionality

Before I left for vacation, I did a quick video recording for Channel 9 together with Brian Keller showing off the new functionality in the Visual Studio Team Edition for Database Professionals Power Tools and Service Release 1. You can find the video at this location https://channel9.msdn.com/showpost.aspx?postid=334261 Brian also released a video he did with Sachin…


Power Tools Download Link

They are here! Dependency Viewer Refactoring Move Schema Expand Wildcard Fully Quality Name Refactor in to strongly typed DataSet definitions Refactor Command Generator Data Generation Sequential Data Bound Generator Editors for the Data Bound Generator, Sequential Data Bound Generator and RegEx String Generator to make configuration easier The RegEx editor also tries to interpret your CHECK CONSTRAINTs…


What is in the Power Tools v1.0 release?

For those of you who have been paying close attention, you know that August 6th is the date I promised the first Power Tools to be released. So where are they? We are not there yet, we released the first release candidate today, I need to finish two more threat models and then we are…