{"id":85187,"date":"2019-09-11T16:33:15","date_gmt":"2019-09-11T16:33:15","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=85187"},"modified":"2021-04-27T13:35:12","modified_gmt":"2021-04-27T13:35:12","slug":"the-data-philes-team-meet-the-time-traveler","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/opinion\/editorials\/the-data-philes-team-meet-the-time-traveler\/","title":{"rendered":"The Data-Philes Team Meet the Time Traveler"},"content":{"rendered":"<p>The year is 1999, somewhere in Cambridge, UK. Kathi, a member of the Data-Philes team, is reading a memo sent from her manager. The memo talks about someone who disrupted a project management meeting in London. He claims he is from 20 years in the future. Chris walks in.<\/p>\n<p><strong>Chris:<\/strong> Kathi, have you seen the latest assignment from Simon? If we leave now,\u00a0 we can be at the facility where the time traveler is being held in a few minutes. Maybe he can share some of the news about 2019, like where to buy the best flying car.<\/p>\n<p><strong>Kathi:<\/strong> A few minutes! Do you have a transporter that I don\u2019t know about? Chris, obviously, this man is suffering from delusions. There is no reason interview him. Instead, I just heard that SQL Server 7 was released, and I would like to spend some time checking it out.<\/p>\n<p><strong>Chris:<\/strong> Ya know, Kathi, you don\u2019t even need a DBA when you use SQL Server 7.<\/p>\n<p><strong>Kathi:<\/strong> Ugh. I need to start brushing up on Oracle. All the SQL 6.5s will probably be upgraded within a year, and I won\u2019t have a job!<\/p>\n<p><strong>Chris:<\/strong> There is something really odd about our time traveler. You wouldn\u2019t believe\u00a0some of the things he said at that meeting!<\/p>\n<p><strong>Kathi:<\/strong> Like what?<\/p>\n<p><strong>Chris:<\/strong> Well, first, he said that the way the company builds software is all wrong.<\/p>\n<p><strong>Kathi:<\/strong> Aren\u2019t they using Waterfall methodology?<\/p>\n<p><strong>Chris:<\/strong> That\u2019s just it. They are using it.<\/p>\n<p><strong>Kathi:<\/strong> So, why is that wrong?<\/p>\n<p><strong>Chris:<\/strong> He says that in the future, companies will embrace something called\u00a0DevOps. Instead of building the entire project and releasing it all at once, they will\u00a0deploy code daily, maybe even several times a day! Developers and operations teams, including DBAs, will work together to make sure that deployments run smoothly.<\/p>\n<p><strong>Kathi:<\/strong> DevOps? That sounds like science fiction! Obviously, this man has watched a\u00a0few too many Star Trek episodes!<\/p>\n<p><strong>Chris:<\/strong> It gets better. He started talking about cloning databases to save space and\u00a0time for developers.<\/p>\n<p><strong>Kathi:<\/strong> See, there you go. Why would anyone care about saving space and time?\u00a0The biggest database I\u2019ve worked with was just a few gigabytes. Yes, it\u2019s a pain to copy for developers and setting everything up takes a few days, but we only have to do it a couple of times a year. We are careful to keep the database stable and not let too many changes sneak in.<\/p>\n<p><strong>Chris:<\/strong> That\u2019s what\u2019s so amazing. He said that, in 20 years, it will not be unusual to\u00a0have terabyte databases! With <a href=\"https:\/\/www.red-gate.com\/products\/dba\/sql-clone\/\">cloning<\/a>, even a terabyte database can be delivered\u00a0to a developer in seconds! And, it doesn\u2019t take up much room on the dev\u2019s hard\u00a0drive.<\/p>\n<p><strong>Kathi:<\/strong> Like I said: too much Star Trek! And, of course, when we need to set up a\u00a0brand-new environment, it only takes a few months to order the hardware, build it,\u00a0and get everything installed. It\u2019s not a big deal as long as there is space for the new\u00a0server in the basement server room.<\/p>\n<p><strong>Chris:<\/strong> Virtualization will be popular, too, so you won\u2019t have to order hardware for\u00a0every project.<\/p>\n<p><strong>Kathi:<\/strong> Well, SQL Server will never run on a virtual machine!<\/p>\n<p><strong>Chris:<\/strong> He also mentioned that the company should do everything they can to\u00a0prevent data breaches, especially since so much data will live in the cloud.<\/p>\n<p><strong>Kathi:<\/strong> What is a data breach? Data in the cloud? Now I know this guy is\u00a0delusional. That sounds like something from a Star Wars movie or maybe The\u00a0Matrix.<\/p>\n<p><strong>Chris:<\/strong> Evidently, in the future, it is not unusual for the data from a major company\u00a0to be stolen. Names, addresses, credit card numbers, all that in the hands of\u00a0thieves! If only they would use their powers for good and not evil!<\/p>\n<p><strong>Kathi:<\/strong> Is there any way to protect this type of sensitive information in the future?<\/p>\n<p><strong>Chris:<\/strong> Yes, he mentions that companies can use <a href=\"https:\/\/www.red-gate.com\/products\/dba\/data-masker\/\">data masking software<\/a> to sanitize\u00a0personal information before giving the databases to developers.<\/p>\n<p><strong>Kathi:<\/strong> That\u2019s amazing, but it sounds like so much work.<\/p>\n<p><strong>Chris:<\/strong> This is why I think this guy might be telling the truth. He mentioned that\u00a0there are <a href=\"https:\/\/www.red-gate.com\/products\/dba\/sql-provision\/\">tools<\/a> in the future that make automating this easier than it sounds.\u00a0He even managed to bring back some of these tools to demonstrate to the team.<\/p>\n<p><strong>Kathi:<\/strong> Now, that I\u2019d like to see&#8230;<\/p>\n<div class=\"spaced-bottom padded--tight scheme--lightest-grey\">\n<h4>Commentary Competition<\/h4>\n<p>Enjoyed the topic? Have a relevant anecdote? Disagree with the author? Leave your two cents on this post in the comments below, and our favourite response will win a $50 Amazon gift card. The competition closes two weeks from the date of publication, and the winner will be announced in the next Simple Talk newsletter.<\/p>\n<\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>The year is 1999, somewhere in Cambridge, UK. Kathi, a member of the Data-Philes team, is reading a memo sent from her manager. The memo talks about someone who disrupted a project management meeting in London. He claims he is from 20 years in the future. Chris walks in. Chris: Kathi, have you seen the&#8230;&hellip;<\/p>\n","protected":false},"author":110218,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143516,47125,53],"tags":[68855],"coauthors":[11292],"class_list":["post-85187","post","type-post","status-publish","format-standard","hentry","category-database-devops","category-editorials","category-featured","tag-sql-provision"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/85187","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/110218"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=85187"}],"version-history":[{"count":6,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/85187\/revisions"}],"predecessor-version":[{"id":85194,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/85187\/revisions\/85194"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=85187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=85187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=85187"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=85187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}