Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012–with Analysis Services, Reporting Services and Integration Services projects support

April 12, 2013 .NET, Business Intelligence(BIDS), KnowledgeBase, Microsoft, SQL Scripts, SQL Server, Sql Server 2012, SQL Server Analysis Services, SQL Server Data Tools, SQL Server Integration Services, SQL Server Reporting Services, Updates, VisualStudio, VS2012 No comments

Microsoft has released SQL Server Data Tools and Business Intelligence for Visual Studio 2012 with integrated support for Visual Studio 2012.  When Microsoft released SQL Server 2012,  Data Tools and Business intelligence released with bundled support for Visual Studio 2010 IDE, and this release is a good news for Visual studio 2012 developers. 

Now with this release developers will be able to Visual Studio 2012 for SQL Server Database Business Intelligence related projects using Analysis Services, Reporting Services and Integration Services.

[Quoting from MSDN]

SQL Server Data Tools – Business Intelligence for Visual Studio 2012 includes business intelligence project authoring tools and project templates for SQL Server Analysis Services, Reporting Services, and Integration Services integrated into a Visual Studio 2012 shell.

You can install SQL Server Data Tools – Business Intelligence for Visual Studio 2012 as a standalone business intelligence authoring environment or side-by-side with an existing SQL Server Data Tools installed with SQL Server 2012.

SQL Server Data Tools – Business Intelligence for Visual Studio 2012 uses SQL Server 2012 Setup to install the SQL Server Data Tools – Business Intelligence environment as a shared feature. If you are used to SQL Server Setup, this process will seem familiar to you; however, if you have never run SQL Server Setup to install additional SQL Server features before, this may seem a little confusing.

