Showing posts with label SQL2012. Show all posts
Showing posts with label SQL2012. Show all posts

Tuesday, March 20, 2012

You can find BIDS features in SQL Server Data Tools for SQL Server 2012

The development environment for business intelligence (and database) solutions - earlier Business Intelligence Development Studio - is called SQL Server Data Tools in SQL Server 2012.
It can be installed using the SQL Server 2012 installation kit.

It's a Visual Studio 2010 Shell in Integrated Mode. Check out my earlier post regarding VS modes, BIDS, and SSMS.

Monday, March 12, 2012

How to install SQL 2012 on Windows 8

During the weekend, I was playing around with Windows 8 Customer Preview.

First I tried to install SQL Server 2012 RC0 as I had the installer already, but I ran into an issue (missing system CLR types). I decided not to handle this, since SQL Server 2012 RTM is available now. So I tried to install that one instead.

A smaller issue came up again. But Andre Ziegler saved my day with his post in one of the Windows 8 Developer Preview forums.

So, it's better running the script before you start the installation.
You'll have to run cmd as administrator, insert your Windows install disc and type:
dism.exe /online /enable-feature /featurename:NetFX3 /Source:d:\sources\sxs /LimitAccess
Don't forget to check the drive letter of the source and replace it if necessary.

SQL Server 2012 is installed and running now on Windows 8. Thanks Andre :)

Tuesday, November 8, 2011

SQL Server 2012 Licensing

There are a few changes in the licensing options compared to SQL Server 2008 R2. Just to list the main changes:
  • There will be no Datacenter Edition of SQL Server 2012. Customers should buy Enterprise Edition instead.
  • There will be three main editions: Standard Edition, BI Edition, and Enterprise Edition.
  • There will be no processor-based licenses. There will be core-based licenses and Server/CAL licenses.
  • BI Edition will be available only with the Server/CAL licensing option. The Enterprise Edition will be available only with the core-based licensing option. Standard will still be available with both.
  • The price of 4 core licenses of SQL Server 2012 will be around the price of a processor license of 2008.
  • The core licenses will be sold in as 2-core packs. Minimum amount to order is 4 cores (two 2-core packs) per physical processor.
  • The price of a CAL increases with around 25%.
Sources: