In this episode I speak with James Rowland-Jones (JRJ), Principal Program Manager for Microsoft. He is passionate about delivering highly scalable solutions that are creative, simple and elegant in their design. James specializes in scale out data solutions such as Azure SQL Data Warehouse, Microsoft Analytics Platform System and Hadoop. JRJ is a keen advocate…
Talking Analytics Platform Services with Ashley Furniture’s Data Architect Phil Haddad, and Microsoft’s Principal Program Manager in the Azure SQL Data Warehouse team, Matt Usher. In this podcast we discuss: Refractoring an exising data warehouse Automating data warehouse development in an enterprise environment with 700 applications Migrating to Azure Data Warehouse from PDW/APS The role Microsoft Partners…
Join me for an enlightening conversation with Dr. Barry Devlin, regarded as one of the world’s leading authorities on business insight and data warehousing. He was responsible for the definition of IBM’s data warehouse architecture in the mid-1980s which in our view makes him the “Godfather” of the data warehouse . He is now founder…
While conventional wisdom (and Kimball) says that using meaningful identifiers for surrogate keys is a bad idea, there are some exceptions where it makes sense. Typical examples include: Calendar. An example of a Calendar smart key is – year, month, day e.g. 20110721. A DateTime value can be converted to this date format using this statement convert(char(8),date, 112)….
