PowerView with SSRS 2012 Native mode and Excel 2013

Office 2013 Preview has been released and is available for download from here. More about Office 2013 enhancements can be read from here. Powerpivot has now become a native part of Excel 2013, which was available as a separate add-in in prior version. This very of powerpviot comes with few new inevitable enhancements like ability to edit tabular models. This is a very welcome news. But the news that I am not happy with is, there is also an add-in available for PowerView with Excel 2013.

After reading some of you might wonder why am I not happy with this news as this makes Excel a very powerful client tool as the reporting capabilities would get a silverlight based animatory touch. The reason is that as of this draft and to the best of my knowledge, PowerView is not available with SSRS 2012 native mode. It's a Sharepoint only available feature. In my opinion, it should be made available in BIDS as well as SSRS native mode too, in the form of an external add-in and rendering extension respectively.

Another thing that seems strange to me is why is PowerView add-in available as a COM add-in. I am not that deeply aware of office add-ins, but from a general development standpoint, from the name I understand that its a COM component. In .NET terms it's unmanaged code / component, instead of a .NET Framework based managed code. If that's the case, my curiosity asks why COM ?

An interesting outcome of this can be that Powerpivot in Excel 2013 would become the new BIDS as well as reports manager for PowerView based reports, instead of buying entire enterprise class license for better compressed reports, data alerts and powerview which are the major enhancements available in SSRS 2012 Sharepoint integrated mode.

One another such very interesting capability is provided by PivotViewer Extension for Reporting Services, but its in CTP2. But even this application is available with Sharepoint only.

Download Free SQL Server Ebooks , Download Free Sharepoint Ebooks and more

Deploying an ASP.NET Web Application to a Hosting Provider using Visual Studio Tom Dykstra Step-by-Step This series of tutorials shows you how to make an ASP.NET web application available over the internet by deploying it to a third-party hosting provider. The deployment method used is Visual Studio one-click publish. The tutorials illustrate deployment first to IIS on the development computer for testing. They then show you how to deploy to the hosting provider as the production environment. Applies to: ASP.NET 4.0 and earlier, Visual Studio 2010 Source: ASP.NET site E-book publication date: May 2012 162 pages EPUB | MOBI | PDF | Source content

Getting Started with ASP.NET 4.5 Web Forms (Beta) Erik Reitan Step-by-Step This series of tutorials guides you through the steps required to create an ASP.NET Web Forms application using Visual Studio 11 Beta and ASP.NET 4.5 Beta. Applies to: ASP.NET 4.5 Beta, Visual Studio 11 Beta, ASP.NET 4.5 RC, Visual Studio 2012 RC Source: ASP.NET site   E-book publication date: May 2012 59 pages EPUB | MOBI | PDF | Source content

Intro to ASP.NET MVC 4 with Visual Studio (Beta) Rick Anderson and Scott HanselmanStep-by-Step This tutorial will teach you the basics of building an ASP.NET MVC Web application using Microsoft Visual Studio 11 Express Beta for Web, which is a free version of Microsoft Visual Studio. Applies to: ASP.NET MVC 4 Beta, Visual Studio 11 Beta, ASP.NET MVC 4 RC, Visual Studio 2012 RC Source: ASP.NET site   E-book publication date: May 2012 115 pages EPUB | MOBI | PDF | Source content

Office

First Look: Microsoft Office 2010Katherine Murray OverviewWelcome to Office 2010. Whether you work primarily in the office or on the go, you’ll find smart tools in this release that enable you to get your work done easier, faster, and more professionally than ever. All the freedom to multitask built into Office 2010 has an upside you might not expect: being able to work anywhere, anytime means more flexibility, which translates to higher efficiency and effectiveness. And when your work is done quickly and well, you have more time left over for the people, places, and possibilities that intrigue you. Applies to: Office 2010 Publisher: Microsoft Press E-book publication date: January 2010 202 pages XPS | PDF | Source content

Microsoft Office 365: Connect and Collaborate Virtually Anywhere, Anytime Katherine Murray Step-by-StepThis book shows you how you can use cloud computing—and specifically, Office 365—to get more done, collaborate more easily, and work more flexibly than you ever have before. Applies to: Office 365 Publisher: Microsoft Press E-book publication date: August 2011 337 pages EPUB | MOBI | PDF | Source content

