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

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.

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

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)

Buy the print SharePoint 2013 Unleashed and get the eBook version for free! See inside the book for access code and details. ¿ SharePoint 2013 Unleashed is the most complete, practical resource for¿all administrators, managers, architects, users, and developers to make the most of Microsoft’s powerful new SharePoint 2013 platform. ¿ Drawing on their experience implementing SharePoint solutions in hundreds of organizations, Michael Noel and Colin Spence focus on what administrators and knowledge workers really need to know to effectively design, implement, configure, and use SharePoint 2013. They fully address key SharePoint 2013 innovations such as PowerShell scripting to automate administration and farm provisioning; better virtualization support; improved security and authentication; new business intelligence tools, social networking improvements; enhanced lists; libraries; metadata; and more. ¿ Step by step, through easy-to-understand examples, they help you streamline administration, optimize performance, control cost, and implement high-value solutions for collaboration, document and web content management, and business intelligence. ¿ Detailed information on how to... ¿ Optimize your SharePoint 2013 design/deployment plan, right-size your server farm(s), and improve scalability ¿ Reduce costs by virtualizing your SharePoint environment and automating farm deployment ¿ Optimize search with metadata, content types, and taxonomies ¿ Streamline management with PowerShell and the SharePoint Central Administration tool ¿ Efficiently monitor, back up, and restore SharePoint environments ¿ Understand new Shredded Storage capabilities and new Service Applications built into the infrastructure layer of SharePoint ¿ Deploy SharePoint’s improved social networking features, including microblogging ¿ Deploy SharePoint as an extranet using various external authentication providers ¿ Use powerful out-of-the-box workflows—and create your own with SharePoint Designer 2013 and Visual Studio 2013 ¿ Build Business Intelligence solutions with PerformancePoint and Business Connectivity Services ¿

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

This comprehensive resource will help you automate and optimize all facets of service management with System Center 2012 Service Manager. Expert consultants offer deep “in the trenches” insights for improving problem resolution, change control, release management, asset lifecycle management, chargeback, and more. You’ll learn how to implement high-value best practices from ITIL and the Microsoft Operations Framework. The authors begin with an expert overview of Service Manager, its evolution, and its new capabilities. Next, they walk through overall planning, design, implementation, and upgrades. Then, to help you focus your efforts, they present stepwise coverage of all topics in each feature area, linking technical information about Service Manager with essential knowledge about the technologies it depends on. Whatever your role in deploying or running Service Manager, this guide will help you deliver more responsive support at lower cost and drive more value from all your IT investments. • Leverage MOF and ITIL processes built into System Center 2012 Service Manager • Plan and design your Service Manager deployment • Install Service Manager or upgrade from earlier versions • Efficiently administer work and configuration items • Use connectors to integrate with Active Directory, Exchange, and System Center components • Create service maps • Enable end user access through Service Manager’s self-service portal • Implement incident, problem, change, and release management • Utilize workflows to automate key support processes • Create service level agreements with calendars, metrics, and objectives • Provide quick access to a standardized catalog of services • Use notification to ensure that Service Manager items are promptly addressed • Secure Service Manager and its data warehouse/reporting platform • Perform maintenance, backup, and recovery • Manage Service Manager performance • Customize Service Manager

System Center Service Manager 2010 offers enterprises a complete, integrated platform for adopting and automating service management best practices, such as those found in ITIL and Microsoft Operations Framework (MOF). Now, there’s a comprehensive, independent reference and technical guide to this powerful product. A team of expert authors offers step-by-step coverage of related topics in every feature area, organized to help IT professionals quickly plan, design, implement, and use Service Manager 2010. After introducing the product and its relationship with the rest of Microsoft’s System Center suite, the authors present authoritative coverage of Service Manager’s capabilities for incident and problem resolution, change control, configuration management, and compliance. Readers will also find expert guidance for integrating Service Manager with related Microsoft technologies. This book is an indispensable resource for every IT professional planning, installing, deploying, and/or administering Service Manager, including ITIL, MOF, and other IT consultants; system administrators; and developers creating customized solutions. • Understand Service Manager’s architecture and components • Discover how Service Manager supports ITIL and MOF processes • Accurately scope and specify your implementation to reflect organizational needs • Plan to provide redundancy, ensure scalability, and support virtualization • Design, deploy, and maintain Service Manager with security in mind • Use Service Manager’s consoles and portals to provide the right resources to each user • Create complete service maps with Service Manager’s business services • Fully automate incident management and ticketing • Implement best processes for identifying and addressing root causes of problems • Systematically manage the life cycle of changes • Use Service Manager to strengthen governance, risk management, and compliance • Customize Service Manager’s data layer, workflows, and presentation layer • Use management packs to simplify service desk customization • Make the most of Service Manager’s reporting and dashboards

NOTE: This title is also available as a free eBook on the Microsoft Download Center. It is offered for sale in print format as a convenience. Get a head start evaluating SQL Server 2014 - guided by two experts who have worked with the technology from the earliest beta. Based on Community Technology Preview 2 (CTP2) software, this guide introduces new features and capabilities, with practical insights on how SQL Server 2014 can meet the needs of your business. Get the early, high-level overview you need to begin preparing your deployment now. Coverage includes: SQL Server 2014 Editions and engine enhancements Mission-critical performance enhancements Hybrid cloud enhancements Self-service Business Intelligence enhancements in Microsoft Excel Enterprise information management enhancements Big Data solutions