{"id":108958,"date":"2026-03-05T09:31:05","date_gmt":"2026-03-05T09:31:05","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=108958"},"modified":"2026-03-05T09:31:06","modified_gmt":"2026-03-05T09:31:06","slug":"my-thoughts-on-redgates-2026-state-of-the-database-landscape-report","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/opinion\/editorials\/my-thoughts-on-redgates-2026-state-of-the-database-landscape-report\/","title":{"rendered":"My thoughts on Redgate&#8217;s 2026 State of the Database Landscape report"},"content":{"rendered":"\n<p>I always really look forward to reading Redgate&#8217;s annual <a href=\"https:\/\/www.red-gate.com\/solutions\/state-of-database-landscape\/2026\/\" target=\"_blank\" rel=\"noreferrer noopener\">State of the Database Landscape report<\/a>, and 2026 was no exception. I love the level of detailed statistics they collected from many thousands of database professionals worldwide, from DBAs to senior leaders, and from and so many different organizations. There&#8217;s a lot to digest, so here are my thoughts on it. Take a look and feel free to share your own experiences and insights in the comments.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-operational-practices-in-2026\">Operational practices in 2026<\/h2>\n\n\n\n<p>One thing called out early in the report is that local knowledge, manual controls and operational practices no longer work. Most organizations are now working with <a href=\"https:\/\/www.red-gate.com\/blog\/four-steps-towards-tackling-the-complexity-of-managing-multiple-database-platforms\/\" target=\"_blank\" rel=\"noreferrer noopener\">multiple database systems<\/a>, and no one individual is sufficiently across all of them.<\/p>\n\n\n\n<p>As the number of databases at each organization increases fast (and not just the number of different <em>types<\/em> of databases), operational practices are becoming more challenging. I didn&#8217;t used to see many clients with thousands of databases, but now it&#8217;s becoming quite routine. In the past, it was just a select few, very specific, types of customer who operated multiple platforms.<\/p>\n\n\n\n<p>For example, I worked with mining companies who had one database per drilling rig, and they had tens of thousands of them. I always thought they were a great example of why <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/policy-based-management\/set-the-auto-close-database-option-to-off?view=sql-server-ver17\" target=\"_blank\" rel=\"noreferrer noopener\">AutoClose shouldn&#8217;t be removed as an option from SQL Server<\/a>. If you have tens of thousands of databases on an instance, and only a handful are being used at any point in time, you don&#8217;t want them all online.<\/p>\n\n\n\n<p>But today, pools of cloud-based databases connected to SaaS applications is a common cause. Many SaaS vendors choose to use databases as one of the core isolation levels for their applications. It certainly makes it harder to accidentally show one customer&#8217;s data to another.<\/p>\n\n\n\n<p>Elsewhere, I was interested to see the mention that organizations exposed to auditing are getting better at database monitoring. The pressure from audits is clearly helping. After all, <a href=\"https:\/\/www.red-gate.com\/blog\/audit-and-compliance\/database-monitoring-and-security-go-hand-in-hand\/\" target=\"_blank\" rel=\"noreferrer noopener\">consistent monitoring is essential<\/a> &#8211; and clearly is of interest for Redgate with their <a href=\"https:\/\/www.red-gate.com\/blog\/redgate-monitor-blog\/14-reasons-why-redgate-monitor\/\" target=\"_blank\" rel=\"noreferrer noopener\">Redgate Monitor tool<\/a>.<\/p>\n\n\n\n<p>Lastly, it was disappointing &#8211; but not surprising &#8211; to see that adoption of <a href=\"https:\/\/www.red-gate.com\/blog\/database-devops\/devops-101-introducing-database-devops\/\" target=\"_blank\" rel=\"noreferrer noopener\">Database DevOps<\/a> (45%) and built-in <a href=\"https:\/\/www.red-gate.com\/simple-talk\/devops\/demystifying-continuous-integration-vs-continuous-delivery-part-3-real-world-examples-of-ci-cd\/\" target=\"_blank\" rel=\"noreferrer noopener\">CI\/CD<\/a> tools (38%) are both still sluggish.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-multiple-database-types-and-cloud-adoption-in-2026\">Multiple database types and cloud adoption in 2026<\/h2>\n\n\n\n<p>I was interested to see that the percentage of organizations working with just a single database increased in 2025 (to 26%) but fell again in 2026 (to 16%). Shared practices across multiple toolsets continues to be a challenge. Manual processes increase risk directly and respondents clearly say they want cross-database tooling.<\/p>\n\n\n\n<p>I&#8217;m sure that cloud-based systems are influencing that. The report notes that the number of fully on-premises estates has fallen from 53% in 2021 to just 20% in 2026, and that hybrid architectures are the default. From my work, I see that many cloud vendors do a good job in the cloud but still do a poor hybrid job.<\/p>\n\n\n\n<p>I liked seeing flexibility now cited (57%) as a key driver for <a href=\"https:\/\/www.red-gate.com\/simple-talk\/blogs\/on-premises-vs-cloud\/\" target=\"_blank\" rel=\"noreferrer noopener\">cloud adoption<\/a>. So often in the past, scalability seemed to be claimed as most important. I&#8217;ve always valued both. We depend on scalability in our systems and routinely dynamically scale resources to keep costs under control but performance up when needed. But so many times, I&#8217;ve been at client sites and thought that flexibility was what they missed.<\/p>\n\n\n\n<p>For example, a site that wanted to test <a href=\"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/database-administration-sql-server\/alwayson-availability-groups-what-not-to-do-when-adding-databases\/\" target=\"_blank\" rel=\"noreferrer noopener\">Always On AGs<\/a> and was determined to do so with their own hardware. It took them 4 weeks to get a suitable quote for the equipment and another 5 weeks for it to arrive. And, when it finally did, they told me they couldn\u2019t take a power outage on their racks to install it for another 4 weeks. If we had done the work in <a href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/virtual-machines\/overview\">Azure VMs<\/a>, it would have been completed in a single day.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-how-board-members-view-database-security-in-2026\">How board members view database security in 2026<\/h2>\n\n\n\n<p>The report noted that <a href=\"https:\/\/www.red-gate.com\/blog\/database-security-failures-dont-start-in-security-teams\/\" target=\"_blank\" rel=\"noreferrer noopener\">data security<\/a> has become a board-level concern. This is an area that I&#8217;m not so sure about. I&#8217;ve done work for many large financial organizations where the board are made well-aware of security issues, but the board also decides against resolving those issues, based on cost.<\/p>\n\n\n\n<p>The report notes that risk is increasing. I wish our local laws here in Australia were following this trend. It was interesting to see the statistic that 58% of organizations are willing to accept higher risk for efficiency gains. Why wouldn&#8217;t they if there&#8217;s no personal risk?<\/p>\n\n\n\n<div id=\"callout-block_c706b2278ebe534ff4e0ed51ad5c0eb4\" class=\"callout alignnone\">\n    <div class=\"child-last:mb-0 child-first:mt-0 bg-gray-50 dark:bg-gray-950 p-4xl my-3xl\">\n\n<p><strong>How to keep your databases secure in 2026: a complete guide<\/strong><br>Lukas Vileikis explains how to secure your databases against the ever-increasing security threats in 2026 &#8211; including best practices for access control, encryption, monitoring, resilience, and more. <a href=\"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/security\/securing-your-databases-in-2026-best-practices-for-the-evolving-threat-landscape\/\" target=\"_blank\" rel=\"noreferrer noopener\">Read the guide<\/a>.<\/p>\n\n<\/div>\n<\/div> \n\n\n<p>I think that if personal liability was attached to these decisions by board members, we&#8217;d be seeing very different decisions. With concepts like <a href=\"https:\/\/en.wikipedia.org\/wiki\/Trading_while_insolvent\" target=\"_blank\" rel=\"noreferrer noopener\">&#8220;trading whilst insolvent&#8221;<\/a>, board members in my country (Australia) understand that they become personally liable. However, they can still make poor security decisions that lose members or shareholders&#8217; funds, and seem to be able to just shrug it off. I hope that changes.<\/p>\n\n\n\n<p>And I&#8217;ll talk about AI more in a moment, but this just makes things even more challenging.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-data-security-and-cloud-based-vendors-in-2026\">Data security and cloud-based vendors in 2026<\/h2>\n\n\n\n<p>For many years, I&#8217;ve been telling my clients that, for high-risk financial systems, a move to cloud-based environments is inevitable. These are the same people who used to tell me that their hesitance in &#8220;moving to the cloud&#8221; was based on security concerns.<\/p>\n\n\n\n<p>In Australia, we have many regulations around computing systems that financial organizations must meet. And when I work in banks here, even larger ones, I see how they struggle to meet those requirements. Yet the best cloud providers have started with those regulations as a base level. I believe that as the requirements increase, the only way these systems will ever have a chance of meeting the requirements will be in high-end cloud providers. They just won&#8217;t be able to meet the requirements by themselves.<\/p>\n\n\n\n<p>A vendor who is managing many millions of cloud-based databases is going to have procedures in place that normal organizations just can&#8217;t compete with.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-cost-of-cloud-databases-in-2026\">The cost of cloud databases in 2026<\/h2>\n\n\n\n<p>I like <a href=\"https:\/\/www.red-gate.com\/blog\/from-your-data-center-to-the-cloud\/#:~:text=The%20big%20lie%20%2D%20cost%20saving%20in%20the%20cloud\" target=\"_blank\" rel=\"noreferrer noopener\">John Q Martin&#8217;s quote<\/a>: <em>&#8220;one of the main reasons that many organizations adopt cloud infrastructure for database and other workloads is the prospect of significant cost savings. However, most fail at this.&#8221;<\/em><\/p>\n\n\n\n<p>The biggest issue here is that far too many organizations still try to migrate database applications to the cloud, when those applications aren&#8217;t suitable in their current form.<\/p>\n\n\n\n<p>As an example, I was helping a local bank who had moved their overnight processing system from an on-premises server to a popular cloud vendors infrastructure. They called me because their overnight processing was now taking over 12 hours, when it used to take 2 hours. And worse, they had reserved cloud-based infrastructure that was, in theory, 10 times more powerful than their existing on-premises systems.<\/p>\n\n\n\n<p>That application could never move without the work we ended up helping them do on the application.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-data-quality-in-2026\">Data quality in 2026<\/h2>\n\n\n\n<p>Back when SQL Server introduced <a href=\"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/database-administration-sql-server\/data-cleaning-in-sql-2012-with-data-quality-services\/\" target=\"_blank\" rel=\"noreferrer noopener\">Data Quality Services<\/a>, I thought that finally there would be some action in this area. But the data quality issues stay unsolved. Everyone knows the importance, yet nobody is solving it.<\/p>\n\n\n\n<p>I found it interesting that in the report, Gartner predicts that 60% of AI projects without AI-ready data will be abandoned by the end of 2026. I can believe that. In the end, it doesn&#8217;t matter how good your analytics looks if the content is nonsense, or even just poor quality.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-adoption-of-ai-in-2026\">The adoption of AI in 2026<\/h2>\n\n\n\n<p>The challenge here is that everyone says the words &#8216;Artificial Intelligence&#8217;, but they often mean very different things.<\/p>\n\n\n\n<p>The report says that the proportion of organizations with no plans to adopt AI has fallen to 13%, yet only 44% say they already are. So, what are the rest doing? Sounds like a lot of just talking about it. And the stats show that the larger organizations are making the biggest strides &#8211; yet you&#8217;d think the smaller ones would have the most flexibility to allow them to get started with the technology.<\/p>\n\n\n\n<p>Jeff Foster&#8217;s quote, <em>&#8220;everyone wants to move faster with AI, but few are truly ready for it&#8221;<\/em>, is telling &#8211; and matches well with what I see around my client base.<\/p>\n\n\n\n<p>I work with AI-based systems every single day and now cannot imagine working without them. If you aren&#8217;t, it&#8217;s time to get involved. And I don&#8217;t just mean using <a href=\"https:\/\/chatgpt.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">ChatGPT<\/a>, useful as it can be.<\/p>\n\n\n\n<p>As an example, one area I love using AI tools for, is in <a href=\"https:\/\/www.red-gate.com\/blog\/introducing-redgate-test-data-manager-with-ai-smarter-safer-test-data-management\/\" target=\"_blank\" rel=\"noreferrer noopener\">generating realistic test data<\/a>. I still want test data that stretches the use of data types and parsing, but I also want test data that looks real but isn&#8217;t. AI tools can do a great job of that. And they are clever. For example, I can ask for a particular ethnic mix in customer details, and I <a href=\"https:\/\/www.red-gate.com\/products\/test-data-manager\/b\/#:~:text=Real%20alternatives%20for,AI%20custom%20datasets.\" target=\"_blank\" rel=\"noreferrer noopener\">get back realistic names.<\/a> I&#8217;ve learned enough Mandarin over the years to know that when I ask for 20% Chinese names, that they&#8217;ve used common Chinese family names, etc.<\/p>\n\n\n\n<p>Another example is <a href=\"https:\/\/www.red-gate.com\/blog\/from-productivity-to-performance-sql-prompts-next-chapter-with-ai\/#:~:text=Improving%20code%20quality%20with%20ease\" target=\"_blank\" rel=\"noreferrer noopener\">code review<\/a>. I recently had a Gen AI tool reformat some code for me. That&#8217;s a good example of &#8220;busy work&#8221; that AI can really help with. But I was so pleased when, while formatting the code, it pointed out a logical bug in one of the use cases covered by the code. Nice! <\/p>\n\n\n\n<p>But it&#8217;s not just limited to productivity &#8211; I believe that AI-based tooling is the only way we will ever deal with the onslaught of security issues heading our way.<\/p>\n\n\n\n<p>I&#8217;ll finish by saying that I continue to be amazed at the level of interest in chatbots, given how poorly they work today, at least in my experience. Is there any chatbot that you&#8217;ve ever interacted with, that&#8217;s done a great job for you? What percentage of them are just <em>annoying<\/em>, and make it look like the organization can&#8217;t be bothered having humans to talk to you?<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-final-thoughts\">Final thoughts<\/h2>\n\n\n\n<p>It&#8217;s a great report, full of fascinating statistics and insights. These were just some of my thoughts, but it&#8217;s well worth a full read for yourself &#8211; and why not share your takeaways from the report in the comments down below?<\/p>\n\n\n\n<section id=\"my-first-block-block_0c5e3c18f7498cc8ad1cd0abd2e0bab3\" class=\"my-first-block alignwide\">\n    <div class=\"bg-brand-600 text-base-white py-5xl px-4xl rounded-sm bg-gradient-to-r from-brand-600 to-brand-500 red\">\n        <div class=\"gap-4xl items-start md:items-center flex flex-col md:flex-row justify-between\">\n            <div class=\"flex-1 col-span-10 lg:col-span-7\">\n                <h3 class=\"mt-0 font-display mb-2 text-display-sm\">Download the full 2026 State of the Database Landscape report<br \/>\r\n<\/h3>\n                <div class=\"child:last-of-type:mb-0\">\n                                            As AI accelerates change and complexity increases, database teams are under pressure to move faster than ever \u2013 without losing control. Discover where control is slipping, the risks emerging as a result, and how teams are responding.                                    <\/div>\n            <\/div>\n                            <a href=\"https:\/\/www.red-gate.com\/solutions\/state-of-database-landscape\/2026\/\" class=\"btn btn--secondary btn--lg\">Learn more and download for free<\/a>\n                    <\/div>\n    <\/div>\n<\/section>","protected":false},"excerpt":{"rendered":"<p>Greg Low shares his thoughts on Redgate\u2019s 2026 State of the Database Landscape report, covering cloud adoption, database security, AI, increasing complexity, and more.&hellip;<\/p>\n","protected":false},"author":346483,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[47125,3],"tags":[4168,4170,4903,4144,159375],"coauthors":[159368],"class_list":["post-108958","post","type-post","status-publish","format-standard","hentry","category-editorials","category-opinion","tag-database","tag-database-administration","tag-editorial","tag-opinion","tag-state-of-the-database-landscape-2026"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/108958","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\/346483"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=108958"}],"version-history":[{"count":2,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/108958\/revisions"}],"predecessor-version":[{"id":108962,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/108958\/revisions\/108962"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=108958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=108958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=108958"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=108958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}