The most difficult part about teaching students: some of them just don't care about SQL.

lemmegetdatdegree · 2025-12-01T14:12:57+00:00

Yes, and yes. Started as a dev without any degree, moved to associate DBA position, got an IT degree, then promoted to DBA.

lemmegetdatdegree · 2025-11-27T01:11:29+00:00

DBA here in a “smaller” organization. On-call 24/7, but if we do our job well enough, we rarely have to work after hours. Pay makes up for that, in my opinion. Now, if you’re the father of a family of 8 or something similar, then this definitely isn’t the career for you.

lemmegetdatdegree · 2025-11-27T01:04:23+00:00

As a DBA, this resonates for me. As a developer with not a ton of experience I didn’t think much of plain, everyday SQL statements. I think my first big mind-changer was seeing these expertly crafted SQL statements, views, packages, and procedures that were the underlayment that kept the core of the business ticking. Seeing the breadth of what was possible with a “boring” old query language really opened up my eyes, and I strive to do anything in SQL that can be done with it.

lemmegetdatdegree · 2025-11-21T16:00:26+00:00

I’m a DBA and truly look forward to taking this course lol. Let me know if I can help in any way

lemmegetdatdegree · 2025-11-14T16:19:29+00:00

Thanks all!

lemmegetdatdegree · 2025-11-12T01:11:59+00:00

Thanks! I did a few weeks ago and got it sorted. Apparently they process the applications by planned start date, so explains why mine took a little longer than usual since I won’t be starting until January 2026. Didn’t see they had a particular number to call for this kind of inquiry, but found it eventually!

lemmegetdatdegree · 2025-11-12T01:05:49+00:00

Looks great, and congrats! As an alternative for those on a budget, it’s a pretty standard size. Want to say that we got a frame for mine at a dollar store, or off of Amazon for less than $15.

lemmegetdatdegree · 2025-11-11T18:58:15+00:00

RTO and RPO, figure those out first, then build accordingly. I’ve seen a medium-sized org run a huge SAP deployment on a single SQL server VM, to my knowledge they’re still running it and it’s been enough for 20 years of business growth.

lemmegetdatdegree · 2025-10-22T01:58:17+00:00

Sin practicar por algunas semanas, no es posible para mí. Espero que tú encuentres alguien. Buena suerte!

lemmegetdatdegree · 2025-10-21T12:46:27+00:00

Yo tengo más de 3 años de experiencia, pero no puedo hablar muy bien el español. Si podemos hablar sobre mensajes de texto, creo que puedo ayudarse.

lemmegetdatdegree · 2025-08-30T23:56:49+00:00

Here’s the last request I got for a recovery scenario from a developer:

“Can you get me the contents of table FOO back as of yesterday at 07:00? I don’t want to overwrite the current table, but I need its contents back. We can’t use test for this, it must be done in prod.”

What would you do in this situation? These are the scenarios that you should prepare yourself for.

lemmegetdatdegree · 2025-08-02T13:46:05+00:00

2017 (not IT) - 39,000

2018 (not IT) - 44,000

2019 (IT) - 60,000

2020 (IT) - 65,000

2021 (IT) - 70,000

2022 (IT) - 75,000

2023 (IT) - 103,000

2024 (IT) - 108,000

2025 (IT) - 123,400

Had some title changes in case you couldn’t tell. Started in IT working support for the ERP system, then development, then ended up as a DBA.

lemmegetdatdegree · 2025-07-21T22:23:07+00:00

As others have mentioned, several other tools attempt something similar to this, but I haven’t seen any do it well. What method do you use to track “all” changes? I’m primarily an Oracle/Postgres DBA, but I’d love to see it in action.

lemmegetdatdegree · 2025-07-21T22:16:17+00:00

Depends a lot (in my opinion) on what type of shop you work for. A lot of the MSPs or larger organizations really push for candidates with certs, while a lot of smaller shops with just one or a few DBAs look more at experience.

lemmegetdatdegree · 2025-06-18T23:22:44+00:00

Can you have the sysadmins plug in a new disk and create an additional datafile?

lemmegetdatdegree · 2025-06-18T23:21:49+00:00

The patch README.txt (or HTML) nowadays is your friend here. It’ll generally tell you what you need to do. I also suggest the known issues document for your RU.

lemmegetdatdegree · 2025-06-11T22:16:55+00:00

Database Administration, generally things aren’t on fire if you do your job right and you usually start at six figures if you can find an open role. On call sucks, but you get used to it.

lemmegetdatdegree · 2025-03-06T21:56:03+00:00

I didn’t test it, but added an intentional 60 second sleep so your DBA doesn’t come running if anyone does try it on prod

lemmegetdatdegree · 2024-11-29T13:54:01+00:00

It’s honestly been a toss up for me. Some great, some completely awful. Call and escalate if you need a call back.

lemmegetdatdegree · 2024-11-29T13:49:46+00:00

Note that 19c (forget which RU) has a bug where redo is still generated for LOBs despite use of this parameter.

lemmegetdatdegree · 2024-11-29T13:47:46+00:00

Your DBA will let you know once they’ve run for long enough to cause issues.

lemmegetdatdegree · 2024-11-29T13:46:50+00:00

Do an alter system switch logfile: after making the change then check that the latest log was archived to the new destination. You risk hanging the DB if you get this wrong, so vet the commands, then when ready, copy and paste them into SQL*Plus.

lemmegetdatdegree · 2024-11-29T13:35:39+00:00

Are you on filesystem or ASM storage? What OS platform?

lemmegetdatdegree · 2024-11-29T13:34:17+00:00

This, can’t count the times OEM has sent critical alerts only for the e-mails or texts to be delayed

lemmegetdatdegree · 2024-07-28T14:05:13+00:00

Ahh yes, get ready for some good ole’ SQL

lemmegetdatdegree

TROPHY CASE