Microsoft SharePoint 2010 Business Intelligence Unleashed


Book Description

SharePoint 2010 is today’s leading presentation and deployment system for Business Intelligence (BI) solutions based on Microsoft technologies. This book brings together all the information you need to successfully implement and use SharePoint 2010’s powerful BI capabilities. It reflects the unsurpassed real-world experience of five expert consultants at RDA, a Microsoft Gold Partner specializing in delivering advanced BI solutions with SharePoint. You’ll first learn how to prepare SharePoint 2010 for the deployment of BI solutions. Next, the authors walk through integrating, configuring, and using Reporting Services, PerformancePoint Services, PowerPivot, Visio Services, and other key related technologies. Building on what you’ve learned, you’ll walk step-by-step through constructing and integrating two end-to-end BI solutions. Finally, in a comprehensive troubleshooting section, the authors present today’s most common SharePoint BI issues, identify proven solutions, and teach effective problem-solving techniques. Get started fast, by using the Business Intelligence Center’s prebuilt site collection and template Build integrated, end-to-end SharePoint BI solutions Present business data to the enterprise through Excel Services Install, configure, and integrate Reporting Services and the Reporting Services Add-In for SharePoint Define document library content types and manage reports Use Report Viewer Web Parts to render reports on SharePoint web pages Build enterprise dashboards with PerformancePoint Services Secure dashboards via data source delegation, SharePoint permissions, and groups Analyze enormous datasets with PowerPivot for Excel and SharePoint Publish Visio 2010 data-driven web diagrams that integrate multiple data sources Utilize the fine-grained security available through Visio Graphics Service Troubleshoot problems with Reporting Services, PerformancePoint Services, PowerPivot, and Visio Services




Microsoft SharePoint 2010 Unleashed


Book Description

Microsoft® SharePoint 2010 Unleashed Michael Noel Colin Spence Using Microsoft SharePoint 2010 technologies, organizations can bring together, utilize, and collaborate with information from virtually any source. Microsoft SharePoint 2010 Unleashed is the most complete, practical resource for all administrators, managers, architects, users, and power users who want to make the most of this powerful platform. Drawing on their experience implementing SharePoint solutions in hundreds of organizations, Michael Noel and Colin Spence cover all facets of succeeding with SharePoint: planning, deployment, migration, scalability, administration, security, Microsoft Office integration, workflow and dashboard development, and more. Noel and Spence illuminate the newest SharePoint innovations, from new social networking features to improved search, helping you make the most of both SharePoint Foundation and SharePoint Server 2010. Using easy-to-understand, step-by-step examples, the authors help you streamline administration, optimize performance, control cost, and implement high-value solutions for collaboration, document management, and business intelligence. Architect and implement SharePoint 2010, and migrate from legacy SharePoint servers Perform advanced installations that maximize scalability Monitor, back up, and restore SharePoint environments Maintain the SQL Server databases on which SharePoint 2010 relies Systematically improve edge, transport, and content security Deploy SharePoint in extranets and alternative authentication scenarios Create highly efficient virtualized SharePoint 2010 farms Customize and manage libraries and lists for your specific requirements Design and manage pages and sites for knowledge workers Effectively manage metadata and content types Integrate content using Office Web Apps and Excel, Access, and Visio Graphics Services Create both out-of-the-box and customized SharePoint workflows Develop custom solutions with SharePoint Designer 2010 and Visual Studio 2010 Create BI solutions with PerformancePoint and Business Connectivity Services Govern your SharePoint ecosystem for maximum value Michael Noel, MS-MVP, MCITP, is an internationally recognized technology expert, bestselling author, and well-known public speaker on a wide range of IT topics. He is the author of 17 books, including Exchange Server 2010 Unleashed, Windows Server 2008 R2 Unleashed, and Microsoft Forefront Unleashed. His books have been translated into more than a dozen languages. Colin Spence, MCP, MCTS SharePoint, has worked with SharePoint technologies for nearly a decade, helping hundreds of clients architect, implement, and manage customized SharePoint solutions. He speaks, publishes, and blogs regularly on SharePoint technologies. Noel and Spence are partners at Convergent Computing, a leading Microsoft partner in the San Francisco Bay area, and co-authors of SharePoint 2007 Unleashed. ON THE WEB: Download all examples and source code presented in this book from informit.com/title/9780672333255 Category: Microsoft Office 2010 Covers: Microsoft SharePoint 2010 User Level: Intermediate–Advanced




System Center Opalis Integration Server 6.3 Unleashed


Book Description

