From Tool to Transformation: The Growing Role of AI in Database Operations
October 02, 2024

Tushita Gupta
Redgate Software

Share this

Generative AI and large language models (LLMs) are becoming essential in data-driven businesses. With increasing pressures on time and resources, as well as growing complexity, AI offers critical support. It's not about AI replacing jobs, but rather about companies missing growth opportunities if they don't take advantage of AI tools. Businesses that fail to leverage AI may find themselves at a disadvantage compared to those that do.

But when do we make the shift to AI, and how?

We surveyed IT professionals on their attitudes and practices regarding using Generative AI with databases. We asked how they are layering the technology in with their systems, where it's working the best for them, and what their concerns are. Our 2024 survey on the State of the Database Landscape engaged 3,849 global IT professionals from all kinds of businesses, from large to small, and across 15 industry sectors.

You're Not Late Yet

We found that 20% of our respondents are already using AI in the context of database management, and 35% are planning to. We believe that many of the 32% who say they don't currently have plans to use AI will change their tune in the next few years.


AI is not a panacea. It is a tool like any other, and it requires active and wise technological leadership to keep it aligned with business objectives. As Jeff Foster, our director of technology and innovation, says, "You need decent code reviews, human oversight and process-based guardrails to help prevent the buildup of technical debt."

How It's Used

Generative AI may be just a tool, but it is a unique one, as reflected in how people are using it in database development. More than any other task, our survey respondents are using AI for testing and development tasks that involve database schema (65%). AI is also used for generating and optimizing queries and code, and for generating sample data. These are areas where AI has unique and powerful benefits.

We believe it's critical to understand that, at the phase of AI adoption in the database business, the tool is best used to support IT professionals in the day-to-day performance of their jobs. As we can see in how Generative AI is currently being used, its greatest impact today comes from streamlining and automating tasks. Using it for generating business insights is far down on the most popular uses.


We believe AI will ultimately be integrated into business decisions and that its use for "insights" will increase. However, that should not happen before we use the technology to make IT pros' jobs easier. Focusing on IT worker productivity will serve to get the group trained up on AI's capabilities, while providing them a time-saving benefit in their day to day.

We think it's appropriate and promising that the #1 task that organizations are looking at AI to streamline is query optimization. That's exactly the kind of work that benefits from human judgment combined with the pattern-matching skills of AI.


Generative AI will have a significant impact in many aspects of our jobs, as well as in the fundamental products and services that companies sell. But business will always be competitive, and at all levels of employment, from entry-level coder to CEO, it will remain necessary to apply human creativity to find ways to use — not be used by — technology. The more work we do to provide our IT professionals with exposure to these tools today, the more successful they will be in the future.

Tushita Gupta is Head of Product Design at Redgate Software
Share this

The Latest

October 02, 2024

We surveyed IT professionals on their attitudes and practices regarding using Generative AI with databases. We asked how they are layering the technology in with their systems, where it's working the best for them, and what their concerns are ...

October 01, 2024

40% of generative AI (GenAI) solutions will be multimodal (text, image, audio and video) by 2027, up from 1% in 2023, according to Gartner ...

September 30, 2024

Today's digital business landscape evolves rapidly ... Among the areas primed for innovation, the long-standing ticket-based IT support model stands out as particularly outdated. Emerging as a game-changer, the concept of the "ticketless enterprise" promises to shift IT management from a reactive stance to a proactive approach ...

September 27, 2024

In MEAN TIME TO INSIGHT Episode 10, Shamus McGillicuddy, VP of Research, Network Infrastructure and Operations, at EMA discusses Generative AI ...

September 26, 2024

By 2026, 30% of enterprises will automate more than half of their network activities, an increase from under 10% in mid-2023, according to Gartner ...

September 25, 2024

A recent report by Enterprise Management Associates (EMA) reveals that nearly 95% of organizations use a combination of do-it-yourself (DIY) and vendor solutions for network automation, yet only 28% believe they have successfully implemented their automation strategy. Why is this mixed approach so popular if many engineers feel that their overall program is not successful? ...

September 24, 2024

As AI improves and strengthens various product innovations and technology functions, it's also influencing and infiltrating the observability space ... Observability helps translate technical stability into customer satisfaction and business success and AI amplifies this by driving continuous improvement at scale ...

September 23, 2024

Technical debt is a pressing issue for many organizations, stifling innovation and leading to costly inefficiencies ... Despite these challenges, 90% of IT leaders are planning to boost their spending on emerging technologies like AI in 2025 ... As budget season approaches, it's important for IT leaders to address technical debt to ensure that their 2025 budgets are allocated effectively and support successful technology adoption ...

September 19, 2024

As businesses and individuals increasingly seek to leverage artificial intelligence (AI), the cloud has become a critical enabler of AI's transformative power. Cloud platforms allow organizations to seamlessly scale their AI capabilities, hosting complex machine learning (ML) models while providing the flexibility needed to meet evolving business needs ... However, the promise of AI in the cloud brings significant challenges ...

September 18, 2024

The business case for digital employee experience (DEX) is clear: more than half (55%) of office workers say negative experiences with workplace technology impact their mood/morale and 93% of security professionals say prioritizing DEX has a positive impact on an organization's cybersecurity efforts, according to the 2024 Digital Employee Experience Report: A CIO Call to Action, a new report from Ivanti ...