• 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 LiddleSQL Server AdministratorVideo Blog - YouTubeWeb Blog - www.thomasliddledba.comTwitter - @thomasliddledbaFacebook - @thomasliddledba