SSMS 2012 freezes when being launched

I just spent 30 minutes on SSMS which hanged on me every time I tried to launch it. I searched the Internet but couldn’t find a solution. The SMSS process was heavily using the CPU and slowing down the machine, but after the splash screen the SSMS application window wouldn’t appear. Then I downloaded Process…


Solving “You cannot activate the relationship because a set of active relationships already exists between tables…” in PowerPivot and tabular cubes

When you create relationships between tables in PowerPivot (or in a SSAS tabular cube), you may run into the following message: Below I’ll explain a way to solve this. By setting relationships in the designer you tell PowerPivot how the tables are related. This is important because that’s how PowerPivot knows how to slice and…


Should you use a data warehouse with a tabular cube?

With SQL Server 2012, Microsoft introduced SSAS “tabular mode”. Tabular mode essentially is a server-hosted version of PowerPivot. In fact, it’s very easy to take an Excel workbook with a PowerPivot model and import that to SSAS as a tabular cube. When you convert a PowerPivot model to a tabular cube, the new cube fetches…


Designing an ETL process with SSIS: two approaches to extracting and transforming data

On the Internet you find a lot of articles explaining the concepts like the data warehouse and ETL. There is also lots of information about products and tools such as SSIS. But, when I first starting building BI solutions, I was hardly able to find any architectural guidance for best practices for building BI solutions…