Crazy week around here with everybody finishing up their sprints before the holidays!
Three new exciting downloads and a new Channel9 Video on the Visual Studio Update1 for you over the Holidays!
- Visual Studio 2012 Team Foundation Server Monitoring Management Pack
- ASP.NET and Web Tools 2012 2 Release Candidate
- SQL Server Data Tools – December 2012
Visual Studio 2012 Team Foundation Server Monitoring Management Pack
The Team Foundation Server 2012 Monitoring Management Pack provides both proactive and reactive monitoring of Microsoft Team Foundation Server 2012. It monitors TFS components such as application tier server instances, team project collections, build servers, and proxy servers.
ASPNET and Web Tools 2012 2 Release Candidate
The ASP.NET and Web Tools is a tooling refresh of Visual Studio 2012 and extends the existing run time with new features without breaking existing applications. Since it is only a release candidate we have not tested this build to the same level we test RTM products; therefore please be smart about which machines you apply it to!
This update adds new templates and features including:
- Enhancements to Web Publishing unifying Web Application and Website project publish experience.
- New Web API functionality including support for OData, tracing and generating a help page for your API.
- New MVC templates
- Facebook Application just became easier using the MVC Facebook template. In just a few easy steps you can create a Facebook Canvas Application that gets data from the logged in user as well as integrates with friends.
- Real-time communication via SignalR.
- Extensionless Web Forms via ASP.NET Friendly URLs which makes it very easy for web forms developers to generate cleaner looking URLs(without the .aspx extension). It can be used with existing ASP.NET v4.0 applications. The FriendlyURLs feature also makes it easier for developers to add mobile support to their applications, by supporting switching between desktop and mobile views.
By: Robert Green
In this video Robert Green and Brian Keller cover off the Visual Studio Update. Starting with Visual Studio 2012, Microsoft has moved to providing update to Visual Studio on a regular cadence of shorter intervals. The first such update, Visual Studio 2012 Update 1, is now available. In addition to bug fixes, Update 1 contains new features in four areas: Windows development, SharePoint development, agile teams, and continuous quality. In this episode, Brian Keller shows us some of his favorite new Update 1 features
The SSDT team is pleased to announce that SQL Server Data Tools – December 2012 is now available for download!
We have received an overwhelming amount of feedback that database unit testing is a critical feature for customers, so SSDT- December 2012 adds support for this feature. Database Unit Testing in SSDT will look familiar to many of you as it is based on the equivalent capability in the Visual Studio 2010 DB Pro tools. Some highlights:
- Installs in Visual Studio 2010 or Visual Studio 2012:
- Requires Visual Studio Professional or higher edition to support database unit testing functionality.
- Installs side-by-side with existing Visual Studio 2010 DB Pro tools in Visual Studio Premium and Ultimate editions.
- Supports client-side testing based on MSTest with the same built-in test conditions as DB Pro.
- Allows desktop development and execution of tests as well as execution from the command line or as part of a build on a build server.
- Upgrades existing VS 2010 test projects without change to the database unit test scripts or code.
- Integrates with SSDT SQL Server database projects:
- Automates deployment of the database project on test initialization.
- Generates skeleton test scripts for stored procedures, functions and triggers via SQL Server Object Explorer.
- Applies changes to test scripts when refactoring objects in database projects.
- Supports custom test conditions (existing custom test conditions need to be modified before they can be used).
Stay tuned for a follow-up post on getting started with SQL Server database unit testing.
Integration of SSDT Power Tools
The SSDT team started releasing SSDT Power Tools last April as a mechanism to deliver new and experimental features with each release. Since then, the Power Tools have been downloaded over 24,500 times.
We received a great deal of positive feedback on the Power Tools and as a response, this release integrates the functionality previously delivered via Power Tools into the core SSDT product. The advantage of product inclusion is that a separate install will no longer be needed and that features are now fully supported and available to users in all languages. The following features are now included in SSDT’s SQL Server Object Explorer:
Projects node adds the equivalent of Schema View to SSDT. You can use this node to browse the logical schema of your project and to edit, refactor, and add new objects.
Script As support in SSOX enables you to generate Create, Alter, Drop, and Drop and Create-To scripts for objects in your connected database.
DAC actions allow you to perform similar DAC-based tasks in SSDT to those available in SSMS. You can extract a dacpac from a live database, publish a dacpac to a database, register a database as a DAC, or remove the registration metadata for a database registered as a DAC. These actions are supported for both on-premises SQL Server databases as well as Windows Azure SQL Databases.
Download it here
SSDT for Visual Studio 2012: http://msdn.microsoft.com/en-us/jj650015
SSDT for Visual Studio 2010: http://msdn.microsoft.com/en-us/jj650014
NOTE: We recommend that you uninstall the SSDT Power Tools extension if you had it previously installed.
Updated Data-Tier Application Framework
This release includes the November 2012 release of SQL Server Data-Tier Application Framework (DACFx), which contains several feature enhancements and bug fixes. You can learn more about the latest release of DACFx here.
SSDT – December 2012 contains over 50 bug fixes, including fixes for customer-reported issues from SSDT – November 2012 and SSDT Power Tools releases.
If you have any questions or feedback about SSDT, please visit our forum or Microsoft Connect page. We look forward to hearing from you.