Browse by Tags

Tagged Content List
  • Blog Post: Bucketing Values in DAX

    Let’s say I wanted to analyze query performance on my SQL database. I have a log that has all the queries, the time it took them to run and the total records that were returned. I want to look at how the size of the results impacts the performance of the queries. I pull my data into Power Pivot...
  • Blog Post: Released: Management Pack for SQL Server Analysis Services 2008 and 2012

    This week, we released Management Packs for SQL Server 2008 and 2012 Analysis Services. The corresponding downloads are available at: System Center Management Pack for SQL Server 2012 Analysis Services System Center Management Pack for SQL Server 2008 Analysis Services These Management...
  • Blog Post: SQL Server Data Tools – Business Intelligence (SSDT BI) for SQL Server 2014 CTP1

    In this pre-release version of SQL Server 2014 , SSDT BI is no longer included in setup. For SQL Server 2014 CTP1 no new version of SSDT BI been released, however you can use the existing version of SSDT BI to create and deploy projects for SQL Server 2014 CTP1. The Visual Studio 2012 version of SSDT...
  • 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: 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: Tabular Database PowerShell CmdLets available on CodePlex

    JuanPablo just released an interesting cmdlet library to manage Tabular Models using PowerShell. It builds on the Tabular Model with AMO project, which JuanPablo introduced a few months ago in his blog article Creating a Tabular Model with AMO - New Version SQL 2012 . So there you have it! Go to http...
  • 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: 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: 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: xVelocity and Analysis Services

    Along with the SQL Server 2012 launch, Microsoft announced xVelocity in-memory technologies , delivering huge performance improvements for data warehousing and business intelligence. The purpose of this blog post is to clarify what xVelocity means for business intelligence and Analysis Services in particular...
  • 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: 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: 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...
  • 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: Submit Your Feedback on Analysis Services and PowerPivot

    Now that the Microsoft SQL Server Code Name “Denali” Evaluation edition is available for download, we are eager to hear from you. Do you like the new Business Intelligence (BI) features, such as the new professional BI developer tools? Do you find it easy to create tabular models on an Analysis...
  • Blog Post: Announcing Microsoft SQL Server Code Name “Denali” Community Technology Preview 3 (CTP3)

    Today we released our next public CTP of Microsoft SQL Server Code Name “Denali.” This milestone is super exciting because it is packed with amazing Business Intelligence (BI) improvements and innovations for relational databases as well as for BI solutions. You can find the Denali CTP Evaluation...
  • Blog Post: Analysis Services – Vision & Roadmap Update

    At the TechEd North America 2011 conference in Atlanta this week, the SQL Server team is providing details on the SQL Server “Denali” release, including the upcoming public availability of a Community Technology Preview (CTP) this summer. As part of these announcements, we are providing an...
Page 1 of 1 (23 items)