ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles

    Scheduled Pinned Locked Moved IT Discussion
    zerotiersql expresslegacy
    17 Posts 5 Posters 2.4k Views
    Loading More Posts
    • 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.
    • T
      taurex @scottalanmiller
      last edited by taurex

      @scottalanmiller

      I totally agree with you, Scott. I already told them they need to migrate to an SaaS solution asap but the current app is so customised to their business that they're entirely locked themselves in with it. The owner is reluctant to change anything and the developer keeps assuring him that his app is great and it serves its purpose 100%. But the way the dev implemented it was simply awful. Currently it takes about 4 seconds from the remote branch just to access the DB!

      I see this situations almost every time I assess SMBs. Horribly old apps running on below par hardware.

      1 Reply Last reply Reply Quote 0
      • T
        taurex @scottalanmiller
        last edited by

        @scottalanmiller

        So if they don't want to migrate to another solution, what would be the sensible option for them, then? Running it on a virtual host with two VMs - SQL and RDS with the ERP app installed? Thanks.

        bbigfordB scottalanmillerS 2 Replies Last reply Reply Quote 0
        • bbigfordB
          bbigford @taurex
          last edited by

          @taurex said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

          @scottalanmiller

          So if they don't want to migrate to another solution, what would be the sensible option for them, then? Running it on a virtual host with two VMs - SQL and RDS with the ERP app installed? Thanks.

          Yes. Screen scrapes don't require much. Keep RDS in a DMZ if it will ever be open to the world, or accessible from a dirty BYOD. Otherwise, over VPN for security.

          1 Reply Last reply Reply Quote 0
          • scottalanmillerS
            scottalanmiller @taurex
            last edited by

            @taurex said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

            @scottalanmiller

            So if they don't want to migrate to another solution, what would be the sensible option for them, then? Running it on a virtual host with two VMs - SQL and RDS with the ERP app installed? Thanks.

            Yup, RDS is the industry standard fallback for legacy apps moving to the remote work world. That's the purpose of RDS specifically. If you had modern apps that didn't have legacy issues, you'd effectively never need something like RDS.

            1 Reply Last reply Reply Quote 0
            • T
              taurex
              last edited by taurex

              Thanks @scottalanmiller and @bbigford. Not sure if they are willing to spend $$$ to do it right, though. OMG this SMB is so cheap, they're running this SQL DB on a 5 y.o. Dell tower server with no RAID and a consumer-grade HDD! They do have an internal IT guy but he has no business IT concepts whatsoever, he's more like an IT hobbyist with web design background.

              I keep telling them they're wasting productivity with their disastrous IT. However, the main problem with many small organisations here is they don't see IT as an investment more like an inevitable expense. I believe that now a successful organisation regardless of its size is always built around a reliable and efficient IT infrastructure that serves them as operational backbone.

              scottalanmillerS 1 Reply Last reply Reply Quote 0
              • scottalanmillerS
                scottalanmiller @taurex
                last edited by

                @taurex said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                Thanks @scottalanmiller and @bbigford. Not sure if they are willing to spend $$$ to do it right, though. OMG this SMB is so cheap, they're running this SQL DB on a ....

                Depends how you look at it. You see them as being cheap. I see them as burning money because it's a big joke to show how much they can throw away. SQL Server is only chosen by the ultra rich with money to flaunt. Companies lacking money do IT well and run lean, companies that laugh in the face of profits because they have so much money that it's all just silly to them select outrageously overpriced products for no reason and run them on old worthless hardware... just because it's funny.

                T dbeatoD 2 Replies Last reply Reply Quote 0
                • T
                  taurex @scottalanmiller
                  last edited by

                  @scottalanmiller said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                  Depends how you look at it. You see them as being cheap. I see them as burning money because it's a big joke to show how much they can throw away. SQL Server is only chosen by the ultra rich with money to flaunt. Companies lacking money do IT well and run lean, companies that laugh in the face of profits because they have so much money that it's all just silly to them select outrageously overpriced products for no reason and run them on old worthless hardware... just because it's funny.

                  Their DB is relatively small (6 GB) and they're using free SQL Server Express with it, though. The whole thing should've really been open source and web-based, I agree.

                  scottalanmillerS 1 Reply Last reply Reply Quote 0
                  • scottalanmillerS
                    scottalanmiller @taurex
                    last edited by

                    @taurex said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                    @scottalanmiller said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                    Depends how you look at it. You see them as being cheap. I see them as burning money because it's a big joke to show how much they can throw away. SQL Server is only chosen by the ultra rich with money to flaunt. Companies lacking money do IT well and run lean, companies that laugh in the face of profits because they have so much money that it's all just silly to them select outrageously overpriced products for no reason and run them on old worthless hardware... just because it's funny.

                    Their DB is relatively small (6 GB) and they're using free SQL Server Express with it, though. The whole thing should've really been open source and web-based, I agree.

                    Even the free version... it requires the expensive Windows license, it takes extra effort to maintain, and it risks outgrowing the free version to become super expensive.

                    black3dynamiteB 1 Reply Last reply Reply Quote 1
                    • black3dynamiteB
                      black3dynamite @scottalanmiller
                      last edited by

                      @scottalanmiller said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                      @taurex said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                      @scottalanmiller said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                      Depends how you look at it. You see them as being cheap. I see them as burning money because it's a big joke to show how much they can throw away. SQL Server is only chosen by the ultra rich with money to flaunt. Companies lacking money do IT well and run lean, companies that laugh in the face of profits because they have so much money that it's all just silly to them select outrageously overpriced products for no reason and run them on old worthless hardware... just because it's funny.

                      Their DB is relatively small (6 GB) and they're using free SQL Server Express with it, though. The whole thing should've really been open source and web-based, I agree.

                      Even the free version... it requires the expensive Windows license, it takes extra effort to maintain, and it risks outgrowing the free version to become super expensive.

                      SQL Server Express is available on Linux so that clears up the Windows license.

                      scottalanmillerS 1 Reply Last reply Reply Quote 0
                      • scottalanmillerS
                        scottalanmiller @black3dynamite
                        last edited by

                        @black3dynamite said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                        @scottalanmiller said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                        @taurex said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                        @scottalanmiller said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                        Depends how you look at it. You see them as being cheap. I see them as burning money because it's a big joke to show how much they can throw away. SQL Server is only chosen by the ultra rich with money to flaunt. Companies lacking money do IT well and run lean, companies that laugh in the face of profits because they have so much money that it's all just silly to them select outrageously overpriced products for no reason and run them on old worthless hardware... just because it's funny.

                        Their DB is relatively small (6 GB) and they're using free SQL Server Express with it, though. The whole thing should've really been open source and web-based, I agree.

                        Even the free version... it requires the expensive Windows license, it takes extra effort to maintain, and it risks outgrowing the free version to become super expensive.

                        SQL Server Express is available on Linux so that clears up the Windows license.

                        NOW it is, but it wasn't when the choices were made, and not the version that they are stuck on. So maybe going forward that is true, but retains the growth risk.

                        1 Reply Last reply Reply Quote 0
                        • dbeatoD
                          dbeato @scottalanmiller
                          last edited by

                          @scottalanmiller said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                          @taurex said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                          Thanks @scottalanmiller and @bbigford. Not sure if they are willing to spend $$$ to do it right, though. OMG this SMB is so cheap, they're running this SQL DB on a ....

                          Depends how you look at it. You see them as being cheap. I see them as burning money because it's a big joke to show how much they can throw away. SQL Server is only chosen by the ultra rich with money to flaunt. Companies lacking money do IT well and run lean, companies that laugh in the face of profits because they have so much money that it's all just silly to them select outrageously overpriced products for no reason and run them on old worthless hardware... just because it's funny.

                          I disagree with company lacking money doing IT well and running lean, man have I seen many companies with lack of money and IT is well an afterthought or not even run well at all.

                          scottalanmillerS 1 Reply Last reply Reply Quote 0
                          • scottalanmillerS
                            scottalanmiller @dbeato
                            last edited by

                            @dbeato said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                            @scottalanmiller said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                            @taurex said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                            Thanks @scottalanmiller and @bbigford. Not sure if they are willing to spend $$$ to do it right, though. OMG this SMB is so cheap, they're running this SQL DB on a ....

                            Depends how you look at it. You see them as being cheap. I see them as burning money because it's a big joke to show how much they can throw away. SQL Server is only chosen by the ultra rich with money to flaunt. Companies lacking money do IT well and run lean, companies that laugh in the face of profits because they have so much money that it's all just silly to them select outrageously overpriced products for no reason and run them on old worthless hardware... just because it's funny.

                            I disagree with company lacking money doing IT well and running lean, man have I seen many companies with lack of money and IT is well an afterthought or not even run well at all.

                            Even if it is an afterthought...

                            1. Keeping IT till it is an afterthought is a form of wasting money. It means that at the time they were willing to throw money away for non-business reasons just because they preferred whatever else to having more money (e.g. rich enough that they no longer cared about profits)
                            2. Even when it is an afterthought, IT doesn't have to be intentionally wasteful. But when it is, it's because there is more money than people care about.

                            I think it's a different in how we perceive being "out of money."

                            You guys mostly use an absolute measure of "they don't seem to have loads of cash by my personal standards."

                            I use a relational measure of "they have so much money by their own standards that they don't care about throwing it away."

                            dbeatoD 1 Reply Last reply Reply Quote 0
                            • dbeatoD
                              dbeato @scottalanmiller
                              last edited by

                              @scottalanmiller said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                              @dbeato said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                              @scottalanmiller said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                              @taurex said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                              Thanks @scottalanmiller and @bbigford. Not sure if they are willing to spend $$$ to do it right, though. OMG this SMB is so cheap, they're running this SQL DB on a ....

                              Depends how you look at it. You see them as being cheap. I see them as burning money because it's a big joke to show how much they can throw away. SQL Server is only chosen by the ultra rich with money to flaunt. Companies lacking money do IT well and run lean, companies that laugh in the face of profits because they have so much money that it's all just silly to them select outrageously overpriced products for no reason and run them on old worthless hardware... just because it's funny.

                              I disagree with company lacking money doing IT well and running lean, man have I seen many companies with lack of money and IT is well an afterthought or not even run well at all.

                              Even if it is an afterthought...

                              1. Keeping IT till it is an afterthought is a form of wasting money. It means that at the time they were willing to throw money away for non-business reasons just because they preferred whatever else to having more money (e.g. rich enough that they no longer cared about profits)
                              2. Even when it is an afterthought, IT doesn't have to be intentionally wasteful. But when it is, it's because there is more money than people care about.

                              I think it's a different in how we perceive being "out of money."

                              You guys mostly use an absolute measure of "they don't seem to have loads of cash by my personal standards."

                              I use a relational measure of "they have so much money by their own standards that they don't care about throwing it away."

                              Who is "you guys"? because now there is a faction of some sort?

                              When I say there is no money, I meant it in an absolute sense of them having to cut employees or departments where they invest their money because they cannot afford it.

                              scottalanmillerS 1 Reply Last reply Reply Quote 0
                              • scottalanmillerS
                                scottalanmiller @dbeato
                                last edited by

                                @dbeato said in ZeroTier Virtual Adapter and SQL Express 2012 DB Troubles:

                                When I say there is no money, I meant it in an absolute sense of them having to cut employees or departments where they invest their money because they cannot afford it.

                                Cutting people while still throwing money away isn't the same as being out of money absolutely, it's just choosing expensive software over people, though.

                                1 Reply Last reply Reply Quote 0
                                • scottalanmillerS
                                  scottalanmiller
                                  last edited by

                                  Now it may be that they had money to flaunt that they could burn in the past, burnt it all, and are now living with the consequences of throwing that money away. But that's a little different. They still felt that throwing money away was worth it at the time. Today, sure, maybe they've run out of money, or many they just say that to justify decisions, but at the last time that they were making IT spending decisions....

                                  1 Reply Last reply Reply Quote 0
                                  • 1 / 1
                                  • First post
                                    Last post