Create and Connect to an Azure SQL Database

  • thomasliddledba

    Ten Centuries

    Points: 1190

    Comments posted to this topic are about the item Create and Connect to an Azure SQL Database

    Thomas Liddle
    SQL Server Administrator
    Video Blog - YouTube
    Web Blog - www.thomasliddledba.com
    Twitter - @thomasliddledba
    Facebook - @thomasliddledba

  • riversoft

    SSC-Addicted

    Points: 415

    Thanks for the Article. Do you think this approach, Connect to Azure Sql Database over the internet, could be used as a primary backend database for a production .net program running on a windows desktop?
    I.E. The program is running on the desktop but connecting to the Azure Database via ADO.Net.
    Or is the latency too much?
    I know I would have to test but if the Azure Database Connection is not intended for remote apps the I need not try. 

    TIA, Don

  • thomasliddledba

    Ten Centuries

    Points: 1190

    riversoft - Monday, February 6, 2017 9:07 AM

    Thanks for the Article. Do you think this approach, Connect to Azure Sql Database over the internet, could be used as a primary backend database for a production .net program running on a windows desktop?
    I.E. The program is running on the desktop but connecting to the Azure Database via ADO.Net.
    Or is the latency too much?
    I know I would have to test but if the Azure Database Connection is not intended for remote apps the I need not try. 

    TIA, Don

    riversoft - Your approach would depend on a number of different factors.  For example, the desktops connection (hard-wired or wireless), connection speed, what function is the desktop application performing, and a number of other factors.  I say from an administrative perspective that I've had no issues performing tasks on my SQL Azure databases remotely via Powershell and SSMS.  My suggestion would be to test your application's performance (creating benchmarks and user tests) before you deploy to production.

    Thomas Liddle
    SQL Server Administrator
    Video Blog - YouTube
    Web Blog - www.thomasliddledba.com
    Twitter - @thomasliddledba
    Facebook - @thomasliddledba

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply