{"id":104457,"date":"2024-11-07T18:51:53","date_gmt":"2024-11-07T18:51:53","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=104457"},"modified":"2024-11-08T19:22:02","modified_gmt":"2024-11-08T19:22:02","slug":"pass-keynote-day-2-redgate","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/resources\/conferences\/pass-keynote-day-2-redgate\/","title":{"rendered":"PASS Keynote \u2013 Day 2 \u2013 Redgate"},"content":{"rendered":"

\u00a0<\/h1>\n

<\/p>\n

Time to start!<\/p>\n

Annabel Bradford (Head of Events at Redgate) comes out on stage.<\/em><\/p>\n

Intro<\/h2>\n

\"A<\/p>\n

Annabel takes the stage and for me she is the face of Redgate at PASS, what better person to kick off the Redgate Keynote! Annabel has been a Redgater for 15 years and is the \u201cHead of Events\u201d at Redgate \u2013 why am I not surprised! 14th PASS Summit.<\/p>\n

New building gets a shout out. It is incredible indeed!<\/p>\n

Yesterday 98 sessions, 50 clinic meetings, and lots of networking<\/p>\n

Another 79 sessions today!<\/p>\n

Let\u2019s be honest, as data geeks, most of use are just a little bit different. We appreciate you bringing your authentic self, even if you are from another part of the world or use other data platforms \u2013 \u201cwe embrace you\u201d seems to be message at PASS. 45% are first timers!<\/p>\n

\"A<\/p>\n

So much going on, get out there and connect, share and learn!<\/p>\n

\"A
Redgate is the proud host of the PASS Summit!<\/p>\n

Keynote: Simplifying Complexity: making the database work in the real world<\/h2>\n

Kellyn Gorman, Advocate and Engineer at Redgate<\/em><\/p>\n

Kellyn is the weird Oracle girl that we embraced. (her words!) Kellyn Gorman has an expansive history working with Oracle, and what better person to support Redgate\u2019s customers that support Oracle workloads?! Joined in 2012 by attending a SQLSaturday! Worked at Microsoft as an Oracle SME.<\/p>\n

<\/p>\n

Newest Redgate Advocate!<\/p>\n

\"A Multi-platform is the norm<\/h2>\n

\"A<\/p>\n

More and more people are multi-platform. But security is always a concern.<\/p>\n

Big stat that stands out to me. 61% have security concerns\u2026 Really only 21%.<\/p>\n

Stats that show that many many organizations are having a lot of difficulty getting proper data to test and work with.<\/p>\n

\"A<\/p>\n

Find your village and the right tools, because environments are complex. Love this AI slide because it is messy, and it makes you wonder if it was on purpose.<\/p>\n

\u201cWe don\u2019t want to be that person running into the cyclist\u201d<\/p>\n

\"A<\/p>\n

We adapt. DBA roles aren\u2019t going anywhere, but teams will realign roles.<\/p>\n

Graham McMIllan, Chief Technology Officer Redgate enters the stage, Kellyn leaves.<\/em><\/p>\n

Case for Change<\/h2>\n

Previously managing systems. One of the systems Graham managed had 30,000 SQL Servers and it was brittle. So, the goal is to find ways to make it less brittle and get more done.<\/p>\n

Archana Venkatraman, Senior Director of IDC Europe, enters the stage with Graham<\/em><\/p>\n

\"A<\/em><\/p>\n

Digital tech spending outpaces global economy seven times faster than the global economy.<\/p>\n

\"A
Delivery excellence is defined by four strategic priorities:<\/p>\n

Speed, Quality, Efficiency, and Productivity<\/p>\n

\"A<\/h3>\n

Hard to do with regulations and shrinking budgets!<\/p>\n

What is holding back Business and DevOps Success?<\/h3>\n

\"A
Technical debt is holding us back. (Something I have harped on for 25 years talking about database design\u2026 it all comes back to bite you!)<\/p>\n

3.5 hours is the average hours for DBA to deploy databases. I assume this is to deploy changes. Database changes considered the biggest bottleneck. Database dev done in a silo from developers. (Editor\u2019s note: some of this is explained by DBAs trying to avoid technical debt!<\/p>\n

Hard to rollback changes, which causes bottlenecks, but undoing mistakes takes a LOT of time!)<\/p>\n

Messy Middle.<\/h3>\n

Some form of digital impasse not being able to navigate many of the challenges.<\/p>\n

Security and compliance is always an issue. Return on investment is always a concern, which really doesn\u2019t play well with the security and compliance needs.<\/p>\n

Change management is basically hard, and how do we get out of this messy middle? In these terms the messy middle is evolving DevOps, data governance, heterogeneity<\/a>, and of course, the ongoing operational challenges.<\/p>\n

Share the pain, bring the teams together. 70% of IDC employees are in tech, and just 2% are DBAs. Like a 1-35 ratio of programmer to employee. That is a stark number, honestly.<\/p>\n

Six core data desires<\/p>\n


We need to empower the DBAs to get the work done as part of the team<\/p>\n

Resilience and Innovation are two competing needs we have<\/p>\n

Archana leaves the stage and Arneh Eskandari, Director of Solutions Engineering and Danny de Haan, Product Architect, Database Management for APG, enter.<\/em><\/p>\n

APC Discussion<\/h2>\n

Pensioner company in the Netherlands. 4.6 million covered members!<\/p>\n

They don\u2019t just have an eye for money. They strive to provide a good pension and good value to the work.<\/p>\n


Discussing how they used to do business 5 years ago. Lots of silos, teams complexly separate with lot so separation between teams. Things like GDPR, forced change.<\/p>\n

Fast forward to today, new infrastructure-as-code process. As a financial company, lots of different regulations to deal with.<\/p>\n

New tools used to give them a single pane of glass view for their developers.<\/p>\n

Infrastructure through Blueprinting<\/h3>\n

DevOps teams create blueprints for teams, they can provision databases, servers, etc.<\/p>\n

Easy to use, independent, efficient, compliant and secure by design.<\/p>\n

Balance of ease of use and compliance is amazingly important.<\/p>\n

Advice for the audience<\/h4>\n

<\/p>\n

Align your company, so they are all working together. Especially the DevOps team.<\/p>\n

Choose whether to build or by (they built), but when you buy, make sure it is flexible.<\/p>\n

You can build the nicest castle on a hilltop, but if they want a modern glass house with an infinity pool, they will not want it!<\/p>\n

<\/p>\n

Kellyn and Graham return<\/em><\/p>\n

Kellyn: DevOps is essential. We are expected to do more with less.<\/p>\n

State of the Database Landscape Highlights<\/h2>\n

2500+ people responded to the survey. Here are some early results.<\/p>\n

Three major issues: efficiency, innovations, and security. Graham is asking Kellyn what they all mean.<\/p>\n

<\/p>\n

Improve Efficiency: Means uptime. Never goes down (Kellyn jokes no users would help!)<\/p>\n

Innovation: Patching, updates, but we don\u2019t want to make changes. Testing, performing, security, correctness.<\/p>\n

Security: DBAs are VERY concerned about security.<\/p>\n

A Taster of Results:<\/h3>\n

<\/p>\n

74% of IT teams multi-platform<\/p>\n

25% are using more than one platform.<\/p>\n

<\/p>\n

The natural life of the database is growth<\/p>\n

18% of people are making DAILY changes. DAILY. I wonder what those changes are? New columns?<\/p>\n

50% increase in short notice changes.<\/p>\n

Two type of orgs emerge, rapid changers, and those who take a longer time to make changes.<\/p>\n


DB-Engines Overview<\/h2>\n

Great site to show what database engines are being used. Now owned by Redgate.<\/p>\n

https:\/\/db-engines.com\/<\/a><\/p>\n

Flyway<\/h2>\n

Supports over 50 different types of database platform EVEN in the community version, not including Cassandra and others.<\/p>\n

Redgate Monitor<\/h2>\n

2024 we added Deeper PostgreSQL functionality Also includes Cassandra, Clickhouse and Data Bricks!<\/p>\n

In 2025,will be able to be deployed completely on Linux on Oracle and PostgreSQL (Timescale)<\/p>\n

<\/p>\n

Test Data Manager<\/h2>\n

PII Masking, optimizing test data with smart sub setting. Powers DevOps with ephemeral<\/a> instances (I had to look it up too!)<\/p>\n

Back to the Messy Middle<\/em><\/p>\n

Mostly cloud, 2023 -2024 less people are Mostly Cloud or ALL Cloud. All on-premises increased as well.<\/p>\n

<\/p>\n

Theory is that there are maybe large systems that need the control and management to deal with the huge requirements.<\/p>\n

Other cases were probably costs by not understanding the costs, and not creating the applications for the cloud in the first place. So some regression may have occurred.<\/p>\n

Announcement: Redgate products Flyway, Monitor, and Test Data Manager<\/h2>\n

Now available from the cloud marketplaces!<\/p>\n

<\/p>\n

Single biggest challenge we face<\/h2>\n

<\/p>\n

Graham asks the audience, how they feel that each of these is holding them back:<\/p>\n

    \n
  • Security: Did not get a lot of hands<\/li>\n
  • Skillset: a few<\/li>\n
  • Data Integration: Biggest set of hands.<\/li>\n
  • Monitoring: a few<\/li>\n<\/ul>\n

    Biggest was skillset concerns in the survey. Of course we are all at a conference, so it is less of an issue here. There were several people who did say they were here on PTO<\/p>\n

    The survey said\u2026<\/p>\n

      \n
    • Security: 36%<\/li>\n
    • Skillset: 53%<\/li>\n
    • Data Integration: 49%<\/li>\n
    • Monitoring and troubleshooting: 43%<\/li>\n<\/ul>\n

      Kellyn leaves the stage. James Henson, Senior Product Manager at Redgate, enters.<\/em><\/p>\n

      \"A<\/p>\n

      Be Secure<\/h2>\n

      36% of people said security stops multi-platform adoption. People can\u2019t use the new innovations because of security concerns.<\/p>\n

      Redgate Monitor Enterprise helps with some of these things. For example, lots of questions about who can do what with your data. Who has admin access, etc.<\/p>\n

      Demo: Redgate Monitor<\/h2>\n

      \"A<\/p>\n

      User Permissions<\/h3>\n

      You can see who has access to what. Sees what Graham has access to. Too much. Benefits of being the CTO \ud83d\ude0a<\/p>\n

      Having this information gives you streamlines visibility to make sure you have proper security.<\/p>\n

      Enabling innovation with AI<\/h3>\n

      AI delivers improved productivity\u2026 educing time on DB deployment, amplify the signal in the noise.<\/p>\n

      Dynamic alerting<\/h3>\n

      Demo showing that you can set alerts to a threshold in Test Data Manager, so you don\u2019t get alerts that are normal at one time but concerning later.<\/p>\n

      <\/p>\n

      Need for collaboration<\/h3>\n

      Operations feel that change is risk, devs want to keep changing. But there is this feeling that devs are throwing stuff at DBAs. DevOps is supposed to bring these teams together<\/p>\n

      Test Data Manager\/AI powered Test Data Generation<\/h3>\n

      Shows how you can generate test data that is both fake and realistic enough. This machine learning models are run only on your environments<\/p>\n

      Rules based data gen where you give the tool rules and data sets, and you can integrate with AI to generate the edge sets.<\/p>\n

      Data looks real, and your data stays yours and is not sent out.<\/p>\n

      If you want to know more, scan here!<\/p>\n

      James Henson leaves the stage<\/em><\/p>\n

      What are you going to do next!<\/p>\n

      When you get back to the office, ideally you will Monitor, Automate, and Protect:<\/p>\n

      \"A<\/p>\n

      Ideally using Redgate tools, naturally!<\/p>\n

      Closing<\/h2>\n

      \"A<\/p>\n

      Arne and Annabel return to the stage<\/em><\/p>\n

      Thank you to all of the speakers this morning!<\/em><\/p>\n

      \"A<\/p>\n

      Pass Summit is back here in November 17-21<\/p>\n

      NEW FOR 2025, smaller PASS branded events in NYC, Dallas and Amsterdam coming up!<\/p>\n

      \"A<\/p>\n

      Probably too late if you are reading blog, but at the booth they had this adorable stuff stuffed aardvark you could win to commemorate our first product that was called \u201cAardvark\u201d, this to commemorate that Redgate has been around for 25 years now!<\/p>\n

      \"A<\/p>\n

      Thank you!<\/p>\n\n\n

      <\/p>\n\n\n\n

      <\/p>\n\n\n\n

      Big thanks to Scott Stauffer and Rodney Kidd for their help with the text, pictures, etc!<\/p>\n","protected":false},"excerpt":{"rendered":"

      \u00a0 Time to start! Annabel Bradford (Head of Events at Redgate) comes out on stage. Intro Annabel takes the stage and for me she is the face of Redgate at PASS, what better person to kick off the Redgate Keynote! Annabel has been a Redgater for 15 years and is the \u201cHead of Events\u201d at……<\/p>\n","protected":false},"author":59127,"featured_media":104494,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[159205],"tags":[],"coauthors":[7590],"class_list":["post-104457","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-conferences"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/104457","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\/59127"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=104457"}],"version-history":[{"count":4,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/104457\/revisions"}],"predecessor-version":[{"id":104542,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/104457\/revisions\/104542"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media\/104494"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=104457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=104457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=104457"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=104457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}