Click here to Skip to main content
15,868,016 members

The Weird and The Wonderful

   

The Weird and The Wonderful forum is a place to post Coding Horrors, Worst Practices, and the occasional flash of brilliance.

We all come across code that simply boggles the mind. Lazy kludges, embarrassing mistakes, horrid workarounds and developers just not quite getting it. And then somedays we come across - or write - the truly sublime.

Post your Best, your worst, and your most interesting. But please - no programming questions . This forum is purely for amusement and discussions on code snippets. All actual programming questions will be removed.

 
GeneralRe: Production reports from a test database - is this really best practice? Pin
JohnLBevan9-Mar-16 0:14
professionalJohnLBevan9-Mar-16 0:14 
GeneralRe: Production reports from a test database - is this really best practice? Pin
johnsyd9-Mar-16 2:53
johnsyd9-Mar-16 2:53 
GeneralRe: Production reports from a test database - is this really best practice? Pin
Harrison Pratt9-Mar-16 1:58
professionalHarrison Pratt9-Mar-16 1:58 
GeneralRe: Production reports from a test database - is this really best practice? Pin
mbb019-Mar-16 2:58
mbb019-Mar-16 2:58 
GeneralRe: Production reports from a test database - is this really best practice? Pin
Gerry Schmitz9-Mar-16 5:07
mveGerry Schmitz9-Mar-16 5:07 
GeneralRe: Production reports from a test database - is this really best practice? Pin
Adroittech9-Mar-16 18:00
professionalAdroittech9-Mar-16 18:00 
GeneralRe: Production reports from a test database - is this really best practice? Pin
rajni k9-Mar-16 19:01
professionalrajni k9-Mar-16 19:01 
GeneralRe: Production reports from a test database - is this really best practice? Pin
PIEBALDconsult10-Mar-16 5:59
mvePIEBALDconsult10-Mar-16 5:59 
Not a good practice.

Yet where I am now, we're doing something potentially worse. Because (as in your case) deployment of code changes takes a while, and the report is "Very Important! It goes all the way up to the CIO!", the report developers argued that in order to provide the most accurate numbers, it has to be run against the most up-to-date code -- and that means running the production report on the DEV database* Sigh | :sigh: . So while I'm trying to improve the quality of the data I provide to the reporting team they keep complaining that the data is changing while they try to run the report -- of course it's changing! It's DEV!

So they want to run in DEV so they can receive changes in the data quickly, but they don't want the data to change. I'm reminded of the line from "The Twelve Chairs" -- "Hurry home, but don't gallop." Sniff | :^)

To make matters worse; I suspect that the reporting team is now referring to DEV as PROD! OMG | :OMG:


* This is basically just a warehouse of data that has been ETLed from other databases within the enterprise.


<kvetch>
Oh, and I forgot the latest wrinkle -- my ETLs fill staging, then someone else reads staging to populate a Data Vault, then someone else reads that to populate a cube -- and lastly a report is run. And now the reporting team wants me to tell them every change I make that will impact their report -- I have no idea what their report entails, I have no idea what parts of the cube are involved, I have no idea what parts of the Data Vault the cube uses, I have no idea what parts of staging go where in the Data Vault, yet I'm supposed to know exactly how this data is used three levels downstream of me?! I don't even know what most of the data in staging means; I just copy it from other places. And, get this, they want me to tell them this so they don't have to waste their time investigating fluctuations they spot in the report. WTF | :WTF:

I'm so glad I'm on vacation this week.
</kvetch>
GeneralPowered by OSCommerce Pin
PIEBALDconsult2-Mar-16 17:02
mvePIEBALDconsult2-Mar-16 17:02 
GeneralRe: Powered by OSCommerce Pin
RUs1232-Mar-16 22:31
RUs1232-Mar-16 22:31 
GeneralRe: Powered by OSCommerce Pin
Bernhard Hiller3-Mar-16 21:10
Bernhard Hiller3-Mar-16 21:10 
GeneralRe: Powered by OSCommerce Pin
brunoha9-Mar-16 9:14
brunoha9-Mar-16 9:14 
GeneralOh, that ol' Cthulhu sure is sneaky... Pin
PIEBALDconsult17-Feb-16 10:42
mvePIEBALDconsult17-Feb-16 10:42 
GeneralRe: Oh, that ol' Cthulhu sure is sneaky... Pin
Brisingr Aerowing17-Feb-16 13:10
professionalBrisingr Aerowing17-Feb-16 13:10 
GeneralRe: Oh, that ol' Cthulhu sure is sneaky... Pin
Chris Maunder17-Feb-16 15:43
cofounderChris Maunder17-Feb-16 15:43 
GeneralRe: Oh, that ol' Cthulhu sure is sneaky... Pin
Brisingr Aerowing18-Feb-16 17:46
professionalBrisingr Aerowing18-Feb-16 17:46 
GeneralRe: Oh, that ol' Cthulhu sure is sneaky... Pin
PIEBALDconsult26-Feb-16 8:19
mvePIEBALDconsult26-Feb-16 8:19 
GeneralRe: Oh, that ol' Cthulhu sure is sneaky... Pin
Brisingr Aerowing26-Feb-16 18:06
professionalBrisingr Aerowing26-Feb-16 18:06 
GeneralRe: Oh, that ol' Cthulhu sure is sneaky... Pin
Chris Maunder17-Feb-16 15:45
cofounderChris Maunder17-Feb-16 15:45 
GeneralRe: Oh, that ol' Cthulhu sure is sneaky... Pin
V.17-Feb-16 19:53
professionalV.17-Feb-16 19:53 
GeneralRe: Oh, that ol' Cthulhu sure is sneaky... Pin
Middle Manager22-Feb-16 2:59
Middle Manager22-Feb-16 2:59 
GeneralRe: Oh, that ol' Cthulhu sure is sneaky... Pin
OriginalGriff18-Feb-16 4:13
mveOriginalGriff18-Feb-16 4:13 
GeneralIs this bad? Pin
James_Parsons17-Feb-16 2:07
James_Parsons17-Feb-16 2:07 
GeneralRe: Is this bad? Pin
Tim Carmichael17-Feb-16 2:31
Tim Carmichael17-Feb-16 2:31 
GeneralRe: Is this bad? Pin
Nish Nishant17-Feb-16 3:13
sitebuilderNish Nishant17-Feb-16 3:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.