I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from Whiteboard to Star Schema (quite the title) by Lawrence Corr and Jim Stagnitto. The book was recommended to my years ago by a former colleague (the book is from 2011, with the latest revision from 2014) and it has been sitting […]
Tag: data warehouse
Cool Stuff in Snowflake – Part 7: Creating Tables
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share. It might be some SQL function that I’d really like to be in SQL Server, it might be something else. In Snowflake, there are […]
T-SQL Tuesday #99 – Door #2
This months T-SQL Tuesday is hosted by Aaron Bertrand and the topic is Dealer’s Choice. Aaron gives us the choice to blog about a topic of our choice, either about a passion outside of the SQL Server community, or about a T-SQL bad habit. In this blog post, I’ll tackle the second option, but I […]
Reblog: Star Schema The Complete Reference – Review
SQLKover update: 1.5 year later, I still stand by my position: Star Schema The Complete Reference is the best book on dimensional modelling around. Recommended/obligatory reading! I finished my first book of this year and here’s the review! After I finished the newest edition of Ralph Kimball’s Data Warehouse Toolkit, a senior colleague of mine recommended […]