Viewing 15 posts - 1 through 15 (of 21 total)
Steve, thanks for all the blogs. SQLServerCentral is the first email I read in the mornings. I plan to do my first presentation this month, and to start a blog....
December 29, 2023 at 1:00 pm
XP and other processes developed in late 1990s. https://en.wikipedia.org/wiki/Extreme_programming . Kent Beck's books was published in 1999.
November 28, 2022 at 4:01 pm
I learned Git on the command line, and still prefer it. I hate having to learn how to use all of the different GUIs: GitHub, GitLab, DevOps. As you said,...
July 30, 2022 at 11:38 am
And to answer your question, I'd make the SharedTeamKey it's own dimension and link to both Sales and Payments.
You need a shared Date dimension as one of the conformed dimensions....
July 29, 2022 at 2:18 pm
From the man who "wrote the book" on Star Schema: http://blog.chrisadamson.com/2011/11/conformed-dimensions.html
And the Data Warehouse people: https://www.kimballgroup.com/2011/06/design-tip-135-conformed-dimensions-as-the-foundation-for-agile-data-warehousing/
For Microsoft Power BI types: https://guyinacube.com/2021/02/10/handling-multiple-fact-tables-in-power-bi/
July 29, 2022 at 2:15 pm
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)....
December 3, 2021 at 1:32 pm
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/
November 24, 2021 at 2:52 pm
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...
November 22, 2021 at 2:58 pm
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...
April 6, 2021 at 1:09 pm
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.
March 6, 2021 at 2:57 pm
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...
October 19, 2020 at 3:12 pm
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...
August 12, 2020 at 1:25 pm
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...
January 16, 2020 at 2:22 pm
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...
August 10, 2019 at 2:56 pm
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...
December 8, 2017 at 6:45 am
Viewing 15 posts - 1 through 15 (of 21 total)