Using Extended Events with SQL Server Analysis Services 2016 CTP 2.3

Extended Events were introduced into Analysis Services in SQL Server 2012. This made use of a common XE module that was shared with SQL Server Database Engine. The challenge with Extended Events is that it can be complicated to configure going on scripting alone. You need to know what events are available, and how you… Read more

Announcing Microsoft SQL Server 2012 Service Pack 1 (SP1) Community Technology Preview 4 (CTP4)

Last Thursday, we released SQL Server 2012 Service Pack 1 (SP1) CTP4. Both the Service Pack and Feature Pack updates are available for download on the Microsoft Download Center. While CTP3 was primarily targeted at introducing the BI functionality for Office 2013 Preview and SharePoint 2013 Preview, CTP4 covers SQL Server functionality across the board…. Read more

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 deployment mode so that users can enjoy full workbook interactivity in the browser…. Read more

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 to deploy multiple farms… Read more

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 accompany the… Read more

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 new level. Here are some key improvements in comparison to what’s available… Read more

Released: SQL Server Code Name “Denali” CTP3 Product Guide

Looking for datasheets, white papers, click-through and auto-running demonstrations, hands-on lab previews, technical presentations, and other useful links to evaluate SQL Server Code Name ‘Denali’ CTP3? Go to the Microsoft Download Center and search for “CTP3 Product Guide” or simply click on the following link: The SQL Server Denali CTP3 Product Guide includes the… Read more

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 together and provides step-by-step installation… Read more

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 edition at the Download Center. Try it… Read more