Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Why would I use Azure?

Why would I use Azure?

Scheduled Pinned Locked Moved The Lounge
sysadmindatabasesql-servercloudperformance
28 Posts 16 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    Slow Eddie
    wrote on last edited by
    #1

    Why would I use Azure when speed is dependent on my Internet connection, and Sql Server on my computer, or network is much faster (I think)?

    Ed

    S OriginalGriffO L J L 11 Replies Last reply
    0
    • S Slow Eddie

      Why would I use Azure when speed is dependent on my Internet connection, and Sql Server on my computer, or network is much faster (I think)?

      Ed

      S Offline
      S Offline
      Slacker007
      wrote on last edited by
      #2

      If you have to ask this question, and here in the Lounge, then you probably don't need Azure or cloud services for that matter. Your home network way of doing things is probably enough for you.

      1 Reply Last reply
      0
      • S Slow Eddie

        Why would I use Azure when speed is dependent on my Internet connection, and Sql Server on my computer, or network is much faster (I think)?

        Ed

        OriginalGriffO Offline
        OriginalGriffO Offline
        OriginalGriff
        wrote on last edited by
        #3

        Depends on what you want. If you want a mobile DB, that can be accessed by any device, any time, over LAN, WAN, mobile or wired connection then Azure is one way to go. If you want security, speed, and low cost, then ... ummm ... it probably isn't ... :~

        "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!

        "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
        "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

        1 Reply Last reply
        0
        • S Slow Eddie

          Why would I use Azure when speed is dependent on my Internet connection, and Sql Server on my computer, or network is much faster (I think)?

          Ed

          L Offline
          L Offline
          lmoelleb
          wrote on last edited by
          #4

          Do not think of Azure as an alternative to your development computer. It is an alternative to the server (farm) hosting your application. And while Azure and AWS can run virtual machines, it is an outdated way of doing software deployment and you will have limited benefit from running those in Azure. Docker will start to present some benefits (specifically if you need to run on-prem as well), but a "cloud native" architecture where you use Azure storage solutions, authentications, serverless, messagebus, ... is where you see the full benefit.

          F B M 3 Replies Last reply
          0
          • S Slow Eddie

            Why would I use Azure when speed is dependent on my Internet connection, and Sql Server on my computer, or network is much faster (I think)?

            Ed

            J Offline
            J Offline
            Jacquers
            wrote on last edited by
            #5

            Because your employer says that you must?

            E S 3 Replies Last reply
            0
            • S Slow Eddie

              Why would I use Azure when speed is dependent on my Internet connection, and Sql Server on my computer, or network is much faster (I think)?

              Ed

              L Offline
              L Offline
              Lost User
              wrote on last edited by
              #6

              Azure has multipele hosts, so redundancy and theoretic more uptime. Did I mention I'm a silverbug? Ya reckon I trust Amazon not to lock me out? Don't introduce useless dependencies. Ever.

              Bastard Programmer from Hell :suss: "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

              1 Reply Last reply
              0
              • S Slow Eddie

                Why would I use Azure when speed is dependent on my Internet connection, and Sql Server on my computer, or network is much faster (I think)?

                Ed

                S Offline
                S Offline
                Slacker007
                wrote on last edited by
                #7

                Why Azure—Cloud Innovation to Meet Any Challenge | Microsoft Azure[^]

                1 Reply Last reply
                0
                • S Slow Eddie

                  Why would I use Azure when speed is dependent on my Internet connection, and Sql Server on my computer, or network is much faster (I think)?

                  Ed

                  D Offline
                  D Offline
                  dandy72
                  wrote on last edited by
                  #8

                  It's not a one-size-fits-all solution. If you have no use for it (and not everybody does), don't force a square peg in a round hole. And there's nothing wrong with that. And don't let marketing tell you otherwise.

                  1 Reply Last reply
                  0
                  • S Slow Eddie

                    Why would I use Azure when speed is dependent on my Internet connection, and Sql Server on my computer, or network is much faster (I think)?

                    Ed

                    K Offline
                    K Offline
                    kmoorevs
                    wrote on last edited by
                    #9

                    I'll give you a real world example, which was actually my first experience and introduction to Azure. To obfuscate enough to avoid self-promotion, I'll simply refer to the product as MWC, a .net web-based timeclock system consisting of 4 basic pieces: 0: A small app for clocking in/out designed for touchscreen. Usage for this customer was 60 sites and an average of 5 workstations per site, so a potential for 300+ simultaneous connections. Remember that this is a timeclock, so inputs will be fairly concentrated and predictable. 1: A management portal. Usage in this case was also 60 sites plus several admin workstations. Patterns of usage are again predictable...concentrated in the morning and afternoon. 2: SQL Database 3: SQL Server Reports - This one became necessary due to Azure webapp restrictions plus the tight deadline for the project. (I had a co-worker who couldn't help code, but could do SSRS reports) So here you have a couple of related web applications that have vastly different needs. (really 3 if you count the reports delivered via the SSRS web portal) Then you have the database which obviously needs connections to everything else. Self-hosting was my first thought, (everything's local and fast) (and under my thumb) but it was out of the question. My network reliability is OK, but not good enough. Considering a webhost, I went shopping. At the time, (probably still do, not sure) MS had a free 90 day trial period so I gave it a shot. Here's how it ended up. The tiny workhorse web app debuted in the Shared Tier but was quickly bumped to Standard. Cost at the time: est: $50/mth. The management portal web app started (and stayed) in the Free Tier. The database tier was S1. I don't remember exactly, but at the time it was around $30/mth. All told, it was around $90 a month for everything. I realize I could have gone with a cheap php/mysql host but I swore off PHP a project before and even though the prototype was already written in php, I was scrapping it anyway. To summarize, Azure gives you a lot of flexibility with regards to scaling any component either up or out, ssl was automatic on the web apps, and it just worked. In the end, I found an even better, and cheaper alternative to the original setup...an Azure VM that now runs 2 of these MWC systems plus another half-dozen web apps for other customers. I've got SSRS set to serve out reports (the ones that haven't been ported to DevExpress yet). With the VM, you have complete control of the environment, just list self-hosting. Maintenance

                    1 Reply Last reply
                    0
                    • J Jacquers

                      Because your employer says that you must?

                      E Offline
                      E Offline
                      englebart
                      wrote on last edited by
                      #10

                      Second.

                      1 Reply Last reply
                      0
                      • J Jacquers

                        Because your employer says that you must?

                        S Offline
                        S Offline
                        Slow Eddie
                        wrote on last edited by
                        #11

                        Fortunately, I get to make those decisions for my employer. ;) ;) ;)

                        ed

                        1 Reply Last reply
                        0
                        • J Jacquers

                          Because your employer says that you must?

                          S Offline
                          S Offline
                          Slow Eddie
                          wrote on last edited by
                          #12

                          Fortunately, I get to make those decisions for my employer. ;) ;) ;)

                          1 Reply Last reply
                          0
                          • S Slow Eddie

                            Why would I use Azure when speed is dependent on my Internet connection, and Sql Server on my computer, or network is much faster (I think)?

                            Ed

                            K Offline
                            K Offline
                            Keefer S
                            wrote on last edited by
                            #13

                            There are times when the data that you are dealing with may need to be accessed by others outside of your physical location. Consider the following real-life example. We generate hundreds of thousands of food inspection documents each year with inspections performed using software that we design and maintain. We use C# for coding our software and SQL to store our data. Other states also use our software and produce similar amounts of documents. The USDA wanted to be able to view the documents and associated data without having to contact each state to get the documents that they wanted at any given time. Hosting the data at our main HQ was not a viable solution. Instead, we used Azure to host the data. We make connections to the data from our local on-site software to load the documents and their inspection data into the SQL database at Azure daily. We also have a password-protected web-based interface where authorized users can pull up desired documents, print them out, etc. This was our first truly cloud-based project so there was a lot of learning involved. I suggest that you do NOT attempt to buy a domain through Azure. We could never get the domain name purchase to go through so wound up purchasing elsewhere and then pointing to Azure through custom DNS records. Setting up the custom DNS records and getting everything to work correctly was somewhat complex (because an Azure SSL certificate was also involved), but we eventually wound up with a solution that is a perfect fit for our needs. “The Ultimate Question: 2b | !2b?” ** I would love to change the world, but they won’t give me the source code ** <*})><

                            1 Reply Last reply
                            0
                            • S Slow Eddie

                              Why would I use Azure when speed is dependent on my Internet connection, and Sql Server on my computer, or network is much faster (I think)?

                              Ed

                              D Offline
                              D Offline
                              Dan Neely
                              wrote on last edited by
                              #14

                              Because you don't need as much ram as Mauve?

                              Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius

                              1 Reply Last reply
                              0
                              • L lmoelleb

                                Do not think of Azure as an alternative to your development computer. It is an alternative to the server (farm) hosting your application. And while Azure and AWS can run virtual machines, it is an outdated way of doing software deployment and you will have limited benefit from running those in Azure. Docker will start to present some benefits (specifically if you need to run on-prem as well), but a "cloud native" architecture where you use Azure storage solutions, authentications, serverless, messagebus, ... is where you see the full benefit.

                                F Offline
                                F Offline
                                frostcox
                                wrote on last edited by
                                #15

                                Hey, can you elaborate a bit on how docker will give benefits when running on premis? I use docker a lot in my dev environment but not for deploying to production.

                                J L 2 Replies Last reply
                                0
                                • F frostcox

                                  Hey, can you elaborate a bit on how docker will give benefits when running on premis? I use docker a lot in my dev environment but not for deploying to production.

                                  J Offline
                                  J Offline
                                  jochance
                                  wrote on last edited by
                                  #16

                                  It tends to eliminate/minimize many environmental/configurational concerns. The segregation of containerization means that it is less often that environment/configuration changes for system A unexpectedly and negatively impact system B. For example, windows' hosts file. In non-containers, that gets shared with everything sitting on that machine. Containers? Each has its own, and as a matter of creating the container, it's already setup. In the same vein you have less scripting/manual configuration of the hardware/OS on the deployment target as most of that stuff would/should live in the containers.

                                  F 1 Reply Last reply
                                  0
                                  • J jochance

                                    It tends to eliminate/minimize many environmental/configurational concerns. The segregation of containerization means that it is less often that environment/configuration changes for system A unexpectedly and negatively impact system B. For example, windows' hosts file. In non-containers, that gets shared with everything sitting on that machine. Containers? Each has its own, and as a matter of creating the container, it's already setup. In the same vein you have less scripting/manual configuration of the hardware/OS on the deployment target as most of that stuff would/should live in the containers.

                                    F Offline
                                    F Offline
                                    frostcox
                                    wrote on last edited by
                                    #17

                                    Thanks very much for your informative answer. So specifically on the orchestration/management of these containers on lets say a windows VM running in the customers datacentre. Wouldn't you need to also deploy Kubernetes or Red Hat Openshift to deploy these containers in the wild so doesn't that add a level of complexity that a standard deployment doesn't?

                                    L J 2 Replies Last reply
                                    0
                                    • L lmoelleb

                                      Do not think of Azure as an alternative to your development computer. It is an alternative to the server (farm) hosting your application. And while Azure and AWS can run virtual machines, it is an outdated way of doing software deployment and you will have limited benefit from running those in Azure. Docker will start to present some benefits (specifically if you need to run on-prem as well), but a "cloud native" architecture where you use Azure storage solutions, authentications, serverless, messagebus, ... is where you see the full benefit.

                                      B Offline
                                      B Offline
                                      Bruce Patin
                                      wrote on last edited by
                                      #18

                                      "cloud native" can also be much more expensive than a VM.

                                      L 1 Reply Last reply
                                      0
                                      • L lmoelleb

                                        Do not think of Azure as an alternative to your development computer. It is an alternative to the server (farm) hosting your application. And while Azure and AWS can run virtual machines, it is an outdated way of doing software deployment and you will have limited benefit from running those in Azure. Docker will start to present some benefits (specifically if you need to run on-prem as well), but a "cloud native" architecture where you use Azure storage solutions, authentications, serverless, messagebus, ... is where you see the full benefit.

                                        M Offline
                                        M Offline
                                        Mateusz Jakub
                                        wrote on last edited by
                                        #19

                                        I would stop for a moment and think about calling stuff "outdated" :) Fora lot of workloads/systems having a VM is perfectly good solution. Running VM or two on IaaS provider is much cheaper that having to pay Azure bills.

                                        L 1 Reply Last reply
                                        0
                                        • M Mateusz Jakub

                                          I would stop for a moment and think about calling stuff "outdated" :) Fora lot of workloads/systems having a VM is perfectly good solution. Running VM or two on IaaS provider is much cheaper that having to pay Azure bills.

                                          L Offline
                                          L Offline
                                          lmoelleb
                                          wrote on last edited by
                                          #20

                                          I have no hesitation calling VMs outdated. It can still be a perfectly good solution for running legacy software - where the rewrite would cost more than the benefits. Even for new software we do have to support it as some of our customers have very valid reasons to self host, and... well... let's just say it takes way more than 10 years for them to introduce something new. I guess we should just be happy they have VMs and are not carrying machines around. Docker is a reasonable solution that gives some benefit no matter if you run in your own data-center, IaaS, or Azure/AWS etc, but of course the software needs to be designed for it. More cloud native (using more cloud services) will give Azure (or AWS etc) additional benefits that IaaS and self-hosting just can't deliver. If those benefits are worth anything to your project is of course up to your own "finger in the air" cost/benefit calculations. Spend 100 a month on an Azure resource and they will ask "do we still need this". Spend 1000 a month in salaries to build and maintain your own autoscale, failover, configuration management, ... and they will say "we are investing in our product". :)

                                          M 1 Reply Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • World
                                          • Users
                                          • Groups