And finally it’s time to update my post on SSMS 2008 download with the new version, for everyone joy. Well actually we are on SQL2014 now, but as any brand-new Microsoft product, it will take some time until most of us are using it. The cost of updating existing servers is not exactly interesting – the newer versions will be used on mainly on new projects for a while.
And this brings me to the current post. Where do I download the 2012 version of just Management Studio? Actually this has been answered already, and in great detail, in this nice article by Jason Strate: http://www.jasonstrate.com/2013/05/get-just-the-tools-ssms-download/ (notice it’s from 2013).
The key here is to look for the Service Pack 1 product page of SQL 2012 Express. If you searching for the RTM version you will have less luck, as I pointed out on my first post about SSMS 2008r2 download. I strongly recommend the x64 version. But if you need the BIDS/SSIS pieces, you will need the full SQL installer and not these (as pointed out in my previous post).
Enough talk, go to the SQL 2012 SP1 Express page here: http://www.microsoft.com/en-us/download/details.aspx?id=35579, enter your language and look for the files named “SQLManagementStudio_x64_ENU.exe” or “SQLManagementStudio_x86_ENU.exe“.
As with my previous post, below are the direct links too (for english language – actually the only version you should consider):
SQL 2012 SSMS 64bits with SP1 direct link: http://download.microsoft.com/download/5/2/9/529FEF7B-2EFB-439E-A2D1-A1533227CD69/SQLManagementStudio_x64_ENU.exe
SQL 2012 SSMS 32bits with SP1 direct link: http://download.microsoft.com/download/5/2/9/529FEF7B-2EFB-439E-A2D1-A1533227CD69/SQLManagementStudio_x86_ENU.exe
PS 1: while doing research for this post, I came across some great links about SQL lifecycle and support: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/2a9e52dc-4f21-41b1-8640-f0c2476c68d8/most-used-sql-server-version?forum=sqlsetupandupgrade
PS 2: stay away of SQL Express with Advanced Services, unless you really really want a database to run in your local workstation. This version is suited for developers who need a local DB – for remote server administration work you should only use the SSMS version without the local database engine.