.

Power Tools for Team System DB Edition

Hurray! The Power Tools for Team System 2008 DB Edition is now available. You can find more information about it at Gert Draper's blog and Dave Scruggs' blog.

A couple of the things I'm really interested in looking at are the "Dependency Viewer" and "Wildcard Expansion" for refactoring. I just installed it. (Note: I needed to be running as Administrator to install. Don't know if you'll have the same experience. I opened up a command line as Administrator and executed the installer from there.)

Check out all the cool options for refactoring:

And what's this? Static code analysis for TSQL??? Sweet!

There's a neat-looking new Regular Expression Builder UI underneath the Data Generator option:

And there's a list of pre-packaged Regular Expressions included:

And if you're in Schema View, you can see the Dependency Viewer option when you right click:

Here's an example of everything that references the Categories table in the Northwind sample database:

 
As you expand the nodes you can see that it's recursive:

Very cool stuff indeed.

I believe most of this was available for Database Edition in 2005, but now it's available for 2008.