Browse by Tags

Tagged Content List
  • Blog Post: Released: Kerberos Configuration Manager for SQL Server

    Kerberos Configuration Manager for SQL Server (KerberosConfigMgr) was released on May 15 th 2013, and is available for download at the Microsoft Download Center at http://www.microsoft.com/en-us/download/details.aspx?id=39046 . This diagnostic tool can help to troubleshoot Kerberos-related configuration...
  • Blog Post: Poster Download: Microsoft Business Intelligence at a Glance

    Over recent months, we had a lot of fun creating a Microsoft BI poster for SQL Pass and SharePoint Conference. As the title suggests, the poster shows the most important technologies in the Microsoft BI stack at a glance, arranged in various layers from the data sources all the way up to the client applications...
  • Blog Post: Configuring a Min-priv environment for PowerPivot for SharePoint 2013

    The new SharePoint 2013 release is bringing lots of exciting new things, and on this blog post we will go over what’s necessary to configure PowerPivot for SharePoint 2013 in a least-privileged accounts environment. The main idea is to use different accounts for different purposes, but all of them...
  • Blog Post: Setting Up an Administrative Server for BI in SharePoint 2013

    SharePoint has practically always relied on a Central Administration Web site to provide a centralized administrative user interface for configuring and controlling servers and services in a farm. PowerPivot for SharePoint adds several components to this site to cover common PowerPivot administration...
  • Blog Post: Troubleshooting PowerPivot for SharePoint Solution Deployments

    The configuration of PowerPivot for SharePoint entails a critical phase concerning the deployment of multiple solution packages (.wsp files) on all servers in the farm. If you run the PowerPivot Configuration Tool for the first time in a farm, you can see the various steps this phase includes under Add...
  • Blog Post: Verifying the SharePoint 2013 Configuration for Accessing Workbooks as a Data Source from Within the Farm

    My previous blog post, “ Verifying the Excel Services Configuration for PowerPivot in SharePoint 2013 ,” discussed steps to verify that Excel Services can load workbook data models on an out-of-farm PowerPivot server running SQL Server 2012 SP1 CTP3 Analysis Services (SSAS) in SharePoint...
  • Blog Post: Verifying the Excel Services Configuration for PowerPivot in SharePoint 2013

    In SharePoint 2013, Excel Services natively supports core PowerPivot functionality. This is an important improvement over previous releases. Without requiring an extra installation of PowerPivot components in the farm, users can interact with workbook data models in the browser. You only need to register...
  • Blog Post: Introducing the BI Light-Up Story for SharePoint 2013

    Ideally, you can find the Microsoft BI stack in every SharePoint farm across the enterprise so that users can seamlessly share their BI solutions with each other. In the real world, however, BI is only one of many SharePoint scenarios, albeit a mission-critical one. It is not uncommon for IT organizations...
  • Blog Post: Announcing Microsoft SQL Server 2012 Service Pack 1 (SP1) Community Technology Preview 3 (CTP3)

    Last week, we released the public CTP of Microsoft SQL Server 2012 Service Pack 1. For most SQL Server components, SP1 is just a collection of patches and bug fixes, but for Business Intelligence scenarios, SP1 is much more than just a service pack. SQL Server 2012 SP1 CTP3 is specifically released to...
  • Blog Post: Supporting Multiple PowerPivot Versions

    Since the release of SQL Server 2012, users can choose between two different versions of PowerPivot for Excel: SQL Server 2008 R2 and SQL Server 2012. Both PowerPivot versions are free of charge, but the 2012 add-in includes more features than its predecessor and offers several improvements to the user...
  • Blog Post: Removing VSTO-Based Customizations from a PowerPivot Workbook

    This article is a follow-up on a previous blog post titled “ How to Build a VSTO-Based PowerPivot Workbook ,” which discussed some of the advantages and disadvantages of building PowerPivot workbooks by using VSTO. A key VSTO advantage is that you can bring data from virtually any source...
  • Blog Post: Announcing Microsoft SQL Server 2012 Release Candidate 0 (RC0)

    Today, we’ve reached the next big milestone on the road to unlocking breakthrough insights across organizations with a cloud-ready information platform—we released Microsoft SQL Server 2012 RC0 ! You can find the installation media at the Microsoft.com Download Center. When you try it, don’t...
  • Blog Post: Exploring the PowerPivot for SharePoint Configuration Tool

    The PowerPivot Configuration Tool included in SQL Server Code Name “Denali” CTP3 is undoubtedly a great new utility for SharePoint administrators. This tool doesn’t just enable you to configure or upgrade PowerPivot in a SharePoint farm. It takes PowerPivot configuration to a whole...
  • Blog Post: How to Build a VSTO-Based PowerPivot Workbook

    Microsoft Visual Studio Tools for Office (VSTO) is an awesome development suite for building advanced Office solutions, such as Excel applications that go above and beyond default features and capabilities. Even our PowerPivot for Excel add-in is based on VSTO. However, it is important to note that VSTO...
  • Blog Post: About the Relativity of Large Data Volumes

    Some conversations in our team are really priceless. The other day, while working on an article about Analyzing Performance Data in PowerPivot , I was bragging to Ashvini about the fact that I was able to import a 55 GB database with more than 200 million rows of data into a 1 GB PowerPivot workbook...
  • Blog Post: Released: Microsoft SQL Server 2008 R2 Service Pack 1

    This week is packed with big announcements: We released Microsoft SQL Server Code Name “Denali” Community Technology Preview 3 (CTP3) with breakthrough innovations that will help our customers to shape their Business Intelligence (BI) future; and we also released Microsoft SQL Server 2008...
  • Blog Post: Released: Service Pack 1 for Microsoft SharePoint Server 2010

    Today is a great day for us PowerPivoteers because Service Pack 1 for Microsoft SharePoint Server 2010 has been released. You can download it from our new and fantastic Microsoft.com Download Center at http://www.microsoft.com/download/en/details.aspx?id=26623 . Why is this SharePoint Service Pack...
  • Blog Post: Install PowerPivot for SharePoint on a Domain Controller

    Take a video tour of this 4-part PowerPivot video series: How to install a system and get it up and running in a standalone demo system environment. This series features Dave Wickert , a Microsoft Principal Program Manager. Also featuring the voice of Heidi Steen , a Senior Technical Writer at Microsoft...
Page 1 of 1 (18 items)