Feeds:
Posts
Comments

Archive for the ‘PowerPivot’ Category

PowerPivot Technical Diagram: PowerPivot Security Architecture

Posted in PowerPivot, tagged , on August 18, 2010 | Leave a Comment »

Just in case you didn’t already know, we just uploaded the PowerPivot Security Architecture technical diagram on to sqlcat.com / MSDN.  To get access to the PDF, XPS, and/or VSD files, please click through to: http://sqlcat.com/whitepapers/archive/2010/08/17/powerpivot-technical-diagram-powerpivot-security-architecture.aspx   Enjoy!

Read Full Post »

At TechReady and want a chance to get a PowerPivot Technical Diagram AND win a PowerPivot book?

Posted in PowerPivot, tagged , on July 28, 2010 | Leave a Comment »

Are you coming to TechReady and interested in getting yourself a PowerPivot Technical Diagram: PowerPivot Client/Server Architecture? Well, make sure to come to Dave Wickert and my session for a chance to get a printed copy of this awesome diagram!: BIN403: PowerPivot for SharePoint Power Hour…so powerful its 75min 7/30 10:30-11:45am, Sheraton Metro B You’ll [...]

Read Full Post »

PowerPivot, Analysis Services, and TechReady….and coffee!

Posted in Analysis Services, PowerPivot, tagged , on July 26, 2010 | Leave a Comment »

If you’re going to TechReady 11 at the Washington State Convention Center this week in warm, sunny Seattle – first of all, welcome to the Emerald City!  And if you’re a coffee snob like me (to give you background, not only am a long time Seattle resident so I pretty much breathe coffee – but [...]

Read Full Post »

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

Posted in PowerPivot, tagged , , , on June 18, 2010 | 11 Comments »

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: Within the PowerPivot window, you’ll notice that the lower case [...]

Read Full Post »

Microsoft PowerPivot for Excel and SharePoint

Posted in PowerPivot, tagged on June 6, 2010 | 1 Comment »

As you may already know from some of the tweets concerning #PowerPivot, the book Microsoft PowerPivot for Excel and SharePoint is now available at Amazon.com.  The book’s authors are Sivakumar Harinath, Ron Pihlgren, and Denny Guang-Yeu Lee (i.e. myself).  Siva and Ron are both long time (this is a good thing) testers with the Analysis [...]

Read Full Post »

Win a signed PowerPivot Architecture Technical Diagram at TechEd NA 2010

Posted in PowerPivot, tagged on June 4, 2010 | Leave a Comment »

There are many reasons to go to TechEd North America 2010 in New Orleans this year.  After all, it is THE event for developers and IT Professionals.  And if you want to know more about PowerPivot, here’s yet another reason why you need to go. There will be a raffle to win a signed copy [...]

Read Full Post »

Delegation, Claims, Active Directory….Again?! Frak!

Posted in PowerPivot, tagged , , , on May 23, 2010 | 1 Comment »

As you may have noted in my original posting Delegation, Claims, Active Directory…Oh My!…Aw Crap!, it quickly described how to solve issues surrounding the delegation of the claims token within an Active Directory environment.  In it I referenced Lee Graber’s excellent posting: The data connection uses Windows Authentication and user credentials could not be delegated. [...]

Read Full Post »

Hierarchies, Oh Hierarchies…where are thou? (in PowerPivot)

Posted in PowerPivot, tagged on May 12, 2010 | 7 Comments »

I had a great question from a customer concerning something weird happening with PowerPivot relationships.  In this example, we have two tables such as city and state. State Mapping Table City-State Mapping Table With the City-State mapping table, it is apparent that the cities of Boston, Quincy, Norwood belong to MA while Seattle and Redmond [...]

Read Full Post »

PowerPivot Technical Diagram: PowerPivot Client/Server Architecture

Posted in PowerPivot, tagged on April 28, 2010 | Leave a Comment »

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. [...]

Read Full Post »

Microsoft SQL Server 2008 R2 PowerPivot Planning and Deployment

Posted in PowerPivot, tagged on April 15, 2010 | Leave a Comment »

What’s great about the newly published “Microsoft SQL Server 2008 R2 PowerPivot Planning and Deployment” is that it is a guide that has the end-to-end architecture design of PowerPivot for Excel and PowerPivot for SharePoint including hardware requirements, topologies, and deployment planning. If you want to know more about PowerPivot Planning and Deployment – this [...]

Read Full Post »

« Newer Posts - Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 1,049 other followers