You need to Uninstall SQL Server 2014 CTP1 to install SQL Server 2014 RTM

SQL server 2014 RTM will be available from April 1, 2014. It's time to take out SQL Server CTP1. You really need to take out CTP1 if you have installed it as these are the general restrictions:

• Upgrading from SQL Server 2014 CTP 1 to SQL Server 2014 RTM is NOT supported.
• Installing SQL Server 2014 CTP 1 side-by-side with SQL Server 2014 RTM is NOT supported.
• Attaching or restoring a SQL Server 2014 CTP 1 database to SQL Server 2014 RTM is NOT supported.

However upgrading from CTP2 is supported but degrading to CTP2 from RTM is not.

According to the same source the following upgrades are supported as seen in the referenced link:

• Attach a SQL Server 2014 CTP 2 database to an instance of SQL Server 2014 RTM.

• Restore a database backup taken on SQL Server 2014 CTP 2 to an instance of SQL Server 2014 RTM.
• In-place upgrade to SQL Server 2014 RTM.
• Rolling upgrade to SQL Server 2014 RTM. You are required to switch to manual failover mode before initiating the rolling upgrade. Please refer to Upgrade and Update of Availability Group Servers with Minimal Downtime and Data Loss for details.
• Data collected by Transaction Performance Collection Sets installed in SQL Server 2014 CTP 2 cannot be viewed through SQL Server Management Studio in SQL Server 2014 RTM, and vice versa. Use SQL Server Management Studio in SQL Server 2014 CTP 2 to view data collected by the Collection Set installed in SQL Server 2014 CTP 2, and use SQL Server Management Studio in SQL Server 2014 RTM to view data collected by the Collection Set installed in SQL Server 2014 RTM.

Watch for a detailed post on uninstalling SQL Server 2014 CTP1 here:
http://hodentekMSSS.blogspot.com

SQL Server 2014 goes RTM

SQL Server 2014 RTM, billed as 'Microsoft Cloud First Platform' will be RTM on April 1, 2014
The main feature is the in-memory OLTP processing which will turbo- charge transaction processing making it as much as 30 times faster. In order to use this feature you need memroy-optimized databases and tables declared as memory optimized. These memory-optimized tables are stored in file groups.

In-memory transaction processing appears to be not new, but peer pressure from products already in the market makes it important to highlight this feature in this offering as it is fully integrated with the present version.

The other prominent feature is the enhancements to Microsoft Azure in particular the enhancements leading to integration between on premises and cloud based environments. SQL Server 2014 instances can be backed up to Windows Azure Storage which can then be deployed as Windows Azure VM by just invoking a wizard. This  can then be designated as a high availability node for SQL Server 2014.

Of course to reap all this benefit you need to purchase SQL Server 2014. I know people using SQL Server 2000 even now, I assume it is still supported.

For more information read these articles:
http://www.infoworld.com/t/dbms/sql-server-2014-supercharged-in-memory-tables-azure-connectivity-238639?source=IFWNLE_nlt_daily_pm_2014-03-18

http://www.zdnet.com/microsofts-sql-server-2014-crowns-redmonds-data-platform-7000027444/

SSDT BI templates for SQL Server 2012 CTP2

You will get SQL Server 2014 CTP2 Data Tools BI Project templates if you install Microsoft SQL Server 2014 Data Tools BI for Microsoft Visual Studio 2012, CTP2. Note that this does not work with Microsoft SQL Server 2012. It is supported only on x64 architecture of Windows Servers 2208 R2 and 2012 but on both X32 and X64 for Windows 7 and Windows 8.

Download link here
http://www.microsoft.com/en-us/download/details.aspx?id=40736

This installs the Microsoft SQL Server 2014 CTP2 Data Tools Business Intelligence project templates for Analysis Services, Integration Services, and Reporting Services.

Make sure you have these on the computer as prerequisites:
•Microsoft .NET Framework 4.5
•Microsoft Visual Studio 2012 Shell (Isolated) Redistributable Package
•Microsoft Visual Studio 2012 Shell (Integrated) Redistributable Package
•Microsoft Visual Studio Tools for Applications 2012
•Microsoft Report Viewer 2012 Runtime
For more support information follow this link here.

Come get it, SQL Server 2014 CTP2 is out

It is available for immediate download.

Don't click on the start to get evaluation! It won't take you to SQL Server 2014 CTP2.

Access the main link here:
http://www.microsoft.com/en-us/sqlserver/sql-server-2014.aspx

New capabilities :
Promises new in-memory capabilities
Promises new cloud capabilities

Here is a cutout from product documentation.

Want to check it out, download from here:
http://www.microsoft.com/en-us/download/details.aspx?id=39269
The installation should follow the same steps as in installing SQL Server 2014 CTP1.

Get full screen shots here.
http://hodentekmsss.blogspot.com/2013/09/installing-sql-server-2014-ctp1-on.html

Mahalo,
Jay