Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Archive for September 22nd, 2012

Installing SQL Server 2012 SP1 CTP4 Experience

Posted by denglishbi on September 22, 2012

A standalone version of the SQL Server 2012 SP1 was released this week.  It is not the final release, just a community technology preview (CTP4), but a release that we can test out none the less.  The exciting part of this release to me are the enhancements that have been added to Power View.  Here you will see the steps I went through to upgrade my evaluation virtual machine I have setup that is based on the Appendix B that comes with our book – Visualizing Data with Microsoft Power View.

First you will need to download the SQL Server 2012 SP1 CTP and you can do that from here – SQL Server 2012 SP1 CTP (there is even a full SQL 2012 slipstream version you can download as well that includes the service pack).  You also might want to download some of the additional features that are provided with the feature pack and you can get that from here – Microsoft® SQL Server® 2012 SP1 Community Technology Preview Feature Pack.

Once you have the service pack downloaded you can run this on your machine and follow through the screenshots below.
 

image

image

image

image

image

I had one item that I needed to shutdown so that I could avoid a restart after I installed the service pack and that was related to IIS services (these are running because of SharePoint 2010).

image

So I had to stop the IIS Admin Service and the World Wide Wed Publishing Service.

image

I did a refresh check and I was good to go.

image

Running RTM Evaluation Edition – 11.0.2100.60

image

Updating the default instance of SQL 2012

image

Updating 2nd instance of SQL 2012 (POWERPIVOT)

image

Instance MSSQLSERVER overall summary:
  Final result:                  Passed
  Exit code (Decimal):           0
  Start time:                    2012-09-22 08:15:42
  End time:                      2012-09-22 08:33:33
  Requested action:              Patch

Instance POWERPIVOT overall summary:
  Final result:                  Passed
  Exit code (Decimal):           0
  Start time:                    2012-09-22 08:33:57
  End time:                      2012-09-22 08:35:24
  Requested action:              Patch

Patch Level: 11.1.2845.0

image

Verify I can connect to my instances of the database engine and Analysis Services along with reviewing the build numbers.

Microsoft SQL Server 2012 – 11.0.2845.0 (X64)
    Sep  1 2012 02:36:04
    Copyright (c) Microsoft Corporation
    Enterprise Evaluation Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Now to go start into SharePoint and check out Power View!

image

New Ribbon layouts, icons, and features (images, hyperlinks, field list control)

image

More style, text, and background options

image

New visualizations – Pie and Map charts along with font sizes

image

Pie Charts, but no data labels or sorting options.

image

Bing geo-encoded maps

image

Pre-defined drill up/down capabilities

image

Support to restore Excel 2013 PowerPivot files in Tabular SSAS

image

SQL Saturday #149 is coming up next:)

image

SharePoint 2010 will not support the Power View that is in Excel 2013 files.

image

I noticed that my PowerPivot was not working yet, so need to run the PowerPivot Configuration Tool.

image

image

New version detected, time to upgrade.

image

Run the upgrade process.

image

After this is done we go back in and test out PowerPivot again

image

Now it works just fine.  The one thing I noticed is that it doesn’t appear to be working with the Excel 2013 PowerPivot files though.

image

Maybe these will not work in SharePoint 2010, not quite sure yet, will need to look into this more.

For more information on the new features available in the updated version of Power View check out some of these references:

Here are some more links for information on the SP1 updates:

This service pack also includes performance improvements with slicers and filters with PowerPivot and Tabular SSAS as well as I demoed here in this post and video – Excel PowerPivot SQL 2012 vs. Excel 2013 Performance Demo.

Now we just need to wait for the final release and hopefully that will be coming out in a couple of months now, should be very soon. Enjoy!

Posted in SQL Server | Tagged: , | 23 Comments »

 
Follow

Get every new post delivered to your Inbox.

Join 93 other followers