Andy Leonard : Team Edition for Database Professionals

New E-Book: Mastering Database Edition Volume 1

andyleonard — Wed, 11 Jun 2008 17:20:00 GMT

My first e-book is out! Mastering VS 2008 Team System Database Edition, Vol 1: Creating and Deploying Database Projects is available at Solid Quality Press.

Volume 1 of the Mastering Visual Studio 2008 Team System Database Edition series focuses on creating and deploying database projects. The goal of the manuscript is to provide the concise and practical knowledge required to build and deploy a database project. Topics include database project creation, database deployment, database development principles and best practices, version control, and database application lifecycle management.

I'm writing Volume 2 now which focuses on Database Testing with Database Edition.

:{> Andy

Power Tools for Visual Studio Team System 2008 Database Edition

andyleonard — Fri, 15 Feb 2008 06:55:00 GMT

Gert and team announce the availability of Power Tools for Visual Studio Team System 2008 Database Edition!

Cool new stuff includes a couple new test conditions, file- and XML-based data generators, and (my favorite) SQL Static Code Analysis integrated into MSBuild / Team Build!

Download page:
http://www.microsoft.com/downloads/details.aspx?FamilyID=73ba5038-8e37-4c8e-812b-db14ede2c354&displaylang=en

Installer download:
http://download.microsoft.com/download/f/b/8/fb8d1c0d-c0c4-4004-ab86-12396b2a3ee3/VSTSDB2008PT.msi

Documentation download:
http://download.microsoft.com/download/f/b/8/fb8d1c0d-c0c4-4004-ab86-12396b2a3ee3/Power Tools 2008.doc

Great work Team!

:{> Andy

Database Testing on .Net Rocks!

andyleonard — Wed, 16 Jan 2008 10:00:00 GMT

I am honored to be the guest of a .Net Rocks! show on Database Testing! Richard Campbell, Carl Franklin, and I recorded the show last night and I had a lot of fun!

Richard and I commiserated about the "DBA condition" in the enterprise. Everyone shared "war stories" about projects. A good time was had by all.

I have to thank Chris Love - friend, tireless advocate of the Raleigh Developer Community, fellow Solid Quality Mentor, and (finally!) MVP - for setting this up. He was the gracious emcee of my recent presentation on Testing The Database to TriNUG (Triangle .Net User Group). Chris had heard a recent .Net Rocks! show where the discussion turned briefly to database testing, so he did the leg work to put Carl, Richard, and myself together for this show.

The show is scheduled for release 29 Jan 2008.

:{> Andy

Visual Studio 2008 RTM

andyleonard — Mon, 19 Nov 2007 12:07:00 GMT

Visual Studio 2008 Team Suite bits are available for download to MSDN Subscribers!

:{> Andy

From my PASS presentations: Custom Test Condition Code: ETL Counts (Team Edition for Database Professionals)

andyleonard — Thu, 20 Sep 2007 20:47:00 GMT

I'd like to thank the people that attended my sessions at the 2007 PASS Summit in Denver this week! I had a blast and hope you all did as well.

The code will be available from the PASS website and on a DVD. For those in my sessions, I promised I would post the code here for my custom Counts test condition for Team Edition for Database Professionals. Free registration at VSTeamSystemCentral.com is required.

Extending Team Edition for Database Professionals with custom test conditions is fairly straightforward once you understand it. (Like everything else in life, Mr. Obvious...)

If you are completely new to coding and would like to build a custom test condition for database testing, fear not! The last part of Chapter 4 (entitled Testing the Database) of the Wrox book Professional Software Testing with Visual Studio 2005 Team System: Tools for Software Developers and Test Engineers is dedicated to a beginner's walk-through of building your first custom test condition.

Yes I am promoting my new book. There's a reason: it's a good book.

:{> Andy

Technorati Tags: Database testing Team Edition for Database Professionals Custom test condition PASS

PASS Presentation - Team Edition for Database Professionals

andyleonard — Tue, 28 Aug 2007 16:08:00 GMT

I am honored and so excited to be presenting a couple sessions at the PASS Summit in Denver next month!

One presentation is entitled Applied Team Edition for Database Professionals. The focus is TEDP in action for database development. I cover a lot of the material in my Testing the Database chapter of the new Wrox book: Professional Software Testing with Visual Studio 2005 Team System: Tools for Software Developers and Test Engineers - due out the week before the PASS Summit. Included is a walk-through of how to create and integrate a custom Team Edition for Database Professionals Test Condition.

I hope to see you there!

:{> Andy

PASS Webcast Thursday

andyleonard — Thu, 19 Jul 2007 01:11:00 GMT

Although it doesn't mention my name on the PASS website, I'm presenting the PASS webcast tomorrow on Team Edition for Database Professionals.

If you're interested you can sign up to attend at the PASS website. Hope to see you there!

:{> Andy