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: Released: Twitter Analytics for Excel 2013

    Back in 2011, we released a great PowerPivot sample application to query Twitter and analyze tweets within Excel 2010. This was a joint venture between Microsoft and ISV Gold BI partner Extended Results, and the great news is that Extended Results has finished an updated version that now also works in...
  • Blog Post: Refreshing PowerPivot Data in SharePoint 2013

    In SharePoint 2013, Excel Services comes with numerous improvements. One of the most significant for PowerPivot is the ability to refresh data models interactively all the way from the original data sources. Unlike Excel Services in SharePoint 2010, which only queries data models but doesn’t refresh...
  • 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: More on Multiple PowerPivot Versions

    The previous blog post, Supporting Multiple PowerPivot Versions , contained a PowerShell script that has proven to be very helpful for us on the product team. We get a fair number of workbooks from a variety of sources created with many different versions of PowerPivot, usually with a request for help...
  • Blog Post: SQL Server Analysis Services and Big Data

    Over the past few weeks, I had an opportunity to work with colleague Denny Lee and David P Mariani (VP of Engineering, Klout) on a very interesting Big Data story about how Klout.com takes advantage of Analysis Services. Klout analyzes massive amounts of social network user data to measure the impact...
  • 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: Understanding Analysis Services Deployment Modes

    SQL Server 2012 Analysis Services (SSAS) supports three different deployment modes: Multidimensional, Tabular, and SharePoint. You can choose the deployment mode during Setup, as the following figure illustrates. The SharePoint deployment mode is implicitly chosen on the Setup Role page when you install...
  • 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: SQL Server 2012 Released: Eval version available immediately, general availability in April

    This is it! Microsoft SQL Server 2012 has been released to manufacturing (RTM), with an evaluation version available immediately . So download the final bits and see for yourself how the new SQL Server version can help you manage any data, any size, anywhere, and deliver breakthrough insights across...
  • 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: Whitepaper and Samples Released: Data Analysis Expressions (DAX) In the Tabular BI Semantic Model

    Happy New Year 2012, everybody! With the release of SQL Server 2012 ante portas, this is going to be a very exciting year. So, let’s start this year with a release announcement: An updated version of the whitepaper “ Data Analysis Expressions (DAX) In the Tabular BI Semantic Model ”...
  • 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: Tips and Tricks: Mapping Data to the World in a PowerPivot Workbook

    Last week I came across a stunning PowerPivot solution that visualizes research data on top of a world map, as illustrated in the following screenshot. What’s particularly stunning about this solution is that it works even in the browser despite the fact that Excel Services doesn’t support...
  • Blog Post: Analysis Services Blog Post Roundup for Denali CTP3

    A few AS team members have started blogging on Denali functionality at their personal blog sites. Cathy Dumas, a Program Manager on our team, is just warming up on her blog . She’s got a couple of interesting posts: Tabular designer architecture Tabular project structure Kasper...
  • 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: Denali CTP3 Samples and TechNet Wiki

    This was a big announcement week for us. Let’s finish it with a note about our new Denali CTP3 samples. JuanPablo already introduced the AMO sample in his Creating a Tabular Model with AMO blog post, but wait there’s more: SQL Server Samples Readme on the TechNet Wiki Ties all samples...
Page 1 of 2 (34 items) 12