Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Best solution to test as a trial Expand / Collapse
Author
Message
Posted Thursday, February 13, 2014 4:44 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 26, 2014 4:29 AM
Points: 64, Visits: 104
I've got SQL Server 2008R2 Developer edition. I am ultimately looking for a cloud based database solution with full front end and BI options.

I absolutely won't give my card details to test Azure as a trial so is there any facility to do this within 2008R2 Developer? Are there any other alternatives to do this through SQL Server 2012 upwards. I am using XP but could use another computer with Win 7 if absolutely necessary.
Post #1541112
Posted Thursday, February 13, 2014 7:08 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 6:43 PM
Points: 36,752, Visits: 31,208
meridius10 (2/13/2014)
I've got SQL Server 2008R2 Developer edition. I am ultimately looking for a cloud based database solution with full front end and BI options.

I absolutely won't give my card details to test Azure as a trial so is there any facility to do this within 2008R2 Developer? Are there any other alternatives to do this through SQL Server 2012 upwards. I am using XP but could use another computer with Win 7 if absolutely necessary.


What's the question here? Are you just asking for how to generate a wad of test data that looks like "card details"?


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1541175
Posted Thursday, February 13, 2014 7:17 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 26, 2014 4:29 AM
Points: 64, Visits: 104
Basically I'd like to test a cloud based database but don't want to have to hand over my credit card details in order to be able to do so.
Post #1541181
Posted Saturday, February 15, 2014 9:03 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 25, 2014 4:28 PM
Points: 360, Visits: 2,255
I like prepaid credit cards for this sort of thing.
Post #1541860
Posted Saturday, February 15, 2014 12:30 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 26, 2014 4:29 AM
Points: 64, Visits: 104
Microsoft are just making it difficult for us. It should be try first, pay later.
Post #1541878
Posted Sunday, February 16, 2014 8:14 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 6:43 PM
Points: 36,752, Visits: 31,208
meridius10 (2/13/2014)
Basically I'd like to test a cloud based database but don't want to have to hand over my credit card details in order to be able to do so.


Ah... got it. I agree with Patrick. If you really, really want to try it, get a cheap pre-paid credit card from the gas station. They can only hit that so much and it can't be overdrawn if you get the right type.



--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1541906
Posted Sunday, February 16, 2014 9:20 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 26, 2014 4:29 AM
Points: 64, Visits: 104
That's one idea.

Doesn't SQL Server 2012 have an evaluation edition where I could at least test a potential cloud based SQL Server back end Visual Studio front end?
Post #1541909
Posted Monday, February 17, 2014 3:56 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:28 AM
Points: 2,857, Visits: 3,180
How do you plan to access your database engine in the cloud?

If you go down the IaaS route then you install SQL on a VM and everything is just the same as running in your own data centre. This applies to just about any IaaS vendor. However, each vendor has its own set of pre-defined server configurations so the main thing you need to review is how your workload fits in to their offering.

If you use the PaaS route then there may be some limitations on the features you can use. For example Replication and AlwaysOn are not often supported. Different PaaS vendors offer different capabilities, so your first step should be to match your organisation's needs against the various PaaS offerings.

Both IaaS and PaaS are mature offerings. You should have no more concerns about using these than you would have about any move to a new data centre. If your organisation is seriously considering going to the cloud then talk to the potential vendors as there is often pre-sales support (just as there would be if you were thinking about a different data centre).

My employer moved all their production systems to AWS IaaS in 2012, and currently serve over 4m page impressions per day out of AWS. The greatest business gain for us is flexibility - no matter what we want to do we only have to consider the marginal costs which means we can get new stuff to the market faster. We also saved about 25% of our hosting costs and have a more stable service but for us the flexibility is what we mostly talk about.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1542027
Posted Monday, February 17, 2014 3:22 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 26, 2014 4:29 AM
Points: 64, Visits: 104
Thanks a lot for all that information. There's so much more to think about than I originally thought of as well as AWS as an option.

On the Microsoft side, if I wanted to set up an archaeological database which is cloud based and could be accessed by multiple users (all data is stored in the cloud) I wonder if I would be better off with SQL Server 2012/14 or Azure. Then there is also the question of PaaS or IaaS. I'm not sure how Visual Studio works with 2012/14 or Azure.
Post #1542300
Posted Tuesday, February 18, 2014 4:16 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:28 AM
Points: 2,857, Visits: 3,180
Visual Studio is quite happy with SQL 2012 / 2014 and with Azure.

Your choice of IaaS or PaaS is likely to be influenced by your current infrastructure and plans. If you are starting up, then PaaS gives you less work to do than IaaS. If you have a lot already set up, then IaaS may be easier to integrate into your current working practices.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1542462
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse