What Counts For a DBA: Ego

Leaving aside, for a second, Freud’s psychoanalytical definitions, the term “ego” generally refers to a person’s sense of self, and their self-esteem. In casual usage, however, it usually appears in the adjectival form, “egotistical” (most often followed by “jerk”). You don’t need to be a jerk to be a DBA; humility is important. However, ego is important too. A good DBA needs a certain degree of self-esteem…a belief and pride in what they can do better than anyone else can. The ideal DBA needs to be humble enough to admit when they are wrong but egotistical enough to know when they are right, and to stand up for that knowledge and make their voice heard.

In most organizations, the DBA team is seriously outnumbered by headstrong developers and clock driven managers, and “great” DBAs will often be outnumbered by…well…the not so great. In order to be heard in this environment, a DBA will not only need to be very skilled but will also need a healthy dose of ego. As Freud might have put it, the unconscious desire of the DBA (the id) is for iron-fist control over their databases, and code that runs in them. However, the ego moderates this desire, seeking to “satisfy the id in realistic ways that, in the long term, bring benefit rather than grief“. In other words, the ego understands the need to exert a measure of control and self-belief, but also to tolerate and play nicely with developers and other DBAs.

The trick, naturally, is learning how to be heard when it is important, but also to make everyone around you welcome that input, even when you have to be bold to make the “I know what I am talking about, and you…well…not so much” decisions.

Consider a baseball team, bottom of the ninth inning of the championship game, man on first and down one run. Almost anyone on that team will have the ability to hit a home run, but only one or two will have the iron belief that they can pull it off in this critical, end-game situation. The player you need in this situation is the one who has passionately gone the extra mile preparing for just this moment, is bursting at the seams with self-confidence, and can look the coach in the eye and state, boldly, “Put me in, I am your best bet“.

Likewise, on those occasions when high customer demand coincides with copious system errors, and panic is bubbling just beneath the surface, you don’t need the minimally qualified support person, armed with the “reboot and hope” technique (though that sometimes works!). You need the DBA who steps up and says, “Put me in” and has the skill and tenacity to back up those words and to fix the pinpoint and fix the problem, whatever it takes, while keeping customers and managers happy.

Of course, the egotistical DBA will happily spend hours telling you how great they are at their job, and how brilliantly they put out a previous fire, and this is no guarantee that they can deliver. However, if an otherwise-humble DBA looks you in the eye and says, “I can do it”, then hear them out. Sometimes, this burst of ego will be exactly what’s required.

Louis Davidson (@drsql)

Join the debate, and respond to the editorial on the forums

The insurance sector has seen a marked rise in mergers and acquisitions over the past 12 months, and although these can be an excellent way to leap beyond organic growth, M&As can result in challenges with technology. In this blog, COEO's James Boother provides some tips on how, with good planning, technologies can be a real advantage in your next acquisition.

We are excited to announce we are partnering with DORA and Google Cloud to bring you the State of DevOps Report 2021. The survey will be open from May 3rd until July 2nd. You can fill it out here, and please share with your teams and colleagues!

This statement can be the biggest hurdle in changing software development and deployment processes. So, the question comes up pretty frequently: How do you overcome it? Grant Fritchey explores techniques to understand and coach others towards change.

When comparing databases, save your standard options and filters to a single project file, and then use PowerShell to script them out to the command line. This allows you to reuse the same project file across multiple comparison operations.

How Redgate Deploy will help you ensure that databases and applications can grow and develop in step, and to implement a workflow for delivery of database changes that is resilient, repeatable, fast and visible.

The hype about machine learning (ML) is warranted. Machine learning is not just making things easier for the companies that are taking advantage of it. It’s also changing the...

Click to learn more about author Igor Tkach. There are very few subjects in technology and science that cause as much excitement and debate as artificial intelligence (AI). But...

Click to learn more about author Jitesh Ghai. The role of the chief data officer (CDO) has evolved more over the last decade than any of the C-suite. A...

Although clustered indexes are not required, and t...

I feel like I have had this discussion multiple ti...

When you’re not expecting it, database corruption is bad for your database server (and probably your own personal health). Database corruption can be fun though when you’re the one...

To be efficient and save money, many organizations are looking at hyperconverged infrastructures for SQL Server. In this article, Robert Sheldon explains what to consider for SQL Server and hyperconvergence.

Cosmos DB team announced a new way named Dedicated Gateway to connect to Azure Cosmos DB....

Reading Time: 2 minutes During Virtual SQL Saturday LA we got a well-timed question about GitHub and Azure Devops. We were asked if we thought GitHub and Azure...

This new feature was already being expected for a ...

It has been some time since I last wrote about Azure SQL Database. Although it has been more than three years since SQL Server 2017 was released, Microsoft have...

SQL Server Always On Availability Groups help you build a more highly available database server by spanning your database across two or more SQL Server instances. When the primary...

Contrary to what many believed prior to early 2020, we now know the concept of the home office actually works. This is one of the most important insights of...

A DBA asked if the Ola Hallengren SQL Server Maintenance Solution is adaptable to the AWS RDS environment READ MORE>> Author: Jack Vamvas...

The ability to scale up and down without maintaining extra hardware is one of the best cloud computing features. In this article, Mahendran Purushothaman explains autoscaling in Microsoft Azure.

A DBA asked how to view mount point disk space wit...

I was working on an ETL solution, which was expect...

SQL Server Always ON Availability Group is a solution meant to achieve high availability and disaster recovery for SQL Server databases. We can configure this functionality between the Windows-based...

New product announcements from Microsoft are starting to look a like what you expect from Apple. Sleek new virtual backgrounds, a strident tone, the use of the word “beautiful”...

As data volumes continue to increase, more developers look towards materialized views to process queries. This approach has a lot of potentials. We are discovering that apps and software...

In my previous article I kicked off a new series on latches by explain what they are, why they’re needed...

Well, Stop How many times have you seen something ...

Are you wanting to use Incremental Refresh in Powe...

Have you ever wanted to export a table from Power BI Desktop into Excel just to make sure the DAX you’ve written is performing as...

Recently I’ve been asked by colleagues with vari...

I was helping someone recently with an issue. They wanted to allow end users (department managers in this case) to enter data in a table as simply as possible,...

Power BI and Jupyter Notebooks are popular tools, but you may have never thought about using them together. Dennes Torres demonstrates how to do that and also asks why.

Last week, I shared my 300-Level Guide to Career Internals post & video. We talked about how the world is changing so quickly, and how it’s a great time...

I’ve been struggling with an author for a few mo...

Up until now, we have reviewed getting data out of...

This time we want to solve the following simple ta...

OLE DB Driver 18.6 for SQL Server is released, bri...

You’d be amazed (or maybe you wouldn’t) how often I hear this: “I used to be able to do xyz ... Continue reading The post Why are my permissions missing?...

Storage-device maker advises customers to unplug My Book Lives from the Internet ASAP.

Even as cybersecurity grows in importance as a national priority, individual states continue to push ahead with their own data breach legislation, making for an increasingly complicated compliance landscape...

Strategy for managing encryption keys should address whether to leverage "bring your own key" services.

This is part 11 of a 19 part series on TSQL Basics...

The LAG function in SQL Server allows you to work ...

This is part 10 of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and...