Microsoft Office 365 for professionals and small businesses: Help and How To Office 365 User Assistance Team Step-by-Step  Your organization uses Microsoft Office 365 for professionals and small businesses to communicate and collaborate. Office 365 includes email, document sharing, Microsoft Office Web Apps and more. There are important tasks that you need to do to use all of the features of Office 365. This guide leads you through those steps. Applies to: Office 365 for professionals and small businesses Source: Microsoft Online Help E-book publication date: June 2012 197 pages EPUB | MOBI | PDF | Source content

Security and Privacy for Microsoft Office 2010 UsersMitch Tulloch Guide Take control—and put the built-in security and privacy features in Microsoft Office to work! Whether downloading documents, publishing a presentation, or collaborating online—this guide offers concise, how-to guidance and best practices to help protect your documents and your ideas. Applies to: Office 2010 Publisher: Microsoft Press E-book publication date: February 2012 98 pages EPUB | MOBI | PDF | Source content

SharePoint

Configure Kerberos Authentication for SharePoint 2010 Products Tom Wisnowski Guide This document covers the concepts of identity in SharePoint 2010 products, how Kerberos authentication plays a critical role in authentication and delegation in business intelligence scenarios, and the situations where Kerberos authentication should be leveraged or may be required in solution designs. It also covers how to configure Kerberos authentication end-to-end within your environment, including scenarios which use various service applications in SharePoint Server. Additional tools and resources are described to help you test and validate Kerberos configuration. Applies to: SharePoint 2010 Source: White paper E-book publication date: May 2012 220 pagesEPUB | MOBI | PDF | Source content

Business continuity management for SharePoint Server 2010 Office and SharePoint content publishing team Guide Provides information about the business decisions, processes, and tools you put in place in advance to handle crises, such as backing up and restoring data. Information includes features of Microsoft SharePoint Server 2010 that are likely to be part of your business continuity management strategy. Applies to: SharePoint Server 2010 Source: TechNet library E-book publication date: October 2011 942EPUB | MOBI | PDF | Source content

Deployment guide for SharePoint Server 2010 Office and SharePoint content publishing team Guide This book includes information deployment scenarios, step-by-step installation instructions, and post-installation configuration steps for deploying Microsoft SharePoint Server 2010. Applies to: SharePoint Server 2010 Source: TechNet library E-book publication date: October 2011 936EPUB | MOBI | PDF | Source content

Get started with SharePoint Server 2010 Office and SharePoint content publishing team Guide This book provides basic information about the capabilities of and requirements for Microsoft SharePoint Server 2010. The audiences for this book include application specialists, line-of-business application specialists, information architects, IT generalists, program managers, and infrastructure specialists who are just starting to learn about SharePoint Server 2010 and want a quick introduction plus installation steps. Applies to: SharePoint Server 2010 Source: TechNet library E-book publication date: October 2011 50EPUB | MOBI | PDF | Source content

Governance guide for Microsoft SharePoint Server 2010 Office and SharePoint content publishing team Guide This book provides guidance to help you determine the aspects of a Microsoft SharePoint Server 2010 deployment to govern and the governance techniques to use. Governance is the set of policies, roles, responsibilities, and processes that you establish in your enterprise to guide, direct, and control how it uses technologies to accomplish business goals. To strike the right balance between the needs of the users of your SharePoint Server 2010 deployment and the IT professionals who deploy and operate SharePoint Server 2010, we recommend that you form a governance body that includes representatives of all stakeholders in the SharePoint Server 2010 deployment. This body can then create and enforce rules that govern the use of SharePoint Server 2010. Applies to: SharePoint Server 2010 Source: TechNet library E-book publication date: October 2011 128EPUB | MOBI | PDF | Source content

Profile synchronization guide for SharePoint Server 2010 Office and SharePoint content publishing team Guide This book describes how to plan and configure profile synchronization in Microsoft SharePoint Server 2010. Also included is technical reference information about profile properties, data types, and permissions. Applies to: SharePoint Server 2010 Source: TechNet library E-book publication date: October 2011 263EPUB | MOBI | PDF | Source content

Remote BLOB storage for Microsoft SharePoint Server 2010 Guide How to use Microsoft SharePoint Server 2010 together with Remote BLOB Storage (RBS) and Microsoft SQL Server 2008 Express and Microsoft SQL Server 2008 R2 Express to optimize database storage resources. Applies to: SharePoint Server 2010 Source: TechNet library E-book publication date: October 2011 63EPUB | MOBI | PDF | Source content