By using Microsoft's new Opalis IT process automation software, your IT organization can dramatically reduce operational costs and improve efficiency by replacing resource-intensive, error-prone manual activities with standardized, automated processes. Microsoft doesn't sell Opalis as a separately licensed product: thousands of customers who've licensed Microsoft System Center with SMSE/D already have the rights to use it. They simply have to learn how. If this sounds like you, System Center Opalis Integration Server 6.3 Unleashed will help you do so. This book's expert author team offers you start-to-finish, step-by-step coverage of implementing key Opalis 6.3 features for maximum business value. Drawing on their extensive experience, they bring together coverage of related topics and techniques in ways that enable you and IT professionals to deploy Opalis more quickly and apply it more successfully. The authors begin with a high-level overview of Opalis 6.3 and the potential value it offers to your IT organization. Next, it guides you through architecture, installation, policy basics and design, foundation objects and integration packs, the SDK, and best practices based on real-world implementations.




SharePoint Designer 2010 Unleashed


Book Description

Now that Microsoft has made SharePoint Designer a free download, thousands of organizations are adopting it to design state-of-the-art SharePoint sites and solutions. In SharePoint® Designer 2010 Unleashed, Microsoft MVP Kathy Hughes brings together all the information you need to make the most of this powerful tool. Using realistic examples, you are guided through all of Designer 2010’s capabilities, presenting best practices drawn from her extensive experience. First, Hughes quickly reviews the SharePoint 2010 concepts and tools that SharePoint Designer 2010 users must know to be effective. Next, she introduces SharePoint Designer 2010’s revamped interface, shows how to use its core features, and calls attention to its most powerful new improvements. You’ll walk step-by-step through styling and designing sites that offer advanced functionality and consistent branding. Next, you’ll master SharePoint Designer 2010’s toolsets for data integration and workflow development. This book will be invaluable to every user or potential user of SharePoint Designer, including: Web designers, information workers, software developers, system administrators, and IT managers. Kathy Hughes is a Microsoft MVP for SharePoint Server with a Masters Degree in interaction design from the University of Technology in Sydney, Australia. Hughes trains and consults on SharePoint, focusing on design, usability, and customization. She contributed to multiple SharePoint Server 2007 books, and authored a comprehensive five-day SharePoint Server 2007 Designer course used by Mindsharp and its partners worldwide. She speaks regularly at Microsoft events including TechEd Australia and Office DevCon Australia. Get started fast with SharePoint Designer 2010 and SharePoint 2010 Customize SharePoint sites and content with CSS, Web Parts, master pages, and themes Work with site templates Create and adapt content types, columns, lists, and libraries Quickly build new content pages and page layouts Incorporate media, including Silverlight and images Configure RSS, REST, SQL Server, and other data sources Integrate external content types and lists via Business Connectivity Services (BCS) Authenticate data sources and troubleshoot data integration problems Extend the ribbon with custom actions and leverage the dialog framework to enhance the user interface Use SharePoint Designer 2010’s built-in ASP.NET controls Extend site functionality with the XSLT List View and Data View Web Parts Modify out-of-the-box list forms, or build new ones with InfoPath 2010 Adapt Designer 2010’s workflows or build entirely new ones Category: Microsoft® SharePoint® Covers: Microsoft® SharePoint® 2010 User Level: Intermediate–Advanced ON THE WEB: Download all examples and source code presented in this book from informit.com/title/9780672331053




Microsoft Office PerformancePoint Services 2010 Unleashed


Book Description

This is a comprehensive, expert guide to all facets of planning, deploying, managing, and utilizing the brand-new SharePoint 2010 PerformancePoint Services. Authored by business and technical experts and a key member of the Microsoft PerformancePoint Services development team, this book demonstrates exactly how to apply PerformancePoint Services to gain real-time insight into all aspects of business performance. Writing for architects, implementers, developers, and administrators, the authors combine crucial technical information with hands-on insights for success, including a case study that identifies key challenges throughout the project lifecycle. Along the way, the authors bring together realistic, proven techniques for integrating with SharePoint, Microsoft Office, and enterprise data sources. They implement KPIs and scorecards; design effective dashboards; ensure security; administer PerformancePoint Services; present best-practice solutions; and much more. Determine what you want to measure and plan the best ways to measure it Install SharePoint Server 2010 and configure PerformancePoint Services Create effective, easy-to-understand dashboards with the Dashboard Designer Integrate and use multiple data sources including SQL Server, Excel, and SharePoint Build KPIs quickly using the Scorecard Wizard Incorporate indicators and KPIs into scorecard views Utilize PerformancePoint reports including analytic charts and grids, KPI Details, and both Reporting Services and Excel Services reports Build Strategy Maps to visualize sales pipelines, processes, and layouts Secure PerformancePoint data sources, dashboards, and reports Use PerformancePoint APIs to add even more functionality Maintain PerformancePoint Services using SharePoint 2010’s tools and settings Streamline PerformancePoint administration with PowerShell and Cmdlets




