Wow, let all business units make their own cubes using PowerPivot and SSAS Tabular many worlds hopefully same data? No Microsoft did a great job, Our star schema cubes are good.  We can pull data using Normal Excel Pivot Table and MDX from the cube itself  We can also allow users access to the Multidimensional cube, datamart or relational database.

What we get with Tabular is the ability to empower the users to use data models as soon as OLTP changes are made. Using PowerPivot users can now work in excel and use SSAS, Oracle, SQL Server, MS Access, MYSQL… to pull in data into PowerPivot. They can create facts and measures using relational data models in PowerPivot.

Using Sharepoint 2010 users can share their PowerPivot Excel spreadsheet to other users. I can then convert the PowerPivot Spreadsheet to SQL 2012 Tabular and partition the data so each datasource  is processed daily, hourly..

The great thing is I can now partition dimensions and facts.

I will follow up with real time dimension and fact processing

SQL Server 2008 Reporting Services installs with a local certificate but I have been running into the issue where the bindings on the local Reporting Sericves SSL cannot be removed and I get error ”SSL binding already exists for the specified IP address and port combination” even after I have deleted the old binding.

I found this blog on Thinknook.com that describe the steps to manually remove. Ignore all the IIS stuff if you are using SQL 2008 and above.

Microsoft has released free e-books and its good stuff.

Introducing Windows Server 2012

Introducing Microsoft SQL Server 2012

Introducing Microsoft SQL Server 2008 R2

I have been going over a lot of content that would be fun to share but it all has to be generalized and sterilized and its out of date! I find that in my job field its hard to keep up with the latest technology. Just allowing projects to use the latest software without keeping a standard is a mess. I was happy to see that Microsoft has released Microsoft SQL Server 2012 and I am awed that I can see a Version on SQL in the same year that it was named!

I am using VMWare and Windows Server 2008 R2 and of course  SQL Server 2012

Have fun and I will share…