Visual Studio 2012 RC

Hi Friends,

Visual Studio 2012 RC is ready to use, they are not released finally as these are only Pre-Release versions. We can download it from Microsoft site. There are 4 version of the Visual studio 2012 currently they are

1. Visual Studio Ultimate 2012
2. Visual Studio Premium 2012
3. Visual Studio Professional 2012
4. Visual Studio Test Professional 2012

All version are having special features as per your requirement. I just wanted to inform you all about the difference between the various version of the Visual Studio 2012. Below is a chart that provide details.

	Visual Studio Ultimate 2012	Visual Studio Premium 2012	Visual Studio Professional 2012	Visual Studio Test Professional 2012
Debugging and Diagnostics	****	***	**
IntelliTrace (Historical Debugging)
IntelliTrace in Production
Code Metrics
Graphics Debugging
Advanced Web Debugging
Static Code Analysis
Debugger
Windows 8 Metro Style Simulator
Profiling	Includes Tier Interaction Profiling	Includes Tier Interaction Profiling
Windows Phone 7 Emulator
Testing Tools	****	***	*	**
Web Performance Testing
Load Testing
Microsoft Fakes (Unit Test Isolation)
Code Coverage
Coded UI Testing
Manual Testing
Exploratory Testing
Test Case Management
Fast Forward for Manual Testing
Lab Management
Extensible Testing Framework
Unit Testing
Integrated Development Environment	****	****	***
Code Clone
LightSwitch
One-Click Web Deployment
Extensible WPF-Based Environment
Model Resource Viewer
Multi-Targeting
Blend for Visual Studio
JavaScript and jQuery Support
Project & Solution Compatibility with Visual Studio 2010 SP1
Multiple Monitor Support
Development Platform Support	****	****	****
Windows Desktop Development
Windows Metro style Application (including ARM) Development
Web Development
Windows Phone Development
Office and SharePoint Development
Cloud Development
Customizable Development Experience
Architecture and Modeling	****	**	*
Architecture Explorer
Architecture and Layer Diagrams
Architecture Validation
UML® 2.0 Compliant Diagrams (Activity, Use Case, Sequence, Class, and Component)		Read-Only Diagrams
Visualize Code with Dependency Graphs (By Assembly, By Namespace, and By Class)		Read-Only Diagrams	Read-Only Diagrams
Lab Management	****	****		****
Virtual Environment Setup & Tear Down
Provision Environment from Template
Checkpoint Environment
Team Foundation Server	****	****	***	****
Backlog Management
Sprint Planning
Agile Task boards
Exception Analytics
SharePoint Integration (Team Project Portal) Microsoft SharePoint Server licensed separately			Requires full Team Foundation Server and CAL which are included with MSDN Subscription or available for purchase separately
Reporting & BI			Requires full Team Foundation Server and CAL which are included with MSDN Subscription or available for purchase separately
Project & Project Server integration Microsoft Project and Project Server licensed separately			Requires full Team Foundation Server and CAL which are included with MSDN Subscription or available for purchase separately
System Center Integration Microsoft System Center licensed separately			Requires full Team Foundation Server and CAL which are included with MSDN Subscription or available for purchase separately
Version Control
Work Item Tracking
Build Automation
Collaboration	****	****	**	***
PowerPoint Storyboarding
Feedback Manager
Code Review
Task Suspend/Resume
Team Explorer
Team Explorer Everywhere for TFS (3rd-Party Development Tools Support)
Software and Services for Production Use	****	***	*	*
Ultimate Feature Packs
Team Foundation Server			Requires MSDN Subscription
Team Foundation Server CAL			One Team Foundation Server CAL per subscription
Office Professional Plus
Project Professional
Visio Premium
Windows Azure Windows Azure benefits vary by offering
Software for Development and Testing	****	****	*	*
Windows, Windows Server			Requires MSDN Subscription
Microsoft SQL Server			Requires MSDN Subscription
Microsoft Office
Microsoft Dynamics
All other Microsoft servers (SharePoint, Exchange, etc.)
Other Benefits	****	****	*	*
Technical Support Incidents	4	4	2 Requires MSDN Subscription	2
Microsoft E-Learning Collections (per year)	2	2	1 Requires MSDN Subscription	1

