Microsoft BI PFE

Business Intelligence Premier Field Engineers Blog

Excel 2013 PowerPivot workbook with PowerPivot for SharePoint 2010 ?

Last week, One of my customer had interesting issue with PowerPivot Workbooks. Here is scenario: My...

Author: Kagan Arca Date: 09/14/2013

How can I learn Business Intelligence? Part-1

Technorati Tags: Data Warehouse,Learn Business Intelligence,Enterprise Data Warehouse,Dimensional...

Author: Kagan Arca Date: 09/10/2013

Identifying Cell by Cell Computation Mode in MDX queries

Some weeks ago I was asked to help with a performance issue with some MDX Queries. I was shown what...

Author: Ruben Gonzalez Date: 09/04/2013

How to use SSIS to migrate data to Azure database from on-premise database

Today I read an article from msdn, it described Azure database support ODBC, so I did a test to...

Author: Amber Zhao Date: 08/31/2013

See you in SQL Saturday in Istanbul on 5th October..

  As Microsoft Premier Field Engineering team, we enjoy contributing events such as SQLPASS,...

Author: Kagan Arca Date: 08/29/2013

Analysis Services Tabular Mode Performance Tuning Guide is available!

We recently published performance guidelines for Analysis Service Tabular Model. You can access this...

Author: Kagan Arca Date: 08/07/2013

OOPS, I got an error. Ensuring The Correct Bitness Provider is Installed

The field of Business Intelligence involves consolidating and aggregating data from a number of...

Author: John Desch MSFT Date: 07/30/2013

Can I use SSDB without installing SSIS?

Recently my customer asked question around SSDB. As you may know, When you install SQL Server Engine...

Author: Kagan Arca Date: 07/25/2013

An Error when attempting to Preview a Report using SQL Server Data Tools in a Remote Session

A customer with whom I work recently encountered an error message when attempting to preview a...

Author: John Desch MSFT Date: 07/09/2013

Which Edition of Analysis Services I am running on?

I got this question from few customers and I wanted to share with you how to find edition of...

Author: Kagan Arca Date: 06/27/2013

PowerView Connecting Multi Dimensional Analysis Services Data Source is Ready!

  During our onsite visits about PowerView, We had been asked several times if PowerView will...

Author: Kagan Arca Date: 06/20/2013

When should I use Analysis Services Tabular mode or Multi Dimensional mode?

  After talking with several customers, I have got this question asked several times? Since...

Author: Kagan Arca Date: 06/20/2013

Microsoft BI Authentication and Identity Delegation white paper

Hi everyone! This month we released a new white paper for the newest SQL Server 2012 SP1 and Office...

Author: Alexandre Mendeiros Date: 03/11/2013

The Kerberos, SharePoint, Reporting Services and Internet Explorer case

Hello everyone, It’s been a while since I did my last post and this week I want to share with...

Author: Alexandre Mendeiros Date: 02/15/2013

Analysis Services: Removing Instance Level Admin Rights from Developers….

One of popular questions in these days: Is it possible to remove admin rights from developers but...

Author: Kagan Arca Date: 02/15/2013

Managing Server Side Analysis Services Profiler Trace

I have been asked how to run Analysis Services Profiler Trace as Server side Trace. There are few...

Author: Kagan Arca Date: 02/12/2013

Reporting Services SharePoint Integrated Mode Disaster Recovery Options….

I was working with one of my customer around Reporting Services SharePoint Integrated Mode Disaster...

Author: Kagan Arca Date: 01/30/2013

Hardware Sizing a Tabular Solution (SQL Server Analysis Services)

Hello everyone, This month we released a new document about hardware sizing in SQL Server 2012...

Author: Alexandre Mendeiros Date: 01/20/2013

Business Intelligence Academy for you…

  It is pleasure to announce that we have another great offering in our premier...

Author: Kagan Arca Date: 01/13/2013

MDX Fundamentals & DAX Fundamentals Sessions

I am pleased to announce, our new two courses are available in January.  Here are course...

Author: Kagan Arca Date: 12/05/2012

Funny Case in Reporting Services

Hello everyone, This week I had a funny case about Reporting Services scale-out. If you are aware of...

Author: Kagan Arca Date: 11/22/2012

Microsoft Business Intelligence at a Glance Poster

You might want to download Microsoft BI Poster and stick it to your desk may be ? :) Here is link:...

Author: Kagan Arca Date: 11/20/2012

What happens to MDS and DQS after SQL Server 2012 Service Pack 1 Installation?

We released SQL Server 2012 Service Pack 1 recently. You can download SQL 2012 Service Pack 1 from...

Author: Kagan Arca Date: 11/20/2012

Exciting news...

It is pleasure to announce our new blog site which will cover technical information as well as news,...

Author: Kagan Arca Date: 11/14/2012