Channel 9

Entries:
Comments:
Posts:

Loading User Information from Channel 9

Something went wrong getting user information from Channel 9

MSDN

Activity Profile

Latest Achievement:

Loading User Information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements
Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

Visual Studio 2005 Team Edition for Database Professionals

Embed code for this video

Copy the code above to embed our video on your website/blog.

Close

Video format

Option selected may change based on video formats available and browser capability.

Close

Download

How do I download the videos?

  • To download, right click the file type you would like and pick “Save target as…” or “Save link as…”

Why should I download videos from Channel9?

  • It's an easy way to save the videos you like locally.
  • You can save the videos in order to watch them offline.
  • If all you want is to hear the audio, you can download the MP3!

Which version should I choose?

  • If you want to view the video on your PC, Xbox or Media Center, download the High Quality WMV file (this is the highest quality version we have available).
  • If you'd like a lower bitrate version, to reduce the download time or cost, then choose the Medium Quality WMV file.
  • If you have a Zune, WP7, iPhone, iPad, or iPod device, choose the low or medium MP4 file.
  • If you just want to hear the audio of the video, choose the MP3 file.

Right click “Save as…”

Cameron Skinner, Gert Drapers, Robert Merriman, Thomas Murphy, and Matt Nunn sat down with me to discuss a new edition to the Visual Studio Team product family: Visual Studio 2005 Team Edition for Database Professionals.  We talked about why this product was created and Cameron (the product unit manager) gave a walk through of the current CTP release.  Targeted for delivery at the end of the year, you can grab the CTP bits and learn more at the team’s website: http://msdn.microsoft.com/vstudio/teamsystem/dbpro/

Tags:

Follow the Discussion

  • Jeroen RitmeijerJeroen Ritmeijer
    Very interesting, I cannot wait for the final version. I have had to do all this using various bespoke utilities and methodologies and it is nice that Microsoft is finally taking this part of the market seriously.

    Any chance this works with Oracle as well?
  • Robert M - MSFTRobert M - MSFT

    Thanks for the interest.  For V1, we will have support for Microsoft SQL Server 2000 & 2005.  We have heard the request for having the tools work with other database platforms and are investigating that for a future release.

    Robert Merriman
    Test Manager
    VS Team Data

  • rminderrminder
    Great looking product!

    Our development team currently uses Visual Team Edition for Software Developers. Will we have to purchase Team Edition for Database Professionals separately when it's released? It sounds from the video that we will not have to. Is this correct?
  • prabhuprprabhupr

    In Production Database we have multiple tables which has PII (Personal Identity Information) Columns and we would not like to share that with DEV/TEST/UAT environment due to company terms and agreement + policies (as we plan to outsource the work)

    Will there be any tool/functions/feature provided in the IDE which will generate "Fictitious Data" for each of these column(s) that we can call before the DB copy is sent to Dev/Test/UAT.  May be we can provide an XML which will have Table + Column name combination which we identify as PII column, which we will provide as input to IDE which then does the magic.

  • prabhuprprabhupr
    To Generate Data, can I use UDF?
    We have written some  UDF's that we execute on our Database to MOCK current Data column, can those be invoked, if so, could you please let me know how?
  • prabhuprprabhupr
    Hi Matt, Gert

    Will this tool (IDE) support "Unit Test Code generation" for existing code-base or its only for new code only?
  • prabhuprprabhupr

    Question on Re-factoring

    ==================

    What if somebody wants to change the "Column Length"

    1. Will the UI display appropriate Object that needs this change

    2. If we are reducing the column length, will it warn about DATA Truncation

    3. Not sure if it will also display UI dependencies (if I have Solution with one Project for DB and another project for UI) that needs change due to this column name/length change. Will it?

  • prabhuprprabhupr

    1. Can I disable a specific unit test (from the suite) from running

    2. Any way we can get statistics of "Code Coverage"

    3. Any plan on adding "Snippets"/"Common Code Library"

     

  • prabhuprprabhupr
    At the very end you guys mentioned about Hands-on-lab, could you please provide the URL

    Other URLS:
    http://blogs.msdn.com/camerons/
    http://msdn.microsoft.com/vstudio/teamsystem/products/dbpro/
  • dmarshdmarsh Knee draggin'
    I am beyond excited to see this product coming. Big Smile I was extremely upset that, even though DB projects in 2003 weren't that great, they were crippled even more in 2005 (no export of data, no generation of command files, etc.). [C]

    This looks like everything I've ever wanted and it's finally integrated into my favorite IDE instead of having to turn to a third part product. Can't wait for it to be released!

    Cheers,
    Drew
  • William Staceystaceyw Before C# there was darkness...

    Very nice work.  Hope to use it soon.  Seems to address most of the pain of working in local/test/prod, etc.  It would seem not to be too hard to scan all the embedded sql (i.e. "select x,y from z") in a project to rename names as well.  Would this be possible?  TIA

  • paulirwinpaulirwin
    i am so excited about this. and i'm even more excited about the fact that it supports 2000 as well. we're in the process of upgrading to 2005, but being able to support both with one product will be VERY nice. great job, guys!
  • SqlDenisSqlDenis UPDATE STATISTICS
    Just downloaded CTP 4, can't wait to try it
  • ringiringi

    List most ISV, we have to support more then just SQL server.  Our customers choose the database not us.

    When will this support Oracle and db2 as well as SQL server.

    Will the SAME unit tests be able to run with more then one vender's database?

    Will I be able to compare and move schema changes across SQL Server, Oracle and DB2?

    I don’t mind, (in fact I would be very happy) fs you ONLY supported the common subset of SQL between the 3 leading databases.   If it only works on SQL server I can’t use it.

  • cameronscamerons

    If you step up to suite, DBPro is included at no additional charge.

  • cameronscamerons

    In regards to generating data with DBPro, please see this post as a starting point: https://blogs.msdn.com/camerons/archive/2006/06/30/652407.aspx

  • rstonerstone
    Heh, there was a reference to the Data Bound Generator being renamed to Reference Data Generator when it ships... it's still Data Bound Generator!

    Anyhoo, nice product, great job guys!

  • girishpvgirishpv
    We are going to do a POC using Orcas team suite. also want to use DB Pro.

    But unfortunately DB Pro is not available in Orcas beta 1.

    Any suggestion? will it be available with next beta?

    Thanks,
    Girish

Remove this comment

Remove this thread

close

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.

More posts in this blog

See More

Related posts

Creative Commons License

© 2013 Microsoft. Except where designated as licensed by
Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 License,
Microsoft reserves all rights associated with the materials on this site.