Sql Server 2012

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)

My Hands On with –Windows 8 Consumer Preview, Visual Studio 11 and SQL Server 2012

March 8, 2012 .NET, .NET Framework, All, Microsoft, SQL Server, Sql Server 2012, VisualStudio, VS11, Windows, Windows 8 No comments

Recent days there has been some amazing releases by Microsoft such as long awaited Windows 8 Consumer Preview with lots of changes since Windows 8 Developer Preview.

Windows 8™ is latest operating system by Microsoft – is mainly targeting Tablet and touch enabled devices which can hold the windows 8 operating system. Windows 8 consumer preview consists of latest set Windows Apps from Windows Market, so that early adaptors and consumer market can evaluate the features of windows 8.

Visual Studio™ 11 is latest version of Visual Studio family offering from Microsoft – having improvements over previous version and more revamped UI which makes the similar attire of Metro UI. Since it has been termed as Visual Studio 11, there is lots of confusion among the developers – some call it as Visual Studio 2011 and actually it is Visual Studio version 11. Since the release date of final built is unknown Microsoft is stick to call it as Version 11, rather than calling it as Visual Studio 2012.

Visual Studio™ 11 BETA is released on 29th Feb 2012, the very same day Windows 8 Consumer Preview was unveiled. This gives us an indication that later some time in year 2012 Visual Studio 11 Final version will be released to manufacture.

SQL Server™ 2012 RTM(release-to-manufacture) is unveiled on 07th March 2012 – includes cloud centric features of SQL Server.

I give it a try of all of them together on my laptop today. Following are the series of steps I following with my initial review of all of the together.

1. Installed Windows 8 Consumer Preview

2. Installed Visual Studio 11 Ultimate

3. Install SQL Server 2012 – 180 Day Trial

Windows 8 installation went fine and I didn’t have to look for any drivers as the installation itself included most of the drivers for my laptop with core i3 – 4gb.

Attaching some screenshot of working copy.


ie10_w8_consumerpreviewUntitledw8_consumerpreview_n_sql2012_screen1w8_consumerpreview_n_sql2012_screen2w8_consumerpreview_n_vs11w8_consumerpreview_n_vs11_screen1w8_consumerpreview_n_vs11_screen2w8_consumerpreview_n_vs11_screen3w8_consumerpreview_taskmanagerw8_consumerpreview_with_Startdock_W8Menuw8_consumerpreview_with_Startdock_W8Menu2w8_consumerprv_sql2012 evaluation

The point is I love Windows 8 because of it’s smoothness comparing to other windows. It is indeed going to be a very good platform for Tablet and Touch enabled devices.  Metro UI seems innovative because of the simplicity it offers and hats off to Microsoft for bringing it on to windows.

Internet Explorer 10 accompanied with Windows 8 Consumer Preview has a very good support for HTML5 comparing to IE 9.0. It scored over 314 points out of 450 when I run a test over http://www.html5test.com

Visual Studio 11 is fast comparing to Visual Studio 2010 and has built in support for building Metro based applications.

SQL Server 2012 installation was pretty straight forward and faster on windows 8, everything went smoothly on windows 8 and I am evaluating other features of SQL Server 2012. I leave my comments on those on my later posts. 

Need to do few Metro Apps using Visual Studio 11. It would be an awesome experience to work with cutting edge technologies such as Visual Studio 11, Windows 8 and SQL Server 2012.

Thanks Microsoft for Providing evaluation versions of all the software’s needed. I am not giving references to software links in this post, you may can look through my preview posts for download links.

That’s all for now. Happy Coding!

SQL Server 2012 Virtual Launch Event (07th-March-2012) & Microsoft® SQL Server® 2012 – Final Version

March 7, 2012 .NET, All, Microsoft, SQL Server, Sql Server 2012 No comments

Microsoft is releasing the final version of Microsoft® SQL Server® 2012 today. An Microsoft® SQL Server® 2012 Express version quickly appeared in Microsoft Download Center, which depicts the final version release by 07th – March – 2012).

As per Virtual Launch Event site announcement.

On March 7th, 2012 this online event will allow you to immerse yourself in the exciting New World of Data with SQL Server 2012. Engage not only Microsoft product teams, but with our partners and our most ground breaking customers. SQL Server 2012 is part of the broadest Data Platforms in technology today. Discover how it enables mission critical confidence, blazing fast performance, and stunning interactive data visualizations.

Attend the SQL Server 2012 Virtual Launch Event ! 

http://www.sqlserverlaunch.com/ww/Home  (or use this link)

Final Version is 11.0.2100.60

Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

To download SQL Server 2012 Express ( from Microsoft Download Center)

Microsoft® SQL Server® 2012 Express consists of :

1.) LocalDB (MSI installer)

2.) Express (Containing only the database engine)

3.) Express with Tools (with LocalDB) Includes the database engine and SQL Server Management Studio Express)

4.) SQL Server Management Studio Express (Tools only)

5.) Express with Advanced Services (contains the database engine, Express Tools, Reporting Services, and Full Text Search)

Attend SQL Server 2012 Virtual Launch Event ! 

Cool!, there is lots of new stuffs to learn from it.