@ypercube sorry did not understand you

good morning

> If you are trying to follow standard SQL, you cannot use expressions in GROUP BY clauses

Wow. Is that true?

But then it would've been a big blunder for a public article like that if that were false, so must be true.

Still, wow

good morning

Morning

Is asking for reviews of a db schema on or off topic here?

it's very disruptive (for the countinuous stream of bollocks)

but the topic of the room is 'General ... discussion ...'

I guess nothing is offtopic ;)

Oh, I was thinking of as a question on the site

I've been wondering where such a question belongs; DBA or CR. CR Doesn't really want it, but I don't know how this site feels about reviews

It should be all right. Would be great if it wasn't along the lines of "I have this schema: (huge picture) What do you think?"

if it is for collecting opinions, post it here when most of the regulars are already up

Well, my question (if it were me) Would be "I have this schema post schema and I'm trying to achieve 3NF, but I'm uncertain if I have succeeded. What could I improve to achieve 3NF? Other reviews on how to improve this schema are most welcome!"

@Gemtastic If you want to ask about normal forms, it's better if you include functional dependencies.

or a description (every customer can have many orders, an order belongs to a single customer, etc...)

I can do that to flesh it out. Do I have to write it as SQL or would it be fine to write it like this:

**Table**
#######
Id        - Primary key not null
name   - String/text not null
thingy  - String/text
isThing - boolean not null

Well that formatting sucked >_>

@Gemtastic either is fine I think

Thanks. :)

and have some real names on the tables and columns.

One last question: Is this something you'd want others to refer to this site about?

(Or is it more of a "we'll allow it but won't encourage it" kinda thing?)

good and ontopic (answerable) questions are always encouraged, I think

Great :)

Morning all

mornin'

Morning

afternoon!

@dezso O!, ye of central european time.

@ConcernedOfTunbridgeWells I carefully waited until noon

Good old central European time.

NotepadCrypt has awesome documentation

@JackDouglas nice!

My laptop was stolen last week, by the way

ouch

and I was not using any Crypt apps

on the company machines the hard disks are encrypted

(not sure if all of them, but should be so)

@dezso I hope they are set to hibernate when the lids are closed rather than sleep

depends

the ubuntu boxes normally lock their screen

the ttys are still available (hardly ever used) in this state

@ypercube Yours or your employer's?

mine

@ypercube Pity.

You might save a few bob if you replace it with an ex-lease one off Ebay.

(couldn't resist, but I would still recommend looking at the option)

For example, ebay.co.uk/itm/…

@ConcernedOfTunbridgeWells looks good

@ypercube Pick a suitable model of 1-2 generations ago and do a search on Ebay for it. You'll get best results for ones that are widely used on the corporate lease market - e.g. Thinkpads, Dell E64x0 series.

If you need to, get one with a spinny and buy a third party SSD for it. There's an application on Intel's web site that will clone a disk image onto a SSD.

downloadcenter.intel.com/download/19324/…

Thinkpads, in particular, can also take a mSATA SSD like an Intel 525 or 530

ebay.co.uk/sch/i.html?_nkw=intel+525+ssd&_sacat=0

ebay.co.uk/sch/i.html?_nkw=intel+530+msata&_sacat=0

Intel 525s and 530s on Ebay respectively. Some Dell systems will take mSATA SSDs as well.

That lets you migrate the operating system onto the mSATA SSD and keep data on the spinny that came with the system.

Protip - when looking for ex-lease laptops, keep an eye on the screen resolution of the listing. It's not easy to replace the screen, so make sure you get one with the screen resolution you're after.

@ypercube How did someone steal it?

@JamesLupolt the day I went to the postgres conference. We went to a pub after the event, and I forgot it when we moved from the pub to a nearby reastaurant

10-15 minutes later, I returned back but it was gone.

We were standing outside, so someone passed by and just took it.

Sorry. Glad to hear you weren't mugged.

No, it was mu fault. I blame the beers

@JackDouglas now you made me losing an hour trying to secure my machine a bit more

I disabled ttys by default, I will start them up manually when I need them (once in every two years)

@dezso you'll thank me next time you leave your laptop in a pub :S

I will star this

@dezso they still need to hibernate rather than lock screen though - have you changed that too?

@ypercube it's not really a joking matter, sorry

you must be gutted

hopefully it was a few years old?

@JackDouglas the default config tool does not even offer a possibility for hibernating

BTW, how do you get around the screen lock?

@JackDouglas No worries, I like jokes ;)

It wasn't old, I bought it last year but it was cheap, not the latest model, around 300-350 pounds.

@dezso one way uses firewire

I'm not saying I could do it, but I think if you are paranoid enough for FDE, it's probably a sensible trade-off

even hibernate isn't necessarily safe

also: zdnet.com/article/…

well, there is nothing that important on this machine

ATM I'm not sure which encryption we use but it's definitely not BitLocker

I don't know how Erwin gets to his hundred-year-old answers regularly, but the stubbornness of the OP amazes me

@Gemtastic did you, in the end, post your question?

I will when I get home

@dezso yeah. When you pile it up like that it takes ages to melt.

Got a new work laptop!

Only problem is it will be a few days before there is anything on the dang thing.

I busted the keyboard.

@billinkc / @Zane ... i have ... sigh an SSIS question for you

I r back

Was busy stuffing my face with sushi

hope that it was good

@billinkc I didn't think that there was that much sushi in existence

I have no witty retort. Too much vacationitis.

@swasheck Get your SSIS question sorted out?

May anyone help?

@billinkc just a question about handling XML

@swasheck Don't

@dzerow if it's a short question, ask here. If it's long and complex, add a question at the site: dba.stackexchange.com/questions/ask

But not many people are around this time of the day/night in this room usually.

Not so short I don't think... The approach this user made on this question "http://stackoverflow.com/questions/20078074/mysql-multi-level-category-structur‌​e" for the database structure works fine. However, thinking in a relational database approach, what is the best approach for a multi-level category database?

If you consider this too long, I will post there

Is there an arbitrary number of levels?

@dzerow Also check this: Models for hierarchical data. It will give you lots of options for modelling hierarchies, especially given the limitations of MySQL.

A few more votes will reopen this

assuming the group thinks it has improved sufficiently to be reopened

@ypercube No there isn't a specific number

@ypercube I will check, thanks very much for your help

@billinkc but srsly ... if i want to parse some xml ... is ssis worth the effort?

Simple XML, maybe. Complex. No

ok. so how would you propose etl of potentially complex xml documents?

In all honesty, that is a problem I have not had to address

okalydokaly

To define potentially complex XML, for me, would be things nested inside each other like <SalesHeader><SalesDetail /></SalesHeader> (etc)

right

You'd (likely) need to use a Script Component acting as your source which means all the parsing and such is going to be in .NET language of your choice. You'll then be spitting these entities into a dataflow but I assume I can't just shove all the Headers into a table and all the Detail as there's a relationship between the two and in proper fashion, the detail won't have a value linking to the Header because it's implied due to XML nesting/encapsulation

So you then have to do something like add an extra attribute into the Detail output to provide linkage back to the header or ... something else... Maybe flatten header and detail into a single wide row and then a custom proc to save it piecewise

hm. at that point it's easier for me to import the blob and parse using xquery

(Yes, that's an option too) But it's five o'clock and I'm on vacation tomorrow so I bid you all adieu

@swasheck gizmodo.com/the-shittiest-deals-of-amazon-prime-day-1717984690