Archive for the 'Perspectives' Category

PowerPivot Technical Architecture Diagram Released: Security Architecture

Because PowerPivot for Excel and PowerPivot for SharePoint involves so many components from SQL Server 2008 R2 Analysis Services, Office 2010, and SharePoint 2010, this poster provides an end-to-end view of the PowerPivot Security Architecture in one view.  This view includes nearly all of the logical security surface areas and illustrates how these systems interact.

Included in this diagram are:

  • Service Accounts
  • SharePoint Databases
  • Security Hardening
  • Automatic Data Refresh
  • User Identity Flow
  • PowerPivot Permissions Levels

Please click through to continue reading: PowerPivot Technical Architecture Diagram

PowerPivot, you are so insensitive! (case that is)

June 18, 2010 by dennyglee

Working with my compatriots Ayad Shammout (@aashammout) and Peter Myers, we had found out that PowerPivot at times can be really insensitive…in terms of case that is.  That is by default, the collation for PowerPivot is case-insensitive.

For example, if you import the table below:

Continue reading: PowerPivot, you are so insensitive! (case that is)

PowerPivotGeek’s Tips, How-to, and A Peek Inside!

PowerPivotGeek has been doing a lot of GREAT posts the last week and its getting harder and harder to keep up with greatness!  Saying this, here are some great tips, how-to, and A Peek Inside!

Tips!

 

How-To

 

A Peek Inside!

Enjoy!

Now that PowerPivot has RTM…

As per many blog postings, press releases, tweets, messages, and streams – PowerPivot went RTM on the 5/12.  So what can or should we do now?  Here’s some quick great blog postings to get yourself up and running on PowerPivot ASAP:

Enjoy!!

    TechEd NorthAmerica 2010 Sessions

    For a listing of PowerPivotGeek’s PowerPivot sessions at TechEd North America 2010 (also known as the BI Conference 2010), check out:

    TechEd NorthAmerica 2010 Sessions.

    One thing that is missing from this list is also the joint session between Rob Collie (@PowerPivotPro) and Dave Wickert whom will do a PowerPivot power chalk talk.  If you’re in New Orleans for the BI Conf / TechEd NA and into PowerPivot – these are your sessions!

    PowerPivot Technical Diagram: PowerPivot Client/Server Architecture

    Because PowerPivot for Excel and PowerPivot for SharePoint involve many components from SQL Server 2008 R2 Analysis Services, Office 2010, and SharePoint 2010, this poster contains all of the key components that make up PowerPivot in one view. This view includes nearly all of the logical architecture components and illustrates how these componets work together.

    Included in this diagram are the components for:

    • PowerPivot for Excel
    • PowerPivot for SharePoint
    • Browser-Based Clients and their connection to PowerPivot
    • Data Import and Data Providers in relation to PowerPivot
    • Analysis Services Clients and their ability to connect to PowerPivot
    • Timer Jobs, Health and Usage Data Collection in relation to PowerPivot

    For more information, please go to the reference sqlcat.com site: PowerPivot Technical Diagram: PowerPivot Client/Server Architecture

    Memory Considerations in PowerPivot

    By powerpivotgeek (dwickert@microsoft.com), on February 3rd, 2010

    In scanning through some recent discussions on the PowerPivot forums, I noticed this very nice posting by Marco Russo (http://sqlblog.com/blogs/marco_russo/archive/2010/01/26/memory-considerations-about-powerpivot-for-excel.aspx) . I strongly recommend it.

    The only additional point I would like to make is that the RTM version of PowerPivot has an additional check on the in-memory database when saving to disk.

    Read more…


    Denny Lee’s Tweets (1/2 of PowerPivot Twins!)

    Copyright

    Copyright © 2010 Denny G Lee - All Rights Reserved