Current Events > As a DBA, sometimes I have to work nights and weekends.

(+) Yeah! (+)

Quarterly database patches sucks. Oh well, I'll use these hours as flex time.

Which program do you mainly use

Wow. Who cares?

I don't know what a DBA is do they feed penguins or something

CreekCo posted...

Which program do you mainly use

To do my patches? I was using Command Prompt but they want me to start using the Terminal console straight from the server now.

Wow. Thats pretty cool!

If I have a table with three columns, date, account number, and letter ID, how do find instances where two different letters were sent on the same account on the same day?

My SQL skills are basic and some part of me thinks this will involve subquerying but I havent figured it out yet.

AloneIBreak posted...

If I have a table with three columns, date, account number, and letter ID, how do find instances where two different letters were sent on the same account on the same day?

My SQL skills are basic and some part of me thinks this will involve subquerying but I havent figured it out yet.

I dunno. There's gotta be a log that shows you that stuff. You don't need to query that I don't think.

DBAs have always been very mystical to me. Almost as if you must be born a DBA because all DBA jobs require 10 years of DBA experience.

VeggetaX posted...

I dunno. There's gotta be a log that shows you that stuff. You don't need to query that I don't think.

If that exists, I dont have access to it, so I have to figure it out on my own.

TC do you manage the server and patches the DB runs on or is there a sysadmin guy who does that and you have to do QA afterwards during those maintenance windows?

Irony posted...

I don't know what a DBA is do they feed penguins or something

Database administrator

BlazinBlue88 posted...

TC do you manage the server and patches the DB runs on or is there a sysadmin guy who does that and you have to do QA afterwards during those maintenance windows?

Yes I have to manage the server updates/patches and the DB patches as well. After the patches are done I'll have to have the users make tests and see if everything goes well. These are Oracle DB patches hosted on Linux Redhat servers all on VMs. Our SYS-Admin let's us DBAs roam free. Course if we ask them to help us with odds and ends stuff with the servers they're nice enough to do it.

VeggetaX posted...

Yes I have to manage the server updates/patches and the DB patches as well. After the patches are done I'll have to have the users make tests and see if everything goes well. These are Oracle DB patches hosted on Linux Redhat servers all on VMs. Our SYS-Admin let's us DBAs roam free. Course if we ask them to help us with odds and ends stuff with the servers they're nice enough to do it.

Ah. At my company there's a separation between sysadmin and DBA responsibilities. I have access at the OS level and not within the DB. They are the other way around. The Eng dept makes us treat patches like a software release so we have proper release windows after hours with me, a DBA, and a couple devs testing different pieces.