No Clustered Index
After seeing another SQL Server database this week without what I consider to be ‘the basics’, it got me to thinking what the basics are. In other words, what are the core fundamental practices we should follow every time we create a new database. The problem database that I saw this week had several tables [...]
The NFL’s Over Hyped Quarterbacks
The NFL and its fans have never had a wild devotion to statistics the way Baseball fans have. After watching the Super Bowl this past Sunday and seeing much of the playoffs leading up to the big game, I noticed more announcers use statistics to implore the greatness of a particular player. The comparison of the Quarterbacks [...]
8 Core Principles of Data Warehouse Design – #3 Transformation
Transformation isn’t clearly stated in the requirements gathering phase, but it must be derived by carefully analyzing the business requirements. Too many times I’ve seen data warehouses attempted without transformation. The data is often a denormalized mirror of the source data and this does not help your users at all. After you have modeled the [...]
Welcome to my blog! I write mostly about Business Intelligence. I'm speaking at SQL Rally in Dallas on May 10-11.
