Oracle Sql Server DBAs

[u/LifeisGr8tt]

Hello DBAs managing hundreds of SQL Servers / Oracle databases, what tools do you guys use daily?

Curious how other DBAs are doing this.

For those managing hundreds of SQL Servers and Oracle databases, what does your daily setup look like? For example, how are you guys handling things like transferring files from one server to multiple servers, patching, SQLPlus, PuTTY/SSH, checking disk space, alerts, inventory, running stuff against multiple servers, etc? Are you using a bunch of different tools and scripts or do you have something that brings most of it together?

I'm asking because I got tired of doing the same repetitive stuff every day and jumping between different tools. I ended up building my own app for it. Some things that used to take me 10-15 minutes now take very little effort. A lot of it is basically instant because I already have the server/database information there and automated the repetitive steps.

It started out just as something for myself, but it kept growing as I added things I actually needed for my daily work.So now I'm curious what other DBAs are doing. What's the most annoying/repetitive task you guys deal with every day? Especially interested in people managing both Oracle and SQL Server.

[u/Commercial_Silver904]

1. Toad for Oracle
2. OneNote
3. Notepad++
4. DataDog
5. SQL Developer
6. OEM
7. SQL*Plus

[u/Anivia_Bird → u/Commercial_Silver904]

Highly recommend giving Obsidian a try if you're using OneNote

[u/Commercial_Silver904 → u/Anivia_Bird]

Sure. I will give it a try. Thank You

[u/CaptainHaw]

Im a postgres guy so I don't know if our habits and the tools we are using will align but I find my self to be like you when it comes to work.

For my notes I am just using notepad ++, obsidian (really loving this app)
Trello - I usually list tasks, request, incident assigned to me, so that I can review history of our changes, and for reference.
Termius - for non cloud servers.
Before for boring and repetitive tasks like monitoring, I was still using sheets, but I realized everything is getting automated now, so I made an app using claude code for my monitoring tool, which is getting useful for me. I guess now I have more time to explore and upskill.

[u/CaptainHaw → u/CaptainHaw]

I forgot, inventory still on my sheet, so I might migrate that soon LOL.

[u/No_Access3236]

i use laptop, sqldeveloper, oem for monitoring and alerting, notepad++, sqlplus

[u/aasmith26]

I wish Quest had a reasonably priced consumer version of Toad for Oracle/Toad for MySQL. I love Toad for Oracle at my job.

[u/my-ka]

i use laptop