Alpha Video Training
Results 1 to 9 of 9

Thread: Cloud computing wit Microsoft Azure platform

  1. #1
    Member koga101's Avatar
    Real Name
    Chris O'Brien
    Join Date
    Mar 2009
    Location
    Los Angeles, CA
    Posts
    105

    Talking Cloud computing wit Microsoft Azure platform

    I have seen several posts discussing Amazon cloud computing for MySQL. However, does anyone have experience With SQL Azure? Since Alpha runs on Windows and my backend choice is SQL server I thought it best to go to the source since no middleman thus best prices. I had a high level conversation with a MS rep today. And they are insanely low including for FILESTREAM BLOB directories. This model minimizes the risks to launching a new app. And they support MySQL

    My concern would be if the AlphaDAO will work with SQL Azure since it is not exactly the same as SQL Server.

    I also like the idea of MS becoming more aware of Alpha, it is a good marriage that can reduce costs for everyone when (according to Alpha employee posting) Alpha cloud price structure is available.

    I am also going to look into what can be done now through Azure platform when multiple cores are needed and appropriate number of WAS licenses are purchased through Alpha.

    Please share...I dont want to be the only Azure Alpha developer - Early adopters tend to pay for their impulses in blood

  2. #2
    "Certified" Alphaholic mmaisterrena's Avatar
    Real Name
    Mauricio Maisterrena
    Join Date
    Nov 2006
    Location
    Torreon, Mexico
    Posts
    1,435

    Default Re: Cloud computing wit Microsoft Azure platform

    Read this from the release notes

    Connecting to SQL Server Azure - You can build applications in Alpha Five that use Microsoft SQL Azure as your database.

    This release note describes how to define your AlphaDAO connection string to connect to your Azure database. You must previously have set up an Azure account.

    First, you will need to know the server address and user id to use in the AlphaDAO connection string dialog.

    The easiest way to find this information it to navigate to this screen in the Microsoft SQL Azure Administration page, then click the 'Connection Strings' button shown below.

    http://downloads.alphasoftware.com/A...easenotes.html
    Cheers
    Mauricio


  3. #3
    Member koga101's Avatar
    Real Name
    Chris O'Brien
    Join Date
    Mar 2009
    Location
    Los Angeles, CA
    Posts
    105

    Default Re: Cloud computing wit Microsoft Azure platform

    Gracias por todo!

  4. #4
    "Certified" Alphaholic
    Real Name
    eric
    Join Date
    Mar 2009
    Location
    Amsterdam
    Posts
    1,284

    Smile Re: Cloud computing wit Microsoft Azure platform

    Quiere decir un montón de trabajo desafiante con la ambición de verdad!

  5. #5
    "Certified" Alphaholic mmaisterrena's Avatar
    Real Name
    Mauricio Maisterrena
    Join Date
    Nov 2006
    Location
    Torreon, Mexico
    Posts
    1,435

    Default Re: Cloud computing wit Microsoft Azure platform

    jaja Definitivamente el primero que se anime a esto va a tener que sudar sangre.
    Cheers
    Mauricio


  6. #6
    Member koga101's Avatar
    Real Name
    Chris O'Brien
    Join Date
    Mar 2009
    Location
    Los Angeles, CA
    Posts
    105

    Default Re: Cloud computing wit Microsoft Azure platform

    Ya se, es el razon que escribo todos aqui, a guardar el sangre de nuestros companeros lol

    Anyway, it is good to document this here. I spent an hour on the phone with a MS Azure engineer. All Azure is, is a database engine. And, there cold be problems with Alpha- as a complete application. For example, there could be issues in uploading and accessing BLOB files (which sounded awesome at first because memory is soooo cheap) in the BLOB folder due to MS security rules (AppFabric is its own entity- Well maybe Steve Wood could figure it out). SQL reporter cannot be used. And the top thing on my list is table auditing which is not possible (I could not find third party vendors that support Azure) that can monitor insert, delete and updates to database records. The Azure rep said MS would have these features some time in the future. One nice thing is that if you upload a SQL Server DB you can always get it back into SQL Server and you can manage Azure with SSMS.

    However, if all you need is SQL DB that will cost you $10/month to host (Mauricio, your project would do well here), and very inexpensive to scale then this is the way to go and you can save your clients a ton of money over the long run. Again, you can use SSMS without learning yet another development/management environment. I learned about why Alpha cant be used in the cloud, it is simply an unsupported application....but I put out a shout for Alpha anyway. I started looking at Amazon which offers SQL Server and a lot more platforms but by then my eyes were red and could not handle reading another White Paper.

    Oh last thing and very important. The downside to cloud computing is the database is far away from WAS, so this can slow things down. And of course the Azure rep could not promise performance.

    Gnight.

  7. #7
    Member koga101's Avatar
    Real Name
    Chris O'Brien
    Join Date
    Mar 2009
    Location
    Los Angeles, CA
    Posts
    105

    Default Re: Cloud computing wit Microsoft Azure platform

    I did not calculate the costs correctly. This link provides examples of how to estimate costs when going to the cloud versus an in-house system

    http://www.uptimesoftware.com/uptime...ing-expensive/

    Here is a comparison of DB CRUD tests by OakLeaf Systems, and as an aside, it provides a review of published studies that may be of interest

    http://oakleafblog.blogspot.com/2008...-ec2-with.html

  8. #8
    "Certified" Alphaholic kkfin's Avatar
    Real Name
    Kenneth
    Join Date
    Dec 2006
    Location
    EU
    Posts
    1,560

    Default Re: Cloud computing wit Microsoft Azure platform

    Quote Originally Posted by koga101 View Post
    (I could not find third party vendors that support Azure) that can monitor insert, delete and updates to database records.
    If you are really sure you want to go with Azure here is one solution that supports Azure out of box. You could use Proxy Generator with Alpha.

    And Sql Azure support you can get here.

  9. #9
    "Certified" Alphaholic mmaisterrena's Avatar
    Real Name
    Mauricio Maisterrena
    Join Date
    Nov 2006
    Location
    Torreon, Mexico
    Posts
    1,435

    Default Re: Cloud computing wit Microsoft Azure platform

    Quote Originally Posted by kkfin View Post
    If you are really sure you want to go with Azure here is one solution that supports Azure out of box. You could use Proxy Generator with Alpha.
    Alpha already supports Azure out of the box, search for azure on the release notes.

    Edit: nevermind I think you are referring to a database manager software. I think SQL Server Manager works with azure (you can connect to an Azure DB)
    Last edited by mmaisterrena; 10-16-2010 at 07:03 PM.
    Cheers
    Mauricio


Similar Threads

  1. MySql Amazon Cloud
    By kkfin in forum Application Server Version 10 - Web/Browser Applications
    Replies: 1
    Last Post: 10-16-2010, 06:32 AM
  2. Invoice Report wit full info
    By mroberto in forum QReportBuilder
    Replies: 2
    Last Post: 07-28-2010, 11:03 AM
  3. Amazon Cloud
    By kkfin in forum Application Server Version 10 - Web/Browser Applications
    Replies: 12
    Last Post: 04-20-2010, 11:59 AM
  4. Balmer's new cloud initiative
    By martinwcole in forum Application Server Version 10 - Web/Browser Applications
    Replies: 12
    Last Post: 03-10-2010, 10:49 AM
  5. Printing wit Crosstab
    By samt2046 in forum Alpha Five Version 7
    Replies: 5
    Last Post: 11-20-2007, 09:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •