May 8, 2017 | Data Warehousing, Featured, SQL Server, Technical Information
By: Ken Adams Senior BI Consultant at Key2 Consulting As was mentioned in a previous blog post comparing the pros and cons of Microsoft Azure SQL Database versus SQL Data Warehouse, Microsoft announced at SQL PASS 2016 that they are offering a free, 1-month...
Feb 27, 2017 | Data Warehousing, Featured, SQL Server, Technical Information
By: Ken Adams Sr. Business Intelligence Consultant at Key2 Consulting A junk dimension is seen occasionally inside of data warehouses. This type of dimension can be thought of as a flag table, or a collection of attributes that have low-cardinality. This...
Jan 10, 2017 | Azure, Cloud Technology, Data Warehousing, SQL Server
By: Ken Adams Have you wondered what the difference is between Azure SQL Database and Azure SQL Data Warehouse? In this post we’re going to highlight the key differences between the two Microsoft product offerings and point out what you need to know....
Dec 21, 2016 | Business Intelligence, Data Warehousing, Featured
Are we getting the most out of our data warehouse? If you’ve ever asked yourself that question as an executive, IT manager, or business owner, you’re not alone. We know there are many Data Warehouse/Business Intelligence (DW/BI) solutions that have fallen...
