Voice of the DBA

Tag: AI

  • The Computing Revolution

    One of the keynotes at this year’s Build conference was on the Future of Tech. This was a mix of live talk and recorded pieces from Kevin Scott, CTO at Microsoft. This talk looks at the innovation of tech, with lots of AI/ML, but also with the idea that data is fundamental to the future. While he notes that there are different eras in computing as we have breakthroughs, one of the fundamental things that will change the world is the data explosion.

    We constantly push through boundaries and past constraints that limited us just a few years ago. I can still remember a professor in college bragging about the 32MB of RAM in his Solaris workstation, at a time when many of us had 1,2, or maybe 4MB. I think about that each time I get a new device. In a generation of my life, we’ve grown an order of magnitude, and pushed into a new world where I don’t have an exponential level of computing on my desk, but in my pocket.

    We might appreciate or worry about the growth of data, and it’s implications, or we may get excited and embrace it. Either way, big data is coming, and it continues to come to many organizations. While most of us aren’t pushing 10TB+ databases, some of us are, and few of us think in MB anymore. Makes you think that perhaps the default settings in SQL Server for MB in some cases are silly. Surely a MB is a like a penny (or pence in the UK), take one, leave one, but they don’t really count. Not until there are hundreds of them, and even then, maybe only a thousand is worth much mental effort.

    I do agree that the big win with the Internet, and with many pieces of software, isn’t the platform, but the ways in which people take advantage of the platform. I think that the creativity of developers, taking advantage of incredible computing on mobile, is what has created an amazing revolution. However, it’s not really just the creative software, but the understanding and use of data at scale that has really enabled software to change the world. Access to lots of data, whether this is people wanting car rides, sharing their thoughts and images, or just the bits that make up the music of the world are the ways in which software can become incredibly popular. Also, this is how things might get incredibly dangerous.

    I do think that AI has the chance to become an inflection point in computing, helping to create more applications that will work with humans in new ways that harness our knowledge, ethics, and vision with the computing power that continues to grow in incredible ways.

    The keynote is an interesting watch. It’s about 45 minutes, but if you want to dream a bit, it’s worth your time.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • Smarter Design

    I have build a lot of PowerPoint decks over the years. Many of presentations, some for explaining a process, and once in awhile, I use it to create an image that’s simple, but beyond my skills. Even putting some geometric shapes together in a clean, aligned manner, is something I’ve found easier to do in PowerPoint than Paint.Net.

    Some of you may have noticed the PowerPoint Design Ideas that pop up when you create a new slide. At first I didn’t pay much attention, but I’ve started to take advantage of the ideas at times. The way that slides are put together is often much more visually appealing than any I’d think of by myself. Sometimes I take an idea and modify it slightly. At first I thought most of these were just standard templates, but Microsoft is starting to use more ML in the examples that pop up on the side.

    There’s a good AI Show episode at the bottom of this post that explains some of what they do. From image recognition to intelligent cropping to natural language processing, they are finding ways to make better design ideas available. the episode is only minutes and worth watching if you want to know more about how they use technology in their recommendations.

    To me, this is a good example of how technology and humans work together. Someone needs to come up with some good designs, based on certain situations. Users then provide them feedback on if they’re useful or not, and they can modify things. I even learned how to change the icons for the designs if I don’t quite like them. My changes (and yours) get fed back to new models as training for the future.

    Would this make all presentations look alike? I think there is some danger here that we start to coalesce into certain patterns. We might see lots of slides with dates become timelines, but they won’t be exactly the same, and there are different ideas based on content. Even the words in the titles. I made two slides, same content with a different title and I got slightly different recommendations.

    I think AI and ML have good futures, but not as the sole decision makers for how to react to data. Instead, I think humans constantly providing feedback, input into models, changing weights, and yes, helping with more complex things like design, will improve the results that more of us get from our tools.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • How Much AI Do We Need?

    I like to cook and bake. The act of putting something together relaxes me, and I’ve certainly had plenty of time in 2020 to do this. In fact, I’ve been doing so much that my wife and daughter ordered me a new stand mixer while I was making them cookies this past weekend. They thought it would make it easier for me to continue to prepare more meals when life returns to some sort of normalcy.

    I’m not a chef, and I certainly struggle through some recipes, but I enjoy the time working through the act of assembling something. I also struggle with fitting in the time to prepare things around an otherwise busy life. When I saw this article on smart appliances, I stopped to think that some of these might be nice, but perhaps they’re also reduce some of the skills I’ve built and perhaps make my time in the kitchen less enjoyable. Would I become dependent on them, entitled, or even less excited about the task of cooking?

    It’s something I hadn’t considered too often, especially in other areas where AI and “smart” items are becoming more commonplace. I think some of advances in the data platform are good, and certainly some of the cloud services handle tasks that are fairly simple and they do them well. Backups happening in many of the PaaS services are mostly something we don’t need to configure or worry about, though we ought to be sure we know how to actually perform a restore. I have high hopes for some of the index automation and other changes, though there is a ways to go.

    Is the use of more AI in systems better? In some sense I think this can help us cope with busier and more complex lives, and allow us time to focus on the things we want to focus on. At the same time, I suspect these systems aren’t as mature as the marketing suggests, and the options certainly command a premium, which is something that might benefit the vendor more than the consumer.

    Like any advance, this could be helpful or hurtful for any of us. I like to assemble things from scratch more often than not, and I’m not sure if I think the AI gadgetry is something I’d enjoy. For now, I’m taking a small step, with a little mechanical assistance that might let me less time on the physical activity of combining things and more time planning my next steps or chatting with the audience that is often sitting at the counter.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • The Evolution of AI

    I saw a study recently where an AI system was used to analyze code and trying to decide if authors were good. The conclusions were things we’d expect, and quite a few people laughed about this on Twitter. After all, if AI comes to the obvious answer, is it useful? Perhaps, but it’s also a little disappointing.

    I’ve felt that way about AI for some time. Years ago I went through an AI demo for the Titantic data set, coming to the conclusion that the lower you were in the ship, or poorer, the more likely you were to have died. I went through a tutorial with Microsoft on flight data, trying to determine why flights were late. It turned out the later they left, the more likely they were to be late arriving.

    While this might seem silly, and perhaps obvious, I think that’s OK. We don’t expect these early AI systems to be better than humans, at least I don’t. However, what I do expect is that they can do at least as well as humans, and having them return results that we could figure out is a good step. To me, this also gives me confidence that a computer can be used to analyze a complex problem or situation.

    There is more evolution coming in the AI and ML worlds. I have no doubt that these systems will improve, and likely find niches where they are valuable and very helpful in making decisions. The world is gathering more and more data, and it’s becoming hard for humans to analyze it, and maybe more importantly, react quickly. The rate at which data can change is overwhelming, especially for humans. I think that we will need computing systems to help process the vast amounts of data we continue to accrue.

    While I don’t know that I want AI/ML systems making decisions for me, I do think they can help reduce the burden of looking over data and help humans to better focus their analysis in certain areas. A symbiosis of computing software using AI, data, and a human to closely watch it is what I think will really help us become even more efficient and focused in our particular organization.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.