[Ref: MSDNhttp://msdn.microsoft.com/en-us/library/jj856966.aspx]

Download: Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012

SSDTBI_VS2012_x86_ENU.exe – 784MB (Version – 11.0.3360.12)

Visual Studio 2012 Update 2(2012.2)–Final Released

April 4, 2013 .NET, .NET Framework, .NET Framework 4.5, ASP.NET, ASP.NET 4.5, KnowledgeBase, Microsoft, SignalR, Updates, VisualStudio, VS2012, Web API, Windows, Windows 7, Windows 8, Windows 8 apps development, Windows Phone, Windows Phone 7.8, Windows Phone 8, Windows Phone Development, Windows Phone Store, Windows Store, Windows Store Development No comments

Microsoft has released the final version of the Visual Studio 2012 – Update 2. You can get more details on release from Somasekhar’s blog: Visual Studio 2012 Update 2 Now Available. Somasekhar is VP of Developer Division at Microsoft. For information about the latest update, see Visual Studio Updates.


Download Visual Studio 2012 Update 2

other products updates are also available:

  • Microsoft Visual Studio Team Foundation Server 2012
  • Microsoft Visual Studio Team Foundation Server Express 2012
  • IntelliTrace Collector for Visual Studio 2012
  • Remote Tools for Visual Studio 2012
  • Agents for Microsoft Visual Studio 2012
  • Agents for Microsoft Visual Studio 2012 Language Pack
  • Courtesy: Microsoft Download Center, MSDN

    TypeScript for Visual Studio 2012–v0.8.3.1

    March 30, 2013 .NET, Community, Frameworks, JavaScript, JavaScript, Javascript Development, Microsoft, MSDN, TypeScript, Updates, VisualStudio, VS2012, Web Development No comments

    Microsoft has released an Incremental update to TypeScript for Visual Studio 2012 – the version, which is the first update to the v0.8.3 released in Feb 2013.

    You can download the latest bits from here:

    Download TypeScript for Visual Studio 2012 – v0.8.3.1

    Introduction to The One ASP.NET Platform/Ecosystem

    December 25, 2012 .NET, .NET Framework, .NET Framework 4.5, ADO.NET, All, ASP.NET, ASP.NET 4.5, ASP.NET AJAX, ASP.NET MVC, ASP.NET MVP, C#.NET, Community, HTML, HTML5, IIS, JavaScript, JavaScript, jQuery, JQuery Mobile, KnowledgeBase, LINQ, Microsoft, MSDN, SignalR, Updates, VB.NET, VisualStudio, VS2012, WCF, Web, Web API No comments


    ASP.NET has travelled a long way through evolutions. Earlier when ASP.NET 1.0 was released as part of .NET Framework 1.0 in Jan 2002, there was only ASP.NET – a framework for building dynamic web applications and it provided lots of flexibility web developers in building robust, dynamic web applications.  ASP.NET was and is the successor to Microsoft’s Active Server Pages (ASP) technology.

    ASP.NET is built on the Common Language Runtime (CLR), allowing programmers to write ASP.NET code using any supported .NET language. The ASP.NET SOAP extension framework allows ASP.NET components to process SOAP messages.

    From that, today we reached ASP.NET 4.5 and platform/web framework has changed a lot through the 10 years of journey.

    Before going further lets go through a quick summery of additions in each releases:

    ASP.NET 1.0 (January 16, 2002)

    • Object-oriented Web application development supporting inheritance, polymorphism and other standard OOP features
    • Support for generic HTML controls and ASP.NET dynamic web controls
    • Event based programming
    • The developer can make use of DLL class libraries and other features of the Web server to build more robust applications that do more than simply rendering HTML.
    • Integrated development support using Visual Studio .Net 2002

    ASP.NET 1.1 (April 24, 2003)

    • With ASP.NET 1.1 – an update to .NET framework 1.0 called as .Net framework 1.1 – we received support for Mobile Web Controls, Automatic input validation
    • Integrated development support using Visual Studio .Net 2003

    ASP.NET 2.0 (November 7, 2005)

    ASP.NET 2.0 introduced major updates to ASP.NET framework with introduction of Master pages and new data controls.

    The interesting features included in this release were:

    • Integrated development support using Visual Studio 2005
    • New data controls (GridView, FormView, DetailsView)
    • New technique for declarative data access (SqlDataSource, ObjectDataSource, XmlDataSource controls)
    • Navigation controls
    • Master pages
    • Login controls
    • Themes
    • Skins
    • Web parts
    • Personalization services
    • Full pre-compilation
    • New localization technique
    • Support for 64-bit processors
    • Provider class model
    • Web Sites projects are introduced. An alternative to Web Application project model in earlier versions.
    • ASP.NET AJAX has been introduced as a separate installer. Included ScriptManager, UpdatePanel etc.

    ASP.NET 3.5 (November 19, 2007)

    This was an incremental update to ASP.NET 2.0 and .NET Framework 2.0. Base level the Runtime was depending on .NET Framework 2.0 and set of additional runtime extension components been introduced in this release.

    The interesting features included in this release were:

    • Integrated development support using Visual Studio 2008
    • New data controls (ListView, DataPager, LinqDataSource)
    • ASP.NET AJAX included as part of the framework
    • Support for HTTP pipelining and syndication feeds.
    • WCF support for RSS, JSON, POX and Partial Trust
    • All the .NET Framework 3.5 changes, like LINQ etc.

    With .NET Framework 3.5 Service Pack 1, some more features been introduced

    • Integrated development support using Visual Studio 2008 – Service Pack 1
    • Incorporation of ASP.NET Dynamic Data
    • Entity Framework support
    • Support for controlling browser history in an ASP.NET AJAX application
    • Ability to combine multiple JavaScript files into one file for more efficient downloading
    • New namespaces System.Web.Abstractions and System.Web.Routing
    • JQuery is included as part of the template.
    • ASP.NET MVC is born

    Now ASP.NET framework is spitted in to three based on the purpose

    ASP.NET Core Services – all the major ASP.NET runtime components has been built in to this and will act as a base layer for all other ASP.NET components such as Web Forms, MVC, Dynamic Data etc.

    Now we have three Presentation Frameworks/Components that utilizes the ASP.NET Core runtime components

    1. ASP.NET Web Forms – based on traditional ASP.NET web application model – dynamic *.aspx pages with code behind file.
    2. ASP.NET MVC – based on MVC model – *.aspx pages for View, no code behind file. Simply depended on Controller and model.
    3. ASP.NET Dynamic data – the quick and easy – rapid application development model with help of LINQ and Entity Framework. ASP.NET Dynamic Data helps you quickly build a fully customizable, data-driven application without writing code. Dynamic Data provides a rich scaffolding framework that is easily extensible by using the traditional ASP.NET programming model.

    ASP.NET 4.0 (April 12, 2010)

    The .NET Framework version 4 includes enhancements for ASP.NET 4 in targeted areas. Visual Studio 2010 and Microsoft Visual Web Developer Express also include enhancements and new features for improved Web development.

    The interesting features included in this release were:

    • Integrated development support using Visual Studio 2010
    • jQuery Included with Web Forms and MVC
    • Content Delivery Network Support
    • Setting Meta Tags with the Page.MetaKeywords and Page.MetaDescription Properties
    • ASP.NET MVC 3.0 with Web Pages and razor support
    • IISExpress Support through Service Pack1
    • and more… You can read about it in detail on the MSDN page What’s New in ASP.NET 4 and Visual Web Developer


    ASP.NET 4.5 (August 15, 2012)

    This was a long awaited release since ASP.NET 4.0, which includes the new improved support for Web Pages, MVC and new Web API support. With the release of .NET Framework 4.5 and Visual Studio 2012, decided to go away from Service Packs and release incremental updates whenever available.

    The interesting features included in this release were:

    • Async support – HttpRequest, Response, HTTP Modules and Handlers are capable of handling Async request and responses.
    • AntiXSS library is integrated
    • WebSockets protocol support
    • Lazy request validation
    • ASP.NET Web Forms – Model binding similar to ASP.NET MVC
    • HTML5 support
    • ASP.NET MVC 4, Web Pages 2.0, Web API, ASP.NET MVC 4 – Mobile Web Templates using jQuery Mobile
    • and more… You can read about it in detail on the MSDN page What’s New in ASP.NET 4.5 and Visual Web Developer

    ASP.NET and Web Tools 2012.2 update

    This .2 update adds a number of new templates and features including:

    • Enhancements to Web Publishing
    • New Web API functionality
    • New templates for Facebook Application and Single Page Application
    • Real-time communication via ASP.NET SignalR
    • Extensionless Web Forms via ASP.NET Friendly URLs
    • Support for the new Windows Azure Authentication
    • and more… You can read about it in detail on the MSDN page What’s New in ASP.NET and Web Tools 2012.2 Update


    SignalR is a new member of the ASP.NET family that facilitates adding real-time functionality to web applications using WebSockets and other down-level transports. SignalR is a self-contained library installed via NuGet that is targeting a 1.0 RTW as part of the Fall Update. This will include item templates for adding SignalR connections and hubs to an ASP.NET application as well as a full project template that integrates with ASP.NET MVC and ASP.NET Web API.

    [ Quoted from http://aspnet.codeplex.com  ]


    Now the ASP.NET ecosystem would look as in the image, with 2012.2 release: Single platform – multiple, extensible solutions

    All the parts of ASP.NET, all the subsystems are all part of the larger ASP.NET community 

    [Image courtesy Scott Hanselman’s blog]

    Scott Hanselman of Microsoft Quotes:

    The idea behind One ASP.NET is that we want folks to be able to make apps that have real-time components with SignalR, clean, simple APIs with Web API, all in one pages with KnockoutJS, pages with MVC, Web Forms or Web Pages, as well as existing ASP.NET systems like OData, ASMX, and more.

    We want open source projects like JSON.NET, KnockoutJS, SignalR, Backbone, MongoDB, Scaffolding, NHIbernate, Ninject (and the list goes on) to all play in the same ASP.NET LEGO sandbox.

    We’ll put all these subcomponents on NuGet and they’ll live alongside community components and you’ll be able to build ASP.NET applications starting from some base template and add just the pieces you want. We are getting there. We want folks to use the parts they want, and swap out the parts they don’t. Everything should work together.

    ScottGu Quotes
    The new runtime functionality is delivered to ASP.NET via additional NuGet packages. This means that installing this update does not make any changes to the existing ASP.NET binaries, and thus does not cause any compatibility issues with existing projects. New projects will contain the new functionality and existing projects can be updated with the new NuGet packages.

    You can further read about it through Scott Hanselman’s article and ScottGu’s blog 


    Now with ASP.NET 4.5 and Updates we reached a place where we have a vast variety of technologies to choose from, to develop rich, dynamic web applications for Desktop browsers as well as for mobile browsers.

    ASP.NET Ecosystem is growing and is moving in the right pace with the release to open source development of most of the components through http://aspnet.codeplex.com/ 

    It is challenging and interesting for ASP.NET developers to be able to develop using such cutting edge technologies.

    Information Sources & Courtesy: Wikipedia, MSDN and Microsoft Developer blogs

    WCF Data Services 5.2 RTM Tools for Visual Studio 2010/2012

    December 18, 2012 All, Community, DataServices, MSDN, Tools, Updates, VisualStudio, VS2010, VS2012, WCF, WCF Data Services No comments

    Microsoft has released an update to WCF Data Services tools – v5.2, this will update the NuGet packages referenced by the WCF Data Services item templates to 5.2.0. This installer also fixes a bug where generating a service reference against a large model would cause Visual Studio to crash.

    This release contains the following noteworthy bug fixes:

    • Fixes an issue where code gen for exceedingly large models would cause VS to crash
    • Provides a better error message when the service model exposes enum properties
    • Fixes an issue where IgnoreMissingProperties did not work properly with the new JSON format
    • Fixes an issue where an Atom response is unable to be read if the client is set to use the new JSON format

    URI Parser
    In this release ODataLib now provides a way to parse filter and orderby expressions into a metadata-bound abstract syntax tree (AST). This functionality is typically intended to be consumed by higher level libraries such as WCF Data Services and Web API.

    • The WCF Data Services 5.2 installer will update the “Add Service Reference” tooling integration in Visual Studio if it’s already installed, hence it will generate code based on WCF Data Services 5.2.
    • The KB2502836 update for Visual Studio 2010 and Visual Web Developer (that gets delivered as a part of this update for Silverlight 5 development) reverts the “Add Service Reference” behaviour to generate code based on the assemblies that shipped in the .NET Framework 4. Running the WCF Data Services Installer and repairing the installation fixes this problem.

    [Source: Microsoft Download Center]

    DOWNLOAD from Microsoft Download Center

    Other Releases: WCF Data Services 5.0 for OData V3

    An early update on Windows Phone 7.8 release–coming in Q1-2013

    November 29, 2012 .NET, All, Community, KnowledgeBase, Microsoft, Mobile-Development, MSDN, Updates, Windows, Windows Phone, Windows Phone "Mango", Windows Phone "Tango", Windows Phone 7, Windows Phone 7.0, Windows Phone 7.5, Windows Phone 7.8, Windows Phone Development, Windows Phone SDK No comments

    Yesterday Microsoft Windows Phone Team announced the availability of Windows Phone 7.8 to existing Windows Phone 7.x family of devices by early 2013.

    Some of the interesting features announced are:

    • New Customizable start screen with resizable Live Tiles.
    • It doubles the number of theme and accent colors—to 20—so you can make your phone even more personal.
    • There are also new lock screen features: the option to automatically display the Bing Picture of the Day plus the ‘A1B2C3’ PIN/password challenge to prevent accidental device wipes on phones connected to Exchange accounts.

    You want to read more about this announcement visit: Windows Phone Team blog