Technical reference for Microsoft SharePoint Server 2010 Office and SharePoint content publishing team Guide This book includes technical information about the Microsoft SharePoint Server 2010 provider for Windows PowerShell and other helpful reference information about general settings, security, and tools. Applies to: SharePoint Server 2010 Source: TechNet library E-book publication date: October 2011 1557EPUB | MOBI | PDF | Source content

Upgrading to SharePoint Server 2010 Office and SharePoint content publishing team Guide This book is designed to guide administrators and IT professionals through the process of upgrading to Microsoft SharePoint Server 2010. Applies to: SharePoint Server 2010 Source: TechNet library E-book publication date: October 2011 605EPUB | MOBI | PDF | Source content

Master Data Services Capacity Guidelines Yair Helman Quick Guide This document provides capacity planning guidelines for Microsoft SQL Server 2012 Master Data Services (MDS). Applies to: SQL Server 2012 Source: TechNet Wiki E-book publication date: May 2012 6 pages EPUB | MOBI | PDF | Source content

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery LeRoy Tuttle, Jr. Quick Guide This white paper discusses how to reduce planned and unplanned downtime, maximize application availability, and provide data protection using SQL Server 2012 AlwaysOn high availability and disaster recovery solutions. A key goal of this paper is to establish a common context for related discussions between business stakeholders, technical decision makers, system architects, infrastructure engineers, and database administrators. Applies to: SQL Server 2012 Source: White paper E-book publication date : May 2012 32 pages EPUB | MOBI | PDF | DOC | Source content

Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide Thomas Kejser and Denny Lee Guide Download this book to learn about Analysis Services Multidimensional performance tuning from an operational and development perspective. This book consolidates the previously published SQL Server 2008 R2 Analysis Services Operations Guide and SQL Server 2008 R2 Analysis Services Performance Guide into a single publication that you can view on portable devices. Applies to: SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 Source: White paper E-book publication date: May 2012 200 pages EPUB | MOBI | PDF | Source content 1 | Source content 2

QuickStart: Learn DAX Basics in 30 Minutes Owen Duncan Quick Step-by-Step This QuickStart is for users new to PowerPivot or tabular model projects authored in SQL Server Data Tools. It is meant to give you a quick and easy introduction on how you can use Data Analysis Expressions (DAX) to solve a number of basic data modeling and analytical problems. Applies to: PowerPivot for Excel (all versions), SQL Server 2008 R2, SQL Server 2012 Source: TechNet Wiki E-book publication date: May 2012 13 pages EPUB | MOBI | PDF | Source content

SQL Server 2012 Tutorials: Analysis Services - Data Mining SQL Server 2012 Books Online Step-by-StepMicrosoft SQL Server Analysis Services makes it easy to create sophisticated data mining solutions. The step-by-step tutorials in the following list will help you learn how to get the most out of Analysis Services, so that you can perform advanced analysis to solve business problems that are beyond the reach of traditional business intelligence methods. Applies to: SQL Server 2012 Source: SQL Server 2012 Books Online E-book publication date: June 2012 213 pages EPUB | MOBI | PDF | Source content

SQL Server 2012 Tutorials: Analysis Services - Multidimensional Modeling SQL Server 2012 Books OnlineStep-by-Step               This tutorial describes how to use SQL Server Data Tools to develop and deploy an Analysis Services project, using the fictitious company Adventure Works Cycles for all examples. Applies to: SQL Server 2012 Source: SQL Server 2012 Books Online E-book publication date: June 2012 168 pages EPUB | MOBI | PDF | Source content

SQL Server 2012 Tutorials: Analysis Services - Tabular Modeling SQL Server 2012 Books Online Quick Step-by-Step  This tutorial provides lessons on how to create a SQL Server 2012 Analysis Services tabular model running in In-Memory mode by using SQL Server Data Tools (SSDT). Applies to: SQL Server 2012 Source: SQL Server 2012 Books Online E-book publication date: June 2012 57 pages EPUB | MOBI | PDF | Source content

SQL Server 2012 Upgrade Technical Guide Ron Talmage, Nigel Sammy, Allan Hirt, Herbert Albert, Antonio Soto, Danilo Dominici, Régis Baccaro, Milos Radivojevic, Jesús Gil, Dejan Sarka, Johan Åhlén, Simran Jindal, Paul Turley, Craig Utley, Larry Barnes, Pablo Ahumada Guide  This technical guide takes you through the essentials for upgrading SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2 instances to SQL Server 2012. Applies to: SQL Server 2012 Source: White paper E-book publication date: June 2012 454 pages EPUB | MOBI | PDF

Visual Studio