To Download the Version of the Visual Studio here are the links.

  Ultimate
 Premium
 Professional
Test Professional


The Platform compatibility and Hardware support/requirement for Visual Studio 2012 

Supported Operating Systems

• Windows 7 (x86 and x64)
• Windows 8 (x86 and x64)
• Windows Server 2008 R2 (x64)
• Windows Server 2012 (x64)

Hardware Requirements

• 1.6 GHz or faster processor
• 1 GB of RAM (1.5 GB if running on a virtual machine)
• 10 GB (NTFS) of available hard disk space
• 5400 RPM hard drive
• DirectX 9-capable video card running at 1024 x 768 or higher display resolution

Supported Architectures

• 32-bit (x86)
• 64-bit (x64)

Hope these information are useful for you and you are going to use the new improved visual studio 2012. For more information you can visit the official Microsoft site that is  Visual Studio 2012

Thanks

Anil Kumar Pandey

Microsoft MVP, Microsoft MCC,DNS MVM

 

CTE (Common Table Expression) and MAXRECURSION

CTE (Common table expression) is a temporary result set that is defined for scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. CTE can be understand as,  similar to a derived table in that it is not stored as an object and lasts only for the duration of the query. A CTE can be self-referencing and we can also refer CTE for multiple times in the same query.

Some basic use of  CTE are;

Ø  For create a recursive query.

Ø  An alternate for view when the general use of a view is not required, in simple words when there is no need to store the definition in metadata.

Ø  CTE will enable grouping by a column from a scalar sub select, or a function that is either not deterministic or has external access.

Ø  CTE can be referred multiple times in the same statement.

CTE improves readability and ease in maintenance of complex queries. A complex query can be divided into multiple simple, queries. These small queries can then be used to generate more complex CTEs till we get final result.
CTEs can be defined in user-defined routines, such as functions, stored procedures, triggers, or views.


For Example

WITH Test (ProductName, CategoryName, UnitPrice) AS
(
   SELECT
      p.ProductName,
      c.CategoryName,
      p.UnitPrice
   FROM Products p
      INNER JOIN Categories c ON
         c.CategoryID = p.CategoryID
   WHERE p.UnitPrice > 10.0
)

SELECT * FROM test

MAXRECURSION :  This option  limit the no of recursion for your CTE, thus will protect the infinite loop.

CTE With MAXRECURSION

WITH Test (ProductName, CategoryName, UnitPrice) AS
(
   SELECT
      p.ProductName,
      c.CategoryName,
      p.UnitPrice
   FROM Products p
      INNER JOIN Categories c ON
         c.CategoryID = p.CategoryID
   WHERE p.UnitPrice > 10.0
)

SELECT *
FROM test OPTION (MAXRECURSION 5)

Hope you like this small articles and surely you are going to make use of the CTE and MAXRECURSION. Please provide your valuable comments on the same.

Thanks

Anil Kumar Pandey

Social Networking from Microsoft

Social Networking from Microsoft

 

Microsoft has also come up with a new website for social networking. Name given to it is www.so.cl

This site has been lunched without any promotion but making the impact on the social networking significantly. The site currently provide option to log in using the FACE BOOK or windows Live ID. This unique site has multiple features from content search sharing to video sharing. I hope this site will become one of the major interests among people.

Here are some of the features this site is providing

* Share Your Search:

                                        With So.cl you can share your search and help others discover what they might be looking for. Fun commentary & discussions usually follow.

* Discover New Interests : 

                                              What are you interested in? At So.cl you can find new interests and connect with like-minded people. The topics you care about are waiting for you.

* Start a Video Party : 

                                            Doing things with others is a fun part of So.cl. Start a video party on any topic and chat with your friends

And much more.

We can GO Social with this just like other sites, learn something new and can share your thoughts and idea’s using this. Here is the URL  www.so.cl. 

 Please share your comments on this. happy Networking. Cheers!!!

Thanks

Anil Kumar Pandey

Microsoft MVP, Microsoft MCC,DNS MVM