The Heap™ – Consultancy ©® - 2014-09-16 (page 2 of 2)

« first day (1351 days earlier) ← previous day next day → last day (3518 days later) »

James

9:01 PM

(And then got mis-extrapolated to other RDBMS)

swasheck

@James did you ever get out of RS?

James

@swasheck Yep, I've been working for Gazprom for about a year now

swasheck

@James nice

like it?

James

@swasheck Well the money is better and I'm not working with the Jigsaw Puzzle Data Warehouse from Hell anymore

It is a bit boring, at worst!

It took me a while to get used to the way 'real companies' do things: release management, change management bureaucracy, dev/QA/UAT/preprod environments, devs who actually check their code into source control, etc

swasheck

9:17 PM

that's so funny. you're really making sound like the other place would not be a good investment for workloads.

James

@swasheck BI/reporting is sort of a forgotten dusty corner of the company. I wouldn't let what I say colour your opinion of their hosting services, some of which are actually very good.

swasheck

@James fortunately we dont have to use them

James

@swasheck Same here. Though we are looking at Azure for some cloudy stuff.

billinkc

9:38 PM

I have never seen someone mix lead and trailing commas in a single query. I have no idea how people can care so little about the format of their code

swasheck

that's me, @billinkc. i really dont care as long as it gets results. of course, most of my queries are one-offs for my own use.

billinkc

Disposable is forgivable. But a stored proc (or tvf). It's not just you. In fact, it's never you. It's the people that come after you. You don't want them coming after you. Leave it better than you found it

swasheck

i think i've written one stored proc that we actually use. and yeah, i cared about the formatting then

James

It hurts my brains to look at malformed SQL. I think sometimes I spend more time on formatting than getting the functional requirements right. :/

billinkc

swasheck

9:45 PM

oh now that's bad news

billinkc

it's like people that pee on toilet seats

James

The nice thing about inconsistently formatted bad code is that you know you aren't dealing with an ORM.

billinkc

There is that

swasheck

@billinkc how is it like that?

billinkc

@swasheck People only care about the fact that they've got to get their business done. No thought for those that come after them

Take a millisecond to aim or sit down or even clean up after you notice that you've made a mess makes all the difference in the world

Maybe I'm just projecting about a 5 year old...

swasheck

9:49 PM

i see

billinkc

I could probably stretch it to use the broken window analogy from law enforcement. If you don't take care of your code base, you get a crappy product

ypercube

10:25 PM

@James That gives me a rather fool idea.

James

@ypercube Oh?

ypercube

(write an ORM that produces such crazy formatted code.)

James

Haha.

ypercube

10:43 PM

Inconsistent behaviour by programs is fun.

I think there was a SciAm article some 25 years ago about how to write a program that guesses a user random input. The user was prompted to (randomly) choose between 4 options (A,B,C,D) and the program was trying to predict.
The result was quite good, giving 40%, sometimes even 50% - way above the expected 25%.

Of course that only proves that humans cannot easily output random strings.

Master Database

11:04 PM

Q: Is question about improving database design on topic?

I was working on a creation of Informational System and had to create database that held large amount of data, with GUI that was responsible for edition/insertion/report building... Database was created using MS Access 2007. I would like to post a question seeking help to possibly reduce the num...