Moving to Microsoft Visual Studio 2010Patrice Pelland, Pascal Paré, and Ken Haines Guide This book is for professional developers who are working with previous versions of Visual Studio and are looking to make the move to Visual Studio 2010 Professional. Applies to: Visual Studio 2010 Publisher: Microsoft Press E-book publication date: September 2010 36 pages XPS | PDF | Source content

Windows

Deploying Windows 7: Essential GuidanceWindows 7 Resource Kit and TechNet Magazine GuideLooking for guidance specific to Windows 7 deployment? Check out what the industry's leading experts have to say in this free Microsoft Press eBook with selected chapters from the Windows 7 Resource Kit and TechNet Magazine. Applies to: Windows 7 Publisher: Microsoft Press E-book publication date: October 2009 332 pages PDF | Source content

Programming Windows 8 Apps with HTML, CSS, and JavaScript (First Preview)Kraig Brockschmidt Guide This book is about writing Metro style apps for Windows 8 using HTML5, CSS3, and JavaScript. Our primary focus will be on applying these web technologies within the Windows 8 platform, where there are unique considerations, and not on exploring the details of those web technologies themselves. To work through this book, you should download and install the Windows 8 Release Preview along with the Windows SDK and tools. Applies to: Windows 8 Publisher: Microsoft Press E-book publication date: June 2012 158 pages PDF | Sample code | Source content

 Windows Azure

Moving Applications to the Cloud, 2nd Edition patterns & practices Guide This book demonstrates how you can adapt an existing, on-premises ASP.NET application to one that operates in the cloud. The book is intended for any architect, developer, or information technology (IT) professional who designs, builds, or operates applications and services that are appropriate for the cloud. Although applications do not need to be based on the Microsoft Windows operating system to work in Windows Azure, this book is written for people who work with Windows-based systems. You should be familiar with the Microsoft .NET Framework, Microsoft Visual Studio, ASP.NET, and Microsoft Visual C#. Applies to: Windows Azure SDK for .NET (includes the Visual Studio Tools for Windows Azure), Windows Azure SQL Database, Microsoft SQL Server or SQL Server Express 2008, Windows Identity Foundation, Enterprise Library 5, WatiN 2.0, Microsoft Anti-Cross Site Scripting Library V4, Microsoft .NET Framework version 4.0, Microsoft Visual Studio 2010 Source: MSDN Library (patterns & practices) E-book publication date: June 2012 128 pages EPUB | MOBI | PDF | Source content

Windows Azure Prescriptive Guidance Larry Franks, Sidney Higa, Suren Machiraju, Christian Martinez, Valery Mizonov, Walter Myers III, Rama Ramani, Jason Roth, Mark Simms, Paolo Salvatori, Adam Skewgar, Ralph Squillace, Patrick Wickline, Trace Young Guide Windows Azure Prescriptive Guidance provides you with some of the best practices and recommendations for working with the Windows Azure platform. Categories cover planning, designing, developing, and managing a variety of different types of Windows Azure applications, including mobile, enterprise, and consumer-based applications. It also provides guidance for developers using non-.NET applications, libraries, and stacks with Windows Azure. Applies to: Windows Azure, Windows Azure SQL Database, Windows Azure Cloud Services, and Enterprise Integration Applications Source: MSDN Library E-book publication date: May 2012 422 pages EPUB | MOBI | PDF | Source content

Windows Azure Service Bus Reference Seth Manheim and Ralph Squillace Reference The Windows Azure Service Bus provides a hosted, secure, and widely available infrastructure for widespread communication, large-scale event distribution, naming, and service publishing. The Service Bus provides connectivity options for Windows Communication Foundation (WCF) and other service endpoints – including REST endpoints -- that would otherwise be difficult or impossible to reach. Endpoints can be located behind network address translation (NAT) boundaries, or bound to frequently-changing, dynamically-assigned IP addresses, or both. Applies to: Windows Azure Service Bus Source: MSDN Library E-book publication date: May 2012 260 pages EPUB | MOBI | PDF | Source content

Windows Phone

Programming Windows Phone 7 Charles Petzold Guide Get started building applications for Windows Phone 7—expertly guided by award-winning author Charles Petzold. You’ll focus on the core concepts and techniques for creating apps with Microsoft® XNA and Microsoft Silverlight®, with coverage of Microsoft Visual Studio®, .NET Framework managed code sandbox, the phone emulator, sensors, and location. As always, Charles brings a unique combination of pragmatism and authority to his instruction—along with an eminently readable style and a wealth of hands-on examples. Note: This book is not applicable to Windows Phone 7.5 or Windows Phone 8 development. Applies to : Windows Phone 7 Publisher: Microsoft Press E-book publication date: October 2010 960 pages EPUB MOBI | PDF | Source content

