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 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
                                • B Bruce Patin

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

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

                                  Yep. You need to do a price/benefit calculation. If you need nothing from the cloud and it is old software - keep it in a VM. If it is new software and doesn't need the benefits offered by "cloud native", use Docker. Or Docker + some cloud services. We are stuck with customers that are not exactly pushing the technological limits (and I thought banks where bad), so we are now starting to build in docker containers (so we have a predictable and source controlled build environment - and easy reproduction on a local dev box), then pull the artifacts out for the dinosaurs to run in their IIS while we can spin up a docker image if we have to.

                                  B 1 Reply 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.

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

                                    Besides the configuration management mentioned already a container also resumes less resources than VM. You typically have many applications running on a host. This means a lot of memory consumption spinning up multiple copies of the kernel and various background services. This does not happen with docker - they will use the memory the processes need only. You could also see less disk usage as base images can be shared - though how much this will be the case will depend a lot on the containers running - if you run a bunch of images from different sources, there might not be that many shared images. And in case of autoscale, the time to start a new instance of a container is typically measured in seconds (as long as you have a machine ready to run it). If you have a single application on-prem, not a big benefit as you would need the hosts anyways, but in large environments or clouds it can make a difference. And if you have an app that have high load for short time (for example once a month) it can suddenly be a lot cheaper being in the cloud and only paying for what you use.

                                    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

                                      Sander RosselS Offline
                                      Sander RosselS Offline
                                      Sander Rossel
                                      wrote on last edited by
                                      #23

                                      I prefer it for my customers. Here's my situation, a customer wants an application where they can do A, B and C. I always propose a web application, as they can easily access it at work, from home, on the road, on their PC, tablet, phone, etc. In fact, the access on the phone and on the road has been a big issue for some of my clients, so web is a totally valid solution. However, they're just small companies that do not have servers or an IT department. Using Azure allows me to run a web application without barely any input from my clients for about €60 a month. I hook it up to Azure DevOps and I have fully automated build and release pipelines in minutes. I get a SQL Server database for another €5 a month. Having some additional services costs nothing extra as they can go on the €60 plan. My clients do not need to buy a server, they do not need an additional IT-person, they do not need updates or whatever. I can do it all for them and I don't need physical access to anything, nor VPN or what have you. The €60 a month isn't an issue for my customers and it gives a lot of ease and flexibility. Other situations can include hyperscale or very planned or unplanned usage. For example, I have a customer that has two jobs a day for 12 administrations and a couple of agents, so around 40 jobs in total, but it's a pretty intensive job that can take up to ten minutes (depending on the administration and agent, some only take seconds). I've chosen an Azure Function, which is serverless (and so "free" if you're not using it) and it just runs about ten minutes a day. Due to the scaling nature of Functions, it "decides" how many instances to run and within about ten minutes all jobs are done. That same concept would work for jobs that could trigger at any time, but also couldn't trigger for days. Do you really want to buy a server for those 10 minutes a day!? There are plenty of use cases for the cloud, or Azure in particular. Of course you do need a stable and preferably fast internet connection, but most businesses are already heavily dependent on internet anyway.

                                      Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure

                                      1 Reply Last reply
                                      0
                                      • L lmoelleb

                                        Yep. You need to do a price/benefit calculation. If you need nothing from the cloud and it is old software - keep it in a VM. If it is new software and doesn't need the benefits offered by "cloud native", use Docker. Or Docker + some cloud services. We are stuck with customers that are not exactly pushing the technological limits (and I thought banks where bad), so we are now starting to build in docker containers (so we have a predictable and source controlled build environment - and easy reproduction on a local dev box), then pull the artifacts out for the dinosaurs to run in their IIS while we can spin up a docker image if we have to.

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

                                        So I see Docker is important after all. My problem with cost is trying to put 27 applications using 30 databases into one database and build image to avoid the per database charge. Also, I need to know how to feed our punched cards into Docker. ;)

                                        1 Reply Last reply
                                        0
                                        • L lmoelleb

                                          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 Offline
                                          M Offline
                                          Mateusz Jakub
                                          wrote on last edited by
                                          #25

                                          Oh autoscale. I can run a lot of users on a single VM and don't need auto scale. We have high touch sales process and we do B2B. We also do "web applications" so we are doing a lot of writes and "eventual consistency" is not good enough, people expect what they write to read it back right away. Where we don't have that many reads on database, we don't have twitter problems like Shakira tweeting something and pushing it to followers. Auto scale and other stuff seem like killer feature if you serve lots of content and have a lot of reads. But if you write to database and database is bottleneck and auto scaling application would make more problems than it solves. So yeah that is part that I do not understand - everyone is scaling application instances but you have to write to database anyway and for my workloads it does not even make sense.

                                          L 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