For Business Intelligence purposes, Alberto Ferrari and Marco Russo (The Italians) suggest singular names like Customer for Dimension tables, and plural names like Sales for Fact tables.  Page 20 of...

I've had a 5 year old Nissan Leaf for a month now.  I share your range concerns. I've got a 60 mile range, which is enough to get to the...

I live in Kearney, Nebraska. Traveled to Denver in 2013 for SQL Saturday. I plan to go to the Lincoln, NE on in Nov. I'm willing to travel about 2-3...

Power Query is a no brainer, because everyone has to have clean data. Power Pivot is great also, but you need to be able to do VLOOKUP type joins between...

Power Pivot has replaced nearly everything I used to use Access for. Size doesn't matter, and you can use Excel like a 'real' database. Power Query does much of the...

Datomic (http://www.datomic.com)[/url] is an functional EAVT database that adds a Datalog logic query language, and separates query from storage, and well as allowing the ability to work with the database...

Datomic (http://www.datomic.com/) by Rich Hickey addresses many of your criticisims. It add Time to EAV (EAVT), so the state of the database is available as a value at any point...