@gbn I rather thought that might be your views on the matter.
Morning all.
@DTest I had another random thought. It's probably cheaper to use SSDs and B.I. Edition on a server with ~1TB of data than to purchase Enterprise Edition. Chances are your hosting provider can furnish a system with SSDs on it.
I think SQL Server B.I. edition is a bit of a bargain in ways that MS never intended. Now you can actually put SSDs on a machine for less than the difference between the cost of BI ed and Enterprise ed.
Plus, if you're fronting your database with an OLAP serber, you've got partitioning on the cubes in B.I. edition and no limits on memory or CPU usage.
You can have 3 partitions in B.I. edition, so you can use re-partitioning for realtime data or archiving off old data.
And the database is limited to 'only' 64GB of RAM, 4 sockets and 16 cores in total. Oh, my first world problems.
@Gonsalu I think you're right. I thought you got 3 partitions on B.I. edition. Maybe I misread the article or there was an error that got fixed since I read it.
@Gonsalu No. Tabular semantic model will fix a limitation of SSAS though.
Actually a bigger argument for SSDs + B.I. ed. on 100GB-1TB size warehouses.
DAX is an expression language as opposed to a query language. Closer to the sort of thing supported by Business Objects or SSRS but embedded in PowerPivot or B.I. semantic model.
Looks like you can hop out of context and do stuff like 'percent of parent' or running sum type calculations.
@SimonRigharts Who, moi? <blushes> On one hand I could claim to have a corrupting influence, but working for any time in a pommy company is sufficient to achieve it without any help from me. After about 7.5 years here I can oh-too-readily relate to Simon Travaglia's misanthropism.
@ConcernedOfTunbridgeWells All in good fun. Besides, I'm pretty sure IT people everywhere think that the business side of the business isn't all that smart
@SimonRigharts I have. Ministry of Education, Ministry of Justice, Auckland District Health Board. Bureaucracy in private enterprise here in the UK is worse than government bureaucracy in New Zealand. God only knows what working for U.K. government clients is like.
@Phil I think the killer app of dba.se is to get database questions out from being lost in the noise on SO. However, they really need to get asked here in the first place under the new migration policies.
@Gonsalu Stack Exchange was having some issues with ClearBits, who was hosting the previous data dumps, so they're looking into providing it as an AWS Public Data Set. I'm not sure what the download options are in that case.
Ah, if you want up-to-date information in a more easily-consumable format, the Stack Exchange API should work for this
@JackDouglas Hmm, says that account has been registered for a while. Is other information in your profile accurate, besides your name?
@JackDouglas That's correct, waffles updates it on a (mostly) monthly basis from the live data. The API on the other hand is based on live information.
Other Data Explorer accounts, or other Stack Exchange accounts? In the latter case, Data Explorer is completely removed from the rest of the network, so it doesn't participate in information sharing with the other sites (I am contemplating optionally providing a sort of one-directional link now that the API supports authentication, though)
I typically stick around in rooms I've entered for a particular reason before, unless I really don't have an interest in being there. Plus, have to keep tabs on everything that's going on, to give the illusion of being in every room. ;)
@jcolebrand I'd happily do away with work for that first, actually. Well, all-consuming work anyway, obviously there's a pretty big financial investment that tends to go along with that. :P
Right, but no, I don't work for them. I just occasionally do things that some would consider work on my own accord. And what Cole mentioned, that one time. :P
@Phil On Linux I got quite a lot of mileage off YASQL and gvim - you can pipe query results to stuff from within YASQL. However, I don't think it's being maintained any more.
@BenBrocka Understand. The things I love about it: fast loading, even large files; mini filemap so you can see what section of the file you're viewing; highly configurable. Core is light, and you can add what plugins you want/need. Dislikes: file management is non-existant (can't move files around within the editor).
the biggest drawback, as i said, is the file listing/management...if they ever fix that and allow plugin integration into it (for sftp as example)...i'd do cartwheels
and make sure to video tape it and post to youtube for laughs
Can someone with 10k rep or appropriate permissions give me the source of my answer please so I can paste it into the SO version? I think I've made some edits to it since migration. Seem to remember Rory (the accepted answerer) had made some updates to their answer too.
@jcolebrand @MartinSmith Where is the SO version of that question? I thought when we migrated it back we'd get to see a link and automatic redirect from here to there for a few days.
This is partly subjective. So this is my opinion:
SQL has a pseudo-natural-language style. The inventors believed that they can create a language just like English and that database queries will be very simple. A terrible mistake. SQL is very hard to understand except in trivial cases.
SQL is d...