Exchange Server 2010 Unleashed


Book Description

Microsoft Exchange Server 2010 Unleashed is the ultimate guide to designing, deploying, managing, troubleshooting, and supporting any Exchange Server 2010 environment, no matter how large or complex. Drawing on their extensive experience with hundreds of enterprise Exchange Server environments--including Exchange Server 2010 early adopters--the authors thoroughly cover every stage of the Exchange Server 2010 lifecycle. They present detailed recommendations, proven tips and tricks, and step-by-step techniques for implementation and migration planning, architecture, installation, administration, security, monitoring, integration, availability, optimization, and much more. Rand Morimoto and his expert colleagues also offer indispensable practical guidance for making the most of Microsoft Exchange Server 2010’s many enhancements--from its improved web access to its enhanced support for Unified Communications and Mobility. Use proven best practices to plan your Exchange Server 2010 implementation Architect higher-performance, lower-cost enterprise Exchange Server environments Maximize the security of your Exchange Server infrastructure, transport, and messages Migrate smoothly from Exchange Server 2003/2007 and Active Directory 2000/2003 to Exchange Server 2010 and Active Directory 2008 Utilize Microsoft Operations Manager to monitor Exchange Server 2010 Use Windows PowerShell to streamline Exchange Server management Integrate other Microsoft technologies, including SharePoint 2007 and Office Communication Server 2007 Leverage the full capabilities of the Outlook Web App (OWA) client Provide robust messaging to non-Windows and non-Outlook systems Implement Exchange Server’s powerful new Database Availability Group replication feature Back up Exchange Server 2010 environments and recover quickly from a disaster Systematically optimize Exchange Server 2010 environments, including storage




Microsoft SharePoint 2013 Unleashed


Book Description

Microsoft SharePoint 2013 Unleashed is the newest version of the best-selling SharePoint Unleashed series by Michael Noel and Colin Spence. Once again, Noel and Spence deliver comprehensive, real-world coverage of everything you need to know to successfully design, implement, configure and use SharePoint 2013 solutions. Leveraging their experience with hundreds of companies of all sizes and from many different industries, Noel and Spence present best practices and expert implementation and configuration methodologies, and focus on the features and tools that provide the most value to busy professionals. This edition adds comprehensive coverage of SharePoint 2013's most valuable and productive new features, including: Using PowerShell automation to streamline management Building virtualized SharePoint environments Strengthening authentication and security Improving user experience via the ribbon interface; new lists, libraries, and templates; and enhanced metadata Integrating with the newest versions of Microsoft Office, Exchange, SQL Server, ForeFront, and System Center Taking full advantage of key mobile and social improvements Using the newest Business Connectivity Services capabilities Improving records management/compliance, web content management, and BI And much more Noel and Spence also offer indispensable guidance on migration, UI, and data store choices, and dependencies; and present crucial infrastructure knowledge that most SharePoint guides ignore.




Microsoft Exchange Server 2013 Unleashed


Book Description

Microsoft Exchange Server 2013 doesn’t just add dozens of new features: It integrates multiple technologies into a common, unified communications system that can add value in many new ways. Now, five leading Exchange Server consultants help you deploy Exchange Server 2013 quickly and smoothly--and then efficiently manage, troubleshoot, and support it for years to come. More than a comprehensive, authoritative reference, Microsoft Exchange Server 2013 Unleashed presents hundreds of helpful tips and tricks based on the authors’ unsurpassed early adopter experience with Exchange Server 2013 in real production environments. Carefully and thoroughly, the authors explain what’s new and different in Microsoft Exchange 2013 and guide you through architecting, planning, implementing, and transitioning to your new Exchange Server environment. They offer best practices for establishing solid Active Directory, DNS, fabric, virtualization, and PKI security environments to support Exchange; implementing high availability and site resilience; and much more. You’ll find expert discussions of security and compliance and uniquely practical and detailed coverage of day-to-day administration, management, maintenance, and optimization. The authors next turn to advanced platform integration, helping you leverage the full benefits of linking Exchange Server, SharePoint, and Unified Messaging. They conclude with a full section on Exchange Server’s dramatically improved support for endpoint clients, including Apple, Android, and Microsoft smartphones and tablets. Detailed information on how to... Use proven best practices to install Exchange Server 2013 from scratch or to upgrade from Exchange Server 2007/2010 Integrate Active Directory, DNS, fabric, and virtualization with Exchange Server 2013 Implement certificate-based Public Key Infrastructure (PKI) Plan, deploy, migrate to, and support public folders Protect your users and organization with both policy-based and content-enforced security Design and implement message archiving, retention, and eDiscovery Administer, optimize, and document your Exchange Server 2013 environment Architect all aspects of an integrated, enterprise-level Exchange Server 2013 environment Integrate Exchange Server with SharePoint Site Mailboxes, Enterprise Search, and more Leverage the robust Outlook client for Windows, Mac, Web, tablet, and mobile phones




Microsoft SQL Server 2008 R2 Unleashed


Book Description

This is the industry’s most comprehensive and useful guide to SQL Server 2008 and 2008 R2. It presents start-to-finish coverage of SQL Server’s core database server and management capabilities, plus complete introductions to Integration, Reporting, and Analysis Services, application development, and much more. Four expert SQL Server administrators, developers, and consultants have packed this book with real-world information, tips, guidelines, and samples drawn from their own extensive experience creating and managing complex database solutions. Writing for intermediate-to-advanced-level SQL Server professionals, they focus on the product’s most complex and powerful capabilities, and its newest tools and features. For example, you’ll find invaluable information on administering SQL Server more efficiently, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, and tuning performance. The accompanying CD-ROM contains an extraordinary library of practical tools and information including sample databases and all code examples. Whether you’re responsible for SQL Server 2008 analysis, design, implementation, support, administration, or troubleshooting, no other book offers you this much value. Understand the Microsoft SQL Server 2008 environment, R2’s newest features, and each edition’s capabilities Manage SQL Server 2008 more effectively with SQL Server Management Studio, the SQLCMD command-line query tool, and Powershell Efficiently manage security, users, backup/restore, replication, Database Mail, and database objects—from tables and indexes to stored procedures and triggers Increase availability with clustering, database mirroring, and other features Use new Policy-Based Management to centrally configure and operate SQL Server throughout the organization Use SQL Server Profiler to capture queries and identify bottlenecks Improve performance by optimizing queries, design more effective databases, and manage workloads with the new Resource Governor Develop applications using SQL Server 2008’s enhancements to T-SQL and SQLCLR, .NET integration, LINQ to SQL, XML, and XQuery Make the most of Analysis Services, Integration Services, and Reporting Services—especially Microsoft’s new R2 reporting improvements Improve data security using Column-level and Transparent Data Encryption CD-ROM includes: 15 additional chapters Code samples, scripts, and databases utilized within the book Free version of SQL Shot (performance & tuning software)




Microsoft SQL Server 2012 Unleashed


Book Description

Buy the print version of� Microsoft SQL Server 2012 Unleashed and get the eBook version for free! eBook version includes chapters 44-60 not included in the print. See inside the book for access code and details. � With up-to-the-minute content, this is the industry's most complete, useful guide to SQL Server 2012. � You'll find start-to-finish coverage of SQL Server's core database server and management capabilities: all the real-world information, tips, guidelines, and samples you'll need to create and manage complex database solutions. The additional online chapters add extensive coverage of SQL Server Integration Services, Reporting Services, Analysis Services, T-SQL programming, .NET Framework integration, and much more. � Authored by four expert SQL Server administrators, designers, developers, architects, and consultants, this book reflects immense experience with SQL Server in production environments. Intended for intermediate-to-advanced-level SQL Server professionals, it focuses on the product's most complex and powerful capabilities, and its newest tools and features. Understand SQL Server 2012's newest features, licensing changes, and capabilities of each edition Manage SQL Server 2012 more effectively with SQL Server Management Studio, the SQLCMD command-line query tool, and Powershell Use Policy-Based Management to centrally configure and operate SQL Server Utilize the new Extended Events trace capabilities within SSMS Maximize performance by optimizing design, queries, analysis, and workload management Implement new best practices for SQL Server high availability Deploy AlwaysOn Availability Groups and Failover Cluster Instances to achieve enterprise-class availability and disaster recovery Leverage new business intelligence improvements, including Master Data Services, Data Quality Services and Parallel Data Warehouse Deliver better full-text search with SQL Server 2012's new Semantic Search Improve reporting with new SQL Server 2012 Reporting Services features Download the following from informit.com/title/9780672336928: Sample databases and code examples � �