Skip to main content

From Tool to Transformation: The Growing Role of AI in Database Operations

Tushita Gupta
Head of Product Design
Redgate Software

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.

Image
Redgate1

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.

Image
Redgate2

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.

Image
Redgate3

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

The Latest

According to Auvik's 2025 IT Trends Report, 60% of IT professionals feel at least moderately burned out on the job, with 43% stating that their workload is contributing to work stress. At the same time, many IT professionals are naming AI and machine learning as key areas they'd most like to upskill ...

Businesses that face downtime or outages risk financial and reputational damage, as well as reducing partner, shareholder, and customer trust. One of the major challenges that enterprises face is implementing a robust business continuity plan. What's the solution? The answer may lie in disaster recovery tactics such as truly immutable storage and regular disaster recovery testing ...

IT spending is expected to jump nearly 10% in 2025, and organizations are now facing pressure to manage costs without slowing down critical functions like observability. To meet the challenge, leaders are turning to smarter, more cost effective business strategies. Enter stage right: OpenTelemetry, the missing piece of the puzzle that is no longer just an option but rather a strategic advantage ...

Amidst the threat of cyberhacks and data breaches, companies install several security measures to keep their business safely afloat. These measures aim to protect businesses, employees, and crucial data. Yet, employees perceive them as burdensome. Frustrated with complex logins, slow access, and constant security checks, workers decide to completely bypass all security set-ups ...

Image
Cloudbrink's Personal SASE services provide last-mile acceleration and reduction in latency

In MEAN TIME TO INSIGHT Episode 13, Shamus McGillicuddy, VP of Research, Network Infrastructure and Operations, at EMA discusses hybrid multi-cloud networking strategy ... 

In high-traffic environments, the sheer volume and unpredictable nature of network incidents can quickly overwhelm even the most skilled teams, hindering their ability to react swiftly and effectively, potentially impacting service availability and overall business performance. This is where closed-loop remediation comes into the picture: an IT management concept designed to address the escalating complexity of modern networks ...

In 2025, enterprise workflows are undergoing a seismic shift. Propelled by breakthroughs in generative AI (GenAI), large language models (LLMs), and natural language processing (NLP), a new paradigm is emerging — agentic AI. This technology is not just automating tasks; it's reimagining how organizations make decisions, engage customers, and operate at scale ...

In the early days of the cloud revolution, business leaders perceived cloud services as a means of sidelining IT organizations. IT was too slow, too expensive, or incapable of supporting new technologies. With a team of developers, line of business managers could deploy new applications and services in the cloud. IT has been fighting to retake control ever since. Today, IT is back in the driver's seat, according to new research by Enterprise Management Associates (EMA) ...

In today's fast-paced and increasingly complex network environments, Network Operations Centers (NOCs) are the backbone of ensuring continuous uptime, smooth service delivery, and rapid issue resolution. However, the challenges faced by NOC teams are only growing. In a recent study, 78% state network complexity has grown significantly over the last few years while 84% regularly learn about network issues from users. It is imperative we adopt a new approach to managing today's network experiences ...

Image
Broadcom

From growing reliance on FinOps teams to the increasing attention on artificial intelligence (AI), and software licensing, the Flexera 2025 State of the Cloud Report digs into how organizations are improving cloud spend efficiency, while tackling the complexities of emerging technologies ...

From Tool to Transformation: The Growing Role of AI in Database Operations

Tushita Gupta
Head of Product Design
Redgate Software

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.

Image
Redgate1

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.

Image
Redgate2

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.

Image
Redgate3

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

The Latest

According to Auvik's 2025 IT Trends Report, 60% of IT professionals feel at least moderately burned out on the job, with 43% stating that their workload is contributing to work stress. At the same time, many IT professionals are naming AI and machine learning as key areas they'd most like to upskill ...

Businesses that face downtime or outages risk financial and reputational damage, as well as reducing partner, shareholder, and customer trust. One of the major challenges that enterprises face is implementing a robust business continuity plan. What's the solution? The answer may lie in disaster recovery tactics such as truly immutable storage and regular disaster recovery testing ...

IT spending is expected to jump nearly 10% in 2025, and organizations are now facing pressure to manage costs without slowing down critical functions like observability. To meet the challenge, leaders are turning to smarter, more cost effective business strategies. Enter stage right: OpenTelemetry, the missing piece of the puzzle that is no longer just an option but rather a strategic advantage ...

Amidst the threat of cyberhacks and data breaches, companies install several security measures to keep their business safely afloat. These measures aim to protect businesses, employees, and crucial data. Yet, employees perceive them as burdensome. Frustrated with complex logins, slow access, and constant security checks, workers decide to completely bypass all security set-ups ...

Image
Cloudbrink's Personal SASE services provide last-mile acceleration and reduction in latency

In MEAN TIME TO INSIGHT Episode 13, Shamus McGillicuddy, VP of Research, Network Infrastructure and Operations, at EMA discusses hybrid multi-cloud networking strategy ... 

In high-traffic environments, the sheer volume and unpredictable nature of network incidents can quickly overwhelm even the most skilled teams, hindering their ability to react swiftly and effectively, potentially impacting service availability and overall business performance. This is where closed-loop remediation comes into the picture: an IT management concept designed to address the escalating complexity of modern networks ...

In 2025, enterprise workflows are undergoing a seismic shift. Propelled by breakthroughs in generative AI (GenAI), large language models (LLMs), and natural language processing (NLP), a new paradigm is emerging — agentic AI. This technology is not just automating tasks; it's reimagining how organizations make decisions, engage customers, and operate at scale ...

In the early days of the cloud revolution, business leaders perceived cloud services as a means of sidelining IT organizations. IT was too slow, too expensive, or incapable of supporting new technologies. With a team of developers, line of business managers could deploy new applications and services in the cloud. IT has been fighting to retake control ever since. Today, IT is back in the driver's seat, according to new research by Enterprise Management Associates (EMA) ...

In today's fast-paced and increasingly complex network environments, Network Operations Centers (NOCs) are the backbone of ensuring continuous uptime, smooth service delivery, and rapid issue resolution. However, the challenges faced by NOC teams are only growing. In a recent study, 78% state network complexity has grown significantly over the last few years while 84% regularly learn about network issues from users. It is imperative we adopt a new approach to managing today's network experiences ...

Image
Broadcom

From growing reliance on FinOps teams to the increasing attention on artificial intelligence (AI), and software licensing, the Flexera 2025 State of the Cloud Report digs into how organizations are improving cloud spend efficiency, while tackling the complexities of emerging technologies ...