SQL Server

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.

SQL Server 2012 RC0(Release Candidate 0) –Released

November 19, 2011 All, Code Name "Denali", Futures, General, Microsoft, SQL Server No comments

I just received the news that SQL Server 2012 (a.k.a Code Name =‘Denali’)  has become Release Candidate 0(RC0) and available for download

Visit SQL Server 2012 Home

Download Microsoft® SQL Server® 2012 Release Candidate 0 (RC0) 

Download Microsoft® SQL Server® 2012 Express RC0

Microsoft® SQL Server® 2008 R2 SP1– Final – Released

July 13, 2011 .NET, All, General, Microsoft, SQL Server, SQL Server 2008, Updates No comments

Microsoft has released the SQL Server 2008 R2 – Service Pack 1 (Version# 10.50.2500.0, Released: 7/11/2011)

You can right away download the files from here [Download Link]

Download Microsoft® SQL Server® 2008 R2 Service Pack 1

Download Microsoft® SQL Server® 2008 R2 SP1 – Express Edition

Download Microsoft® SQL Server® 2008 R2 SP1 Feature Pack

SQL Server Code-Named "Denali"–CTP3(Community Technology Preview 3) is now available

July 13, 2011 .NET, All, Code Name "Denali", General, Microsoft, SQL Server No comments

Microsoft has released CTP3 of SQL Server Code-Named "Denali". You can download the files from

Download SQL Server "Denali" CTP3 

(You will Microsoft File Transfer Manager)

Express Edition of the same is available from below link

Download SQL Server "Denali" Express CTP3

Read the below blog as well for more information

http://www.jamesserra.com/archive/2011/07/sql-server-denali-ctp3-now-available/

sqlncli_x64.msi cannot be found while installing SQL Server 2005 64bit on Windows Server 2008 R2

February 27, 2011 All, General, KnowledgeBase, SQL Server, SQL Server 2005, Troubleshooting, Windows, Windows 2008 R2 4 comments

Recently while installing SQL Server 2005 64bit on a Windows Server 2008 R2 Enterprise 64bit an error message displays that “An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package ‘sqlncli_x64.msi’.” as shown below.

After that, the Microsoft SQL Server 2005 Setup Progress will display some errors with a status “Setup Failed. Refer to the Setup log for details”.

 

When trying to install the Microsoft SQL Server Native Client Setup by hand it displays a similar error message that the file ‘sqlcli_x64.msi’ cannot be found.  It’s unable to locate the sqlcli_x64.msi ( 64 bit version of SQL Server Native client). It’s puzzling, I am trying to install with 64 Bit version of SQL Server 2005 and it’s unable to locate the sqlcli_x64.msi, crazy thing is file is already available in installation folder and it’s showing me that error strange???.

After so much of trial I found solution for this problem is that someone started the installation with a wrong edition (32 vs. 64) edition and left the components there.

Go to Add/Remove Programs and remove the existing SQL 2005 components, and then reinstall.

Voila!!! It works fine.. It’s puzzling why the error comes up, but it is resolved after re-installation.