I must be missing something very important with all the "cloud" (remote hosting) options.
If I'm over here (such as in an office) and my data is over there (such as at a remote hosting facility), and the only path between here and there is the Internet, and I need to work with a large quantity of my data, how is it even possible to do that efficiently? How do I avoid dragging a large quantity of my data over the Internet, which is going to be much slower than a typical LAN? What if I need to create an exact copy of the production database for tracking down a problem? What if I need to populate a development database with production data? What if I need to create a large data extract for a business partner? What if I need to have a large quantity of data locally for analysis by business people using various tools? What if I need to have a large quantity of data locally for application testing or some kind of research?
I have run into all of these needs many times in my career. It's not clear to me how it's at all practical to handle these needs if/when the production database is remote.
My current job is 100% remote. I sometimes run queries that return quite a bit of data. If I run such a query from a machine within the corporate network the performance might be fine. If I run such a query from a machine in my home office the performance might be awful. The difference is dragging the data over the corporate network versus dragging the data over the Internet and into my house. It's not like I have a poor Internet connection. I just did a speed test on my Internet connection and I had better then 140 Mbps performance.
A previous employer of mine had an ERP system hosted elsewhere. Their business transactions were fine, but many other data operations were severely hampered by performance issues. They could have obtained a faster connection to the hosting facility, but it was extremely expensive.
How are people handling common data tasks, such as those I have mentioned here, when they are using remote hosting for their database(s)?
As more businesses use remote hosting for their database(s), at what point will the additional traffic over the Internet become an issue?
Many companies do not allow audio/video streaming over their corporate networks because it chews up bandwidth on their Internet connection. How is it not a similar issue if people are constantly accessing a remote database for operational reporting, analytic reporting, or other data intensive tasks?
Creator of SQLFacts, a free suite of tools for SQL Server database professionals.