Euler problem 2: By considering the terms in the Fibonacci sequence whose values do not exceed four million, find the sum of the even-valued terms. This is a sort of running sum problem that used to be hard (before T-SQL in SQL server 2012) I solved it with known math formula and recursion with common table expression. Tomas as usual solved with single-statement...

Me and colleague in my current Project Tomas Eriksson  decided to start to try the Project Euler problemes in Microsoft SQL Servers  Language Transact SQL (T-SQL). First problem was: Add all the natural numbers below one thousand that are multiples of 3 or 5. I made my solution hack back in 2008. It has some flaws. But I post it here to invite criticism. ( Yes I...

In the 90 the three objectoriented gurus came togehter and became the three amigos. They buried the war tools picked and out grew things like UML. Will the same happened to datawarehouse modeling? I can see three major streams in datawarehouse modeling. Kimballs Star Scheme afficionade with conformed dimension, Bill Inmon with Normalized tables and Dan L with the...