question

lbahnick avatar image
lbahnick asked

Inexpensive SQL DB Hosting Service?

I'm working on my skills in the Microsoft BI Stack, and I'm looking for an inexpensive SQL database hosting solution that I can "play" in. Services need to include SSAS, SSIS, and SSRS. My hopes are that this environment would eventually morph into something that I could use for proof-of-concept presentations, and made available to remote users. Any suggestions?
sql-server-2008-r2sql-server-2012sql server
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Have you got it up and running yet?
1 Like 1 ·
Thanks for all the great suggestions. I've signed up with AWS and as Grant states above , with a little discipline, you can really control the costs. And, a shout-out to Tim on the AMI's. Microsoft has one that deploys the full BI stack.
0 Likes 0 ·
I do! With only a couple of hours invested, I had my account open, a SQL AMI installed with all BI services, and sample databases installed. Only real task left is to get SSRS platform configured and running. Thanks again for the suggestions.
0 Likes 0 ·
Remember, this site works off of votes. Please mark all helpful posts by clicking on the thumbs up next to those posts. Please mark the solution by clicking on the check box next to it.
0 Likes 0 ·
Tim avatar image
Tim answered
Nothing is an inexpensive as your local workstation. Pick up a copy of SQL 2008R2 Developer or SQL 2012 Developer. I believe both can be obtained for under $50 at any online retailer such as tigerdirect.com, cdw.com, etc. Then you have it local and do what you wish with it. I would highly recommend then downloading the adventureworks databases to play with.
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Amazon has some AMI's that look promising. [Amazon]( https://aws.amazon.com/amis/optimized-sql-server-2008-r2-sp1-q1)
1 Like 1 ·
Thanks Tim. My hopes were that this environment would eventually morph into something that I could use for proof-of-concept presentations, and made available to remote users (probably should have included that in my original question. Not sure doing that on my local w/s would be the best solution.
0 Likes 0 ·
+1 The 180 day free trial is a great way to get rolling, too.
0 Likes 0 ·
TimothyAWiseman avatar image
TimothyAWiseman answered
As the other Tim says, the Developer eddition is well worth the money if you're goal is to learn SQL or to make a demonstration that will eventually move onto Enterprise Edition. If you are planning to eventually move the project onto Standard Edition you should note that there are some features that are enabled in the Developer Eddition that are disabled in the Standard Edition. If you are really trying to focus on "Inexpensive", look at the Express Edition. It is free and even has components that can be redistributed so you can build software packages on top of it and include the database with the package you distribute. And if you really want it hosted, look at [Windows Azure SQL database][1]. It has some differences from traditional SQL Server, but it is designed to be hosted remotely. [1]: http://msdn.microsoft.com/en-us/library/windowsazure/ee336241.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
In addition to the other suggestions, all great, you might want to look at simply using virtual machines. Microsoft has some available through Azure. Amazon has them through AWS. Neither is exactly free, but you only pay for what you use which means with some pretty disciplined access on your end you can keep the costs down.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.