I am thinking to join MS Action pack subscription.
Does anyone have a list of the exact software I can use?
I am very interested in MSSQL 2012/2014 as I have a dual quad core machine (8 cores) and wanted to know if I can run MSSQL 2012 or 2014 on it with my Action Pack License.
To get the Action Pack you have to become a Microsoft Partner. Then there are two packs. The developer pack definitely includes SQL Server.
Dig around on the Partner web site and you should find the details.