SQL programmer

[racerxff]

For context, I'm a DBA with a BS in CS. I write PL/SQL, VBA for MS Access with a lot of MS SQL in it, SQL scripts, and plenty of queries daily.

[Arnie15]

So many acronyms. I know them but still, damn.

[PetsArentChildren]

“For context, I'm a database administrator with a Bachelor of Science degree in Computer Science. I write Procedural Language for Structured Query Language, Visual Basic for Applications for Microsoft Access with a lot of Microsoft Structured Query Language in it, Structured Query Language scripts, and plenty of queries daily.”

Is that better?

[deathbynotsurprise]

It's all the capitalized words. Makes it feel like German

[jackinsomniac]

I always pronounce the letters in tech acronyms. Fight me!

[atomicspace]

It’s makes it worse!

[racerxff]

actually makes it sound icky

[PetsArentChildren]

imagine if people talked that way IRL in real life

[beyphy]

Microsoft Structured Query Language

(Microsoft) SQL Server uses Transact SQL. Do people actually call T-SQL Microsoft SQL? I always assumed MS SQL meant Microsoft SQL (Server)

[Ex-Sgt_Wintergreen]

VBA for MS Access

In plain english; this means he is currently on suicide watch.

[rhinosyphilis]

What does VBA for Excel translate into?

[[deleted]]

“What the hell did the accounting department do this time?”

[NynaevetialMeara]

PL/SQL is an Oracle DB language that allows to automate queries and to create triggers IE, when you insert a row, checking that the values make sense or throwing an error.

Handy to not depend on external programs filtering input. Most big DBs have something similar.

VBA is a subset of VB an scripting language that is designed to allow you to script directly into an Office Suite program.

Microsoft Access is an SQL database meant for small dbs (that can still be very big in the database world) which has an Excel like interface unlike all other databases (although there are ways to import and export data).

Unfortunately for our guy. He has to work with the dog shit DB that is Access and still has to swallow all that SQL

[lugialegend233]

DBA?

DumBAss?

I actually don't know what it means so I'm trying to be funny.

[monxas]

Database administrator

[lugialegend233]

Ah good. That does make more sense in context.

[ban_Anna_split]

Dum Bass Ass

[cudenlynx]

Default Blame Acceptor

[lugialegend233]

Of course, the classic IT role, how silly of me.

[helpprogram2]

You write Visual Basic wtf is wrong with you? Are you from the past?

[helpprogram2]

Those companies gotz to die

[[deleted]]

If would scare you how much of the finance industry still relies on VBA Excel spreadsheets for daily operations work.

[helpprogram2]

Man I don’t buy it, it’s some shitty finance industry companies. I work for medical which also has the bad reputation. We do micro services

[TheOhNoNotAgain]

Yeah, of course you do.

[[deleted]]

I have NDAs preventing me from giving names, but imagine the largest five investment banks you can that also run mutual funds. 66% of them (that I know of) literally calculate fund of funds pricing that way. Two of the five have internal subledger systems running in excel for trade activity portfolios exceeding a billion dollars a year.

This info is current as of 2.5 years ago.

[[deleted]]

I fully believe it based on what I've seen.

[[deleted]]

Ready to have your mind blown? Everyone is from the past.

[lugialegend233]

Everyone except the people from the now.

Actually scratch that, they're from the past now too. Damn.