Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
-
This happens all to often. We put a self-preserving rule in, that the DBA will not touch DML for any reason whatsoever. That is the analyst and app team's responsibility. We'll make sure we have backup in order to pull you out of your pit, should you hork things up. A lot less stress since we've implemented that.
-
@iAmNaN oh trust me I've been working on getting something like that implemented. I'm not even a DBA, I just write the SQL scripts, load the data provided and make sure it's the correct format and send it off to the DBA as one of my many job functions, while I find a way to automate this crap without a budget, or any real resources. Management's excuse is the "data analysts" aren't technically inclined enough to follow strict procedures. Because copying and pasting plain text into a spreadsheet is way too tough.
-
@iAmNaN but who develops the data structures then?
-
@iAmNaN ok. Creating is one thing. What about modifying? How about things like splitting the name into first name and last name? What about fixing miscalculated revenue?
-
@apisarenco this rant is for a fortune 100 company that doesn't really develop its own software. We use 3rd party software that is licensed and we maintain as we use. But essentially the DBA's ensure that everything is safe, and always available and backed up all the time. Especially with health care and financial data.
-
@iAmNaN yeah, data manipulation. ETL. How else are you getting the data in and out?
But yeah, if it's a large corporation, it makes perfect sense that roles are so distributed that in order to get to a bathroom you have to submit a request 4 waterfalls ahead of the event.
Jesus, Apple are fucking amazing at design! A keyboard I need to prop up with a book and a mouse I can't use w...
If you're going to request CRITICAL changes to thousands of records in the database, and approve it through testing which is done on an exact replica of production, then tell me it was done incorrectly after the fact it has been implemented and you didn't actually review the changes made to the data or business logic that you requested then you are an idiot. Our staging environment is there to ensure all the changes are accurate you useless human. Its the data you provided, I didn't just magically pull it from thin air to make yours and my job a pain the ass.
undefined
stupid data analysts
this is why health insurance costs a buttload
do your job fuckface
idiots