Windows Server

Introducing Windows Server 2008 R2Charlie Russel and Craig Zacker with the Windows Server Team at Microsoft Overview In this book, we focus on the new features and refinements in Windows Server 2008 R2. This book is targeted primarily at Windows server administrators who are responsible for hands-on deployment and day-to-day management of Windows-based servers for large organizations. Applies to: Windows Server 2008 R2 Publisher: Microsoft Press E-book publication date: October 2009 200 pages XPS | PDF | Source content

Introducing Windows Server 2012 (Based on Beta)Mitch Tulloch with the Windows Server Team Overview This book represents a “first look” based on the public beta release of Windows Server 2012 and is intended to help IT professionals familiarize themselves with the capabilities of the new platform. Applies to: Windows Server 2012 Publisher: Microsoft Press E-book publication date: June 2012 256 pages EPUB | MOBI | PDF | Source content

Understanding Microsoft Virtualization Solutions: From the Desktop to the Datacenter, Second EditionMitch Tulloch with the Microsoft Virtualization Teams Guide This book is for IT professionals who want to learn more about the latest Microsoft virtualization technologies, including Hyper-V and Remote Desktop Services in Windows Server 2008 R2, Microsoft Virtual Desktop Infrastructure, Microsoft Application Virtualization 4.5, Microsoft Enterprise Desktop Virtualization, Windows Virtual PC and Windows XP Mode, System Center Virtual Machine Manager 2008, and Microsoft’s private and public cloud computing platforms including Windows Azure. Applies to: Windows Server 2008 R2, System Center Publisher: Microsoft Press E-book publication date: February 2010 466 pages XPS | PDF | Source content

Learning & Career 

Own Your Future: Update Your Skills with Resources and Career Ideas from Microsoft Katherine Murray In this book, students will find a wealth of Microsoft resources they can  use to identify the technology skills they need, and gather knowledge and  experience to help them take charge of their careers. Here at Microsoft, we care about students’ career success and hope these resources will open doors to learning that will lead them to better opportunities and a deeper understanding  of the way technology continues to change and improve the ways people work—both here in the U.S. and around the world.             Applies to:  Publisher: Microsoft Press  E-book publication date: February 2010 126 pages XPS | PDF | Source content

SQL Server

Backup and Restore of SQL Server Databases SQL Server 2012 Books Online  Reference  This book describes the benefits of backing up SQL Server databases, basic backup and restore terms, and introduces backup and restore strategies for SQL Server and security considerations for SQL Server backup and restore. Applies to: SQL Server 2012 Source: SQL Server 2012 Books Online E-book publication date: June 2012 288 pages EPUB | MOBI | PDF | Source content

Transact-SQL Data Manipulation Language (DML) Reference SQL Server 2012 Books Online Reference Data Manipulation Language (DML) is a vocabulary used to retrieve and work with data in SQL Server 2012. Use these statements to add, modify, query, or remove data from a SQL Server database. Applies to: SQL Server 2012 Source: Microsoft SQL Server 2012 Books OnlineE-book publication date: May 2012 263 pages EPUB | MOBI | PDF | Source content

Introducing Microsoft SQL Server 2008 R2Ross Mistry and Stacia Misner OverviewOur purpose in this book is to point out both the new and the improved in SQL Server 2008 R2. There are a lot of exciting enhancements and new capabilities engineered into SQL Server 2008 R2 that will have a positive impact on your applications, ranging from improvements in operation to those in management. Applies to: SQL Server 2008 R2 Publisher: Microsoft Press E-book publication date: April 2010 216 pages XPS | PDF | Source content

Introducing Microsoft SQL Server 2012Ross Mistry and Stacia Misner OverviewMicrosoft SQL Server 2012 is Microsoft’s first cloud-ready information platform. It gives organizations effective tools to protect, unlock, and scale the power of their data, and it works across a variety of devices and data sources, from desktops, phones, and tablets, to datacenters and both private and public clouds. Our purpose in this book is to point out both the new and the improved capabilities as they apply to achieving mission-critical confidence, breakthrough insight, and using a cloud on your terms. Applies to: SQL Server 2012 Publisher: Microsoft Press E-book publication date: March 2012 288 pages EPUB | MOBI | PDF | Source content

Reference: Microsoft Technet