Memory is pretty cheap these days. My analytical "database" is the Microsoft Power BI VertiPaq engine, which is fast. My store is Azure Data Lake Storage (cheap, and unlimited size)....

In Microsoft Power BI, best practice is to separate Date and Time to make model size smaller. Optimizing High Cardinality Columns in VertiPaq - SQLBI https://www.sqlbi.com/articles/optimizing-high-cardinality-columns-in-vertipaq/

You need to have some Facts in your Fact table. DimAmount should be part of the Fact table called Amounts. So just merge that in there. Other than that I...

I'd try setting up a Profiler or ExtendedEvent session to detect what activities/queries are occurring at your memory spikes. Memory goes up during processing as copies of data are kept...

If you like Sharp's, also read Bernard Cornwall's The Fort. Read it cold, no previews. About a forgotten episode in the American Revolution. And Paul Revere.

Answer since 2010 is Excel PowerPivot, which let's you have millions of rows in Excel, makes it like a reporting database. Then Power Query in 2013, which gives you good...

My main machine is my desktop. Fast connections to internet and databases.  I use a laptop almost always to Remote Desktop Connection to my main desktop. Can use mouse, keys...

I agree with using command line and gitk for reviewing logs. That way you don't have to spend time learning a different GUI for each tool Visual Studio Code has...

I am impressed by the Microsoft Power Platform of Power BI, PowerApps, and Microsoft Flow. As an old grizzled VBA, Java, Ruby, Clojure, and Power BI (DAX) dev, I like...

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...