Announcing Visual Studio Team Edition for Database Professionals

Really cool tool that I'll have to start blogging about! Here's the announcement I just received from Microsoft. I added some screen shots below.

Visual Studio Team Edition for Database Professionals delivers a market-shifting database development product designed to manage database change, improve software quality through database testing and bring the benefits of Visual Studio Team System and life cycle development to the database professional. It delivers on Microsoft’s commitment to provide tools that reduce communication barriers and complexity across software development teams and fulfils increasing demand in the market for more advanced database change management tools. Database professionals such as database architects, database developers and database administrators, can now employ integrated change management functionality to streamline changes to their databases, ensure quality, and speed deployment.

Visual Studio Team Edition for Database Professionals includes a number of great new features:

·         A new Visual Studio Database Project allows you to import your database schema and place it under source control. When the time comes to deploy schema changes the new project system allows you to quickly build update scripts or packages and then provides a mechanism to deploy them to the database of our choice.

·         Rename Refactoring allows you to easily rename any object in your database and be assured that all references to that object will be renamed to correspond to the change

·         A New T-SQL Editor allows you to be more productive when writing T-SQL code from within Visual Studio including support for parallel execution of queries and viewing of execution plans.

·         SchemaCompare allows you to quickly compare the schema of two databases (or your source controlled project and a database) and script updates to bring the database schemas into sync

·         DataCompare allows you to quickly compare two databases and script updates to bring the data in these databases into sync

·         The Database Unit Testing infrastructure allows you to create database unit tests using T-SQL or managed code.

·         DataGenerator lets you create data generation plans that produce repeatable sets of meaningful data based upon your existing production databases that can be deployed to a database prior to running unit tests thus ensuring consistent test results

You can find out more about this great new release, see screenshots and find out how to get the early community technology preview which will be available on June 11^th at http://msdn.microsoft.com/vstudio/teamsystem/products/dbpro/default.aspx

We are making Visual Studio Team Edition for Database Professionals part of the Visual Studio Team Suite, so you’ll get this product for free when we RTM this edition if you are a Visual Studio Team Suite subscriber through MSDN. You can learn more about how to upgrade to Visual Studio Team Suite at http://msdn.microsoft.com/vstudio/howtobuy/renewal/#step

Visual Studio Team Edition for Database Professionals will also be available as a stand alone Edition in the Visual Studio Team System family. You can learn more about how to buy Visual Studio Team System at http://msdn.microsoft.com/vstudio/howtobuy/default.aspx

The team has already started blogging. You can find out more information directly from the product team by visiting the following blogs:

http://blogs.msdn.com/gertd/
http://blogs.msdn.com/camerons
http://blogs.msdn.com/rwaymi
http://blogs.msdn.com/mattnunn
http://blogs.msdn.com/thomas_murphys_agile_db_blog
http://blogs.msdn.com/tsdatabl

Take Control of Database Change

Automated Database Testing

Improve Collaboration and Communication

Free All Day HA Event in Jacksonville, FL

Whether you’re a developer, DBA or manager, you’ll get something out of this all day SQL Server free event from Microsoft and Idea Integration (Brian from SQLServerCentral.com will be doing part of the event). This event is being run with Microsoft and Idea Integration and will be at a detailed tech level (no marketing). This all-day session is designed to Get You Started with Microsoft SQL Server 2005 High Availability and gotchas when upgrading to 2005. High availability is a hot topic for most enterprise customers.  Any application downtime can impact your business, resulting in revenue loss, customer dissatisfaction, and damaging creditability of their business.  Application downtime can be caused by a variety of issues such as human error, natural disasters, hardware failure, and application upgrades.  Today, SQL Server 2005 has a full range of options, which could achieve and maintain appropriate levels of application availability.  However, there is a lack of awareness around these features.  Moreover, there is limited information to guide customers to choose the right features to achieve their availability goals. 

Space is limited for this event and this email is going out to more than 300 so please register fast to claim your seat.

These 300 Level sessions will be mostly demos from Microsoft and Idea Integration!

Q&A periods and post-event networking are built into the schedule to enable you to get your questions answered.

For:                  Architects and Database Administrators

When:               Wednesday, June 7, 2006, 8:45am to 5:00pm
Speakers will remain after the event for ad hoc discussions

Agenda:            See next page for detailed agenda.  Sessions will focus on upgrading to SQL Server 2005 and High Availability Data Management.

Where:             Modis Building in Auditorium (on 2nd story)  1 E Independent Dr, Jacksonville, FL 32202 Office number: 904.360.2700 or Toll Free: 800.idea.com.  

Cost:                 Free event

Parking:            Parking available at Landing or in 9-story garage across the street.

Language:         English-United States

Lunch:               Provided

Registration:      DUE TO SPACE LIMITATIONS, REGISTRATION IS REQUIRED

                        Event URL : http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032297798&Culture=en-US

                          Event ID : 1032297798

I hope you will be able to join us. Please contact me directly if you have additional questions.

SQL Server 2005 Always on – HA Day

http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032297798&Culture=en-US