Saturday, July 28, 2012

PowerView with SSRS 2012 Native mode and Excel 2013

I'm reading: PowerView with SSRS 2012 Native mode and Excel 2013Tweet this !
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.

Thursday, July 26, 2012

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

I'm reading: Download Free SQL Server Ebooks , Download Free Sharepoint Ebooks and moreTweet this !
 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 | PDFSource 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 | MOBIPDF | 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 | MOBIPDF | Source content
Office
 First Look: Microsoft Office 2010Katherine Murray
Overview
Welcome 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-Step
This 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

EPUBMOBIPDFSource 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 pagesEPUBMOBIPDF | 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
50EPUBMOBIPDF | 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
263EPUBMOBIPDF | 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
63EPUBMOBIPDF | 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 Wik
i

E-book publication date
: May 2012
6 pages

EPUB | MOBIPDF | 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

EPUBMOBIPDF | 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

EPUBMOBIPDF | Source content 1Source 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

EPUBMOBIPDF | Source content

 SQL Server 2012 Tutorials: Analysis Services - Data Mining
SQL Server 2012 Books Online
Step-by-Step
Microsoft 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

EPUBMOBIPDFSource 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

EPUBMOBIPDFSource 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

EPUBMOBIPDFSource 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

EPUBMOBIPDF

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
Guide
Looking 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
SourceMSDN Library (patterns & practices)

E-book publication date: June 2012
128 pages

EPUBMOBIPDFSource 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 | MOBIPDF |
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 | MOBIPDF | 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

EPUBMOBIPDFSource 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 Online
E-book publication date: May 2012
263 pages
E
PUB | MOBIPDF | Source content

 Introducing Microsoft SQL Server 2008 R2Ross Mistry and Stacia Misner
Overview
Our 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
Overview
Microsoft 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
Related Posts with Thumbnails