Friday, January 17, 2014

Moving from SQL Server 2012 to SQL Server 2014

SQL Server 2014 is still in CTP2 and SQL Server 2012 has been around for some time. You could get a SQL Server 2012 Express free of cost but with limited functionality.

You can download SQL Server 2014 CTP2 here:

While on the above make sure you read all the good things you can do with SQL Server 2014.

You may want to know what you can do with SQL Server 2014 CTP1 that you cannot do with SQL Server 2012 Express. If you are looking at just the tasks that you can accomplish, then compare the two images below (the limited number of tasks is that of SQL Server 2012 Express).

SQL Server 2012 Express

SQL Server 2014 CTP1 (enterprise)

Quite a lot of the tasks are new features such as Managing Database Encryption, Deploying to Windows Azure VM, etc.

PowerShell Pro Tools is a Visual Studio Community 2017 extension that you can try free

I see there is at least one extension, PowerShell Pro Tools that you can download. You can find it in the Visual Studio Community 2017...