Experiencing installation of SQL Server Denali in Windows Server 2008

Saturday, January 1, 2011 |


Before we move further for technical discussion, want to say:

Happy New Year to all reader!!!

May GOD bless you with full of joy, health, wealth and prosperity.

BTW, I have been inactive in blogging since last few months so I am making New Year resolution that I keep writing more and more article and try to help community as much as possible.

Let us now begin journey of new powerful “Denali” in the starting of New Year. Microsoft has released SQL Server Denali CTP1 sometime back only. 

I am very much excited to make grip over it so I have prepared one Virtual PC with Windows Server 2008 SP1 as I had paper license of the same. As soon as I have installed Windows Server 2008 with SP1, I have downloaded Denali and started installing it and greeted with one message which was bit annoying to me. 

Error was “The operating system on this computer doesn’t meet the minimum requirement for SQL Server “Denali” CTP1”



Actually this is CTP1 only and doesn’t install required software by its own so we have to meet basic hardware and software requirement prior to install “Denali”.

I have installed following SP and software to make my system ready for “Denali”.


After installing all above stuff, I was able to successfully install SQL Server “Denali”.

Here is the splash screen of the same:




After looking at the new SSMS of SQL Server “Denali”, I got the feeling of Visual Studio 2010 as I have installed Visual Studio 2010 few weeks back only and getting same feeling due to changed UI of SSMS and blue back color.

 

Happy Coding!!!


At the end of this article, Wish you a great year ahead. Happy New Year 2011 Once again.

Ritesh Shah
http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles but examples and explanations prepared by Ritesh Shah, founder of
http://www.SQLHub.com

2 comments:

Anonymous said...

hi ritesh

Anonymous said...

Hi ritesh !!!
I am Akash. I am facing a problem in sql server 2005. i want to do order by my whole data ,including NULL values, without affecting the current index or location of NULL values.All values must be order by expect NULL values.For example -:
i hava a table,having 2 columns like this

empid SID
2 1
Null 2
1 5
4 NULL
NULL 3
3 NULL

and i want answer like this -:

empid SID
1 5
NULL 2
2 1
3 NULL
NULL 3
4 NULL