Monthly Archives: November 2011

Service Pack requirement for Installing SQL Server 2012

Posted on by
Reply

In yesterday’s blog, I wrote What’s new in Installing SQL Server 2012. One of the requirements for installing SQL Server 2012 is the Service Pack 1 for a Windows 7 and Windows Server 2008 R2 or Service Pack 2 for Windows Vista and Windows Server 2008. Today I wanted to show that the SQL Server 2012 RC0 installation does not move forward if that requirement is not met. Below is the message you will see if you try installing 2012 RC0 without the prerequisites..

In order to continue installation you will have to install the required Service Pack 1 or 2 (depends on your OS).

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

— Bru Medishetty

What’s new in Installing SQL Server 2012

Posted on by
7

You might be aware about SQL Server 2012, the next version of SQL Server. As always, there are a lot of new enhancements features announced in SQL Server 2012. Covering all of the new features and enhancements in SQL Server 2012 in detail might not be accomplished in a single blog. Hence I have decided to break that down to a series of blogs. So in this blog we shall look at some changes new additions / deprecations which are related to installing SQL Server 2012.

The following are the changes in installation of SQL Server 2012. 

  • Changes in the Editions, (BI Edition introduced and Datacenter Edition discontinued), I’ve already written a blog on this, read it here..
  • Business Intelligence Development Studio (BIDS) is gone, making way to SQL Server Data Tools (SSDT)
  • Installation of Data Quality Services (DQS) can be done from the SQL Server setup itself.
  • SQL Server failover clustering supports the nodes being in two different subnets, called as SQL Server multi-subnet clustering.
  • SQL Server editions are no more available for Itanium based systems, so if you don’t see I64 directory in the installation software don’t panic.
  • All Operating Systems would need at least SP1 to be installed (Windows 7 and Windows Server 2008 and R2)
  • All applicable updates can be installed along with the main product, so that your SQL Server product is up to date at the time of installation..

Note: The information in this blog is up to date as of SQL Server 2012 Release Candidate 0 and might change at a later time, visit Microsoft SQL Server official site for more updates.

Updated on 11/20/2011: Read Step by Step Installation of SQL Server 2012 RC 0

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

— Bru Medishetty

Announcing Learn SQL Server Section

Posted on by
Reply

I am happy to announce that a new section is added to this site, named Learn SQL Server. In this section I shall try to cover stuff related to beginner level SQL Server DBA and Developer topics and then soon expand it to intermediate level topics. There are lots of ideas to implement through this section that would help those interested in gaining SQL Server knowledge. But it would take a decent amount of time to be dedicated from my end, and I take it as a pleasure to give back and help the technical community that I come from.

The section is started with a page Learn SQL Server for Beginners that tries to answer the beginner SQL Server question “How to Learn SQL Server?”. The section is written, as if the reader has no prior knowledge of SQL Server and we move on how to setup a SQL Server environment and so on.

I hope it would be beneficial to the targeted users. As always, you can give your feedback as an email to me (bru@learnsqlwithbru.com) or by comments.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

— Bru Medishetty