Solved

Best access to MS SQL Server 2012 for training

Posted on 2014-09-23
8
334 Views
Last Modified: 2016-03-27
I'm doing some training to upgrade my skills in the Microsoft SQL Server stack. I want to learn SSIS, SSAS and SSRS. I need advice on the best (lowest cost) way to get access to MS SQL Server 2012 for this purpose. Is SQL Server express an  option? Are cloud based services available e.g. Amazon AWS? Do I need to buy a copy for my home PC? Thanks in advance for any help given.
0
Comment
Question by:FyllSee
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40340664
the best option will be to obtain your local copy of the SQL server instead of the cloud based solutions, and since the SQL Server Express with Advanced Services is free to use and includes the following
Experience the full feature set of SQL Server Express. This package contains the database engine, Express Tools, Reporting Services, Full Text Search, management tools, and all the components of SQL Server Express.

i think that the Express will be good basis...
0
 
LVL 25

Accepted Solution

by:
chaau earned 400 total points
ID: 40340665
I think SQL Server Developer edition is the best. It costs only $59.95 but gives you access to all features of SQL Server, inluding SSIS, SSAS and SSRS. The express editions lucks these features.
0
 

Author Comment

by:FyllSee
ID: 40340703
Thanks for that. Does that mean I would need a Server 2008R2 or Server 2012 box to run the developer edition on or can I install and run on a Win 7 Pro workstation?
0
How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

 
LVL 25

Expert Comment

by:chaau
ID: 40340729
I am pretty sure it will run on Windows 7, but please check the official website before buying
0
 

Author Comment

by:FyllSee
ID: 40340954
Cool - SQL Server 2012 runs on Win 7 Pro SP1 according to the official MS information. One final point: Do I need a MSDN subscription or anything to run SQL Server 2012 Developer edition?
0
 
LVL 15

Assisted Solution

by:Haris Djulic
Haris Djulic earned 100 total points
ID: 40340988
You will just need free microsoft account ( skype, etc..) to access download link...
0
 

Author Closing Comment

by:FyllSee
ID: 40341008
Very prompt response - thanks EE
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 41524274
All - Based on this question and others I just kicked out an article called SQL Server Training.  Please let me know if you like it, and if yes click the 'Good Article' button at the bottom.  Thanks.  -Jim
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Can we attach PDF to table 2 46
Search Text in Views 2 28
relocating SQL 2000 18 33
STUFF function - proper use to update column? 6 16
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question