High Impact Data Visualization with Power View, Power Map, and Power BI helps you take business intelligence delivery to a new level that is interactive, engaging, even fun, all while driving commercial success through sound decision-making. Learn to harness the power of Microsoft’s flagship, self-service business intelligence suite to deliver compelling and interactive insight with remarkable ease. Learn the essential techniques needed to enhance the look and feel of reports and dashboards so that you can seize your audience’s attention and provide them with clear and accurate information. Also learn to integrate data from a variety of sources and create coherent data models displaying clear metrics and attributes. Power View is Microsoft's ground-breaking tool for ad-hoc data visualization and analysis. It's designed to produce elegant and visually arresting output. It's also built to enhance user experience through polished interactivity. Power Map is a similarly powerful mechanism for analyzing data across geographic and political units. Power Query lets you load, shape and streamline data from multiple sources. PowerPivot can extend and develop data into a dynamic model. Power BI allows you to share your findings with colleagues, and present your insights to clients. High Impact Data Visualization with Power View, Power Map, and Power BI helps you master this suite of powerful tools from Microsoft. You'll learn to identify data sources, and to save time by preparing your underlying data correctly. You'll also learn to deliver your powerful visualizations and analyses through the cloud to PCs, tablets and smartphones. Simple techniques take raw data and convert it into information. Slicing and dicing metrics delivers interactive insight. Visually arresting output grabs and focuses attention on key indicators.

Master Windows 8.1/Windows Runtime Programming Through 80 Expert Projects This is the most complete, hands-on, solutions-focused guide to programming modern Windows applications with the Windows Runtime. Leading Windows development consultants Jeremy Likness and John Garland present easy-to-adapt C# and XAML example code for more than 80 projects. Their real-world application examples help you apply Windows 8.1’s best improvements, including large tiles, the new search control, flyouts, command bars, native WinRT networking, and new deployment and sideloading options. Drawing on their pioneering experience, they illuminate key areas of the Windows Runtime API, offering uniquely detailed coverage of encryption, cloud connectivity, devices, printers, and media integration. You’ll find cutting-edge tips and tricks available in no other book. This is an indispensable resource for all intermediate-to-advanced Windows developers, and for any architect building desktop, tablet, or mobile solutions with Microsoft technologies. Its focus on both C# and XAML will make it valuable to millions of Windows developers already familiar with Silverlight, WPF, and/or .NET. Coverage includes • Creating robust app interfaces with the newest XAML controls, including flyouts and command bars • Saving data in a persistent “roaming zone” for syncing across Windows 8.1 devices • Using Visual State Manager (VSM) to build apps that adapt to various device resolutions and orientations • Integrating virtually any form of data into your apps • Connecting with web services, RSS, Atom feeds, and social networks • Securing apps via authentication, encrypting, signing, and single sign-on with Microsoft Account, Facebook, Google, and more • Leveraging Windows 8.1 media enhancements that improve battery life and app performance • Networking more effectively with Windows 8.1’s revamped HTTP implementation and new location APIs • Using Tiles and Toasts to keep apps alive and connected, even when they aren’t running • Enabling users to send content between devices via NFC tap and send • Ensuring accessibility and globalizing your apps • Efficiently debugging, optimizing, packaging, and deploying your apps • Building sideloadable apps that don’t have to be published in Windows Store “This book doesn’t just focus on singular concepts, it also provides end-to-end perspective on building an app in WinRT. It is one of those essential tools for Windows developers that will help you complete your software goals sooner than without it!” —Tim Heuer, Principal Program Manager Lead, XAML Platform, Microsoft Corporation

This IBM® Redbooks® publication provides deployment guidelines, workload estimates, and preferred practices for clients who want a proven IBM technology stack for virtualized VMware and Microsoft environments. The result is a Reference Architecture for Virtualized Environments (RAVE) that uses VMware vSphere or Microsoft Hypervisor, IBM System x® or IBM BladeCenter® server, IBM System Networking, and IBM System Storage® N series with Clustered Data ONTAP as a storage foundation. The reference architecture can be used as a foundation to create dynamic cloud solutions and make full use of underlying storage features and functions. This book provides a blueprint that illustrates how clients can create a virtualized infrastructure and storage cloud to help address current and future data storage business requirements. It explores the solutions that IBM offers to create a storage cloud solution addressing client needs. This book also shows how the Reference Architecture for Virtualized Environments and the extensive experience of IBM in cloud computing, services, proven technologies, and products support a Smart Storage Cloud solution that is designed for your storage optimization efforts. This book is for anyone who wants to learn how to successfully deploy a virtualized environment. It is also written for anyone who wants to understand how IBM addresses data storage and compute challenges with IBM System Storage N series solutions with IBM servers and networking solutions. This book is suitable for IT architects, business partners, IBM clients, storage solution integrators, and IBM sales representatives.

The #1 Easy, Common-Sense Guide to SQL Queries—Updated for Today’s Databases, Standards, and Challenges SQL Queries for Mere Mortals ® has earned worldwide praise as the clearest, simplest tutorial on writing effective SQL queries. The authors have updated this hands-on classic to reflect new SQL standards and database applications and teach valuable new techniques. Step by step, John L. Viescas and Michael J. Hernandez guide you through creating reliable queries for virtually any modern SQL-based database. They demystify all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data. Three brand-new chapters teach you how to solve a wide range of challenging SQL problems. You’ll learn how to write queries that apply multiple complex conditions on one table, perform sophisticated logical evaluations, and think “outside the box” using unlinked tables. Coverage includes -- Getting started: understanding what relational databases are, and ensuring that your database structures are sound -- SQL basics: using SELECT statements, creating expressions, sorting information with ORDER BY, and filtering data using WHERE -- Summarizing and grouping data with GROUP BY and HAVING clauses -- Drawing data from multiple tables: using INNER JOIN, OUTER JOIN, and UNION operators, and working with subqueries -- Modifying data sets with UPDATE, INSERT, and DELETE statements Advanced queries: complex NOT and AND, conditions, if-then-else using CASE, unlinked tables, driver tables, and more Practice all you want with downloadable sample databases for today’s versions of Microsoft Office Access, Microsoft SQL Server, and the open source MySQL database. Whether you’re a DBA, developer, user, or student, there’s no better way to master SQL. informit.com/aw forMereMortals.com

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide introduces you to Microsoft's BI tools and systems. You'll gain hands-on experience building solutions that handle data warehousing, reporting, and predictive analytics. With step-by-step tutorials, you'll be equipped to transform data into actionable insights. What this Book will help me do Understand and implement multidimensional data models using SSAS and MDX. Write and use DAX queries and leverage SSAS tabular models effectively. Improve and maintain data integrity using MDS and DQS tools. Design and develop polished, insightful dashboards and reports using PerformancePoint, Power View, and SSRS. Explore advanced data analysis features, such as Power Query, Power Map, and basic data mining techniques. Author(s) Abolfazl Radgoudarzi and Reza Rad are experienced practitioners and educators in the field of business intelligence. They specialize in SQL Server BI technologies and have extensive careers helping organizations harness data for decision-making. Their approach combines clear explanations with practical examples, ensuring readers can effectively apply what they learn. Who is it for? This book is ideal for database developers, system analysts, and IT professionals looking to build strong foundations in Microsoft SQL Server's BI technologies. Beginners in business intelligence or data management will find the topics accessible. Intermediate practitioners will expand their ability to build complete BI solutions. It's designed for anyone eager to develop skills in data modeling, analysis, and visualization.

Bridge the big data gap with Microsoft Business Intelligence Tools for Excel Analysts The distinction between departmental reporting done by business analysts with Excel and the enterprise reporting done by IT departments with SQL Server and SharePoint tools is more blurry now than ever before. With the introduction of robust new features like PowerPivot and Power View, it is essential for business analysts to get up to speed with big data tools that in the past have been reserved for IT professionals. Written by a team of Business Intelligence experts, Microsoft Business Intelligence Tools for Excel Analysts introduces business analysts to the rich toolset and reporting capabilities that can be leveraged to more effectively source and incorporate large datasets in their analytics while saving them time and simplifying the reporting process. Walks you step-by-step through important BI tools like PowerPivot, SQL Server, and SharePoint and shows you how to move data back and forth between these tools and Excel Shows you how to leverage relational databases, slice data into various views to gain different visibility perspectives, create eye-catching visualizations and dashboards, automate SQL Server data retrieval and integration, and publish dashboards and reports to the web Details how you can use SQL Server's built-in functions to analyze large amounts of data, Excel pivot tables to access and report OLAP data, and PowerPivot to create powerful reporting mechanisms You'll get on top of the Microsoft BI stack and all it can do to enhance Excel data analysis with this one-of-a-kind guide written for Excel analysts just like you.

Learn SQL Server Administration in a Month of Lunches is the perfect way to get started with SQL Server operations, including maintenance, backup and recovery, high availability, and performance monitoring. In about an hour a day over a month, you'll learn exactly what you can do, and what you shouldn't touch. Most importantly, you'll learn the day-to-day tasks and techniques you need to keep SQL Server humming along smoothly. About the Technology About the Book Microsoft SQL Server is used by millions of businesses, ranging in size from Fortune 500s to small shops worldwide. Whether you're just getting started as a DBA, supporting a SQL Server-driven application, or you've been drafted by your office as the SQL Server admin, you do not need a thousand-page book to get up and running. Learn SQL Server Administration in a Month of Lunches is the perfect way to get started with SQL Server. This concise, easy-to-read book skips academic introductions and teaches you day-to-day techniques for maintenance, backup and recovery, performance monitoring, and more. Each of the 21 short lessons gives you practical takeaways you'll use over and over. What's Inside Master the basics—ndexes, logins, backup, recovery... and more Learn what you can and cannot do when supporting a third-party application Monitor and improve performance Written by expert trainer and bestselling author Don Jones About the Reader About the Author Don Jones is a Microsoft MVP, speaker, and trainer. He is the creator of the Month of Lunches series and author of over 50 books on PowerShell, IIS, Active Directory, SCCM, SQL Server, and more. Quotes Concise and easy to understand, even on the most challenging topics. - Spike Xavier, Transmission IT, LLC Don has written another gem equal to his PowerShell titles. - Carm Vecchio, Computer Science Corporation (CSC) The essentials of SQL Server Administration, distilled into a friendly format. - Adam M Dutko, RunByMany, LLC Extremely useful for anyone managing or trying to manage SQL Server. - Maqbool Patel, PhD, MEDHOST Contains all the steps needed to become a professional DBA. - Ian Stirk, Stirk Consultancy, Ltd

Fill the gap between planning and doing with SSIS 2014 The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change. New tools come with new best practices, and Professional Microsoft SQL Server 2014 Integration Services will keep you ahead of the curve. SQL Server MVP Brian Knight is the most respected name in the business, and your ultimate guide to navigating the changes to use Microsoft SQL Server Integration Services 2014 to your utmost advantage. Implement new best practices for effective use of SSIS Work through tutorials for hands-on learning of complex techniques Read case studies that illustrate the more advanced concepts Learn directly from the foremost authority on SSIS SQL Server Integration Services is a complex tool, but it's the lifeblood of your work. You need to know it inside out, and you must understand the full potential of its capabilities in order to use it effectively. You need to make sure the right architecture is in place. Professional Microsoft SQL Server 2014 Integration Services is your roadmap to understanding SSIS on a fundamental level, and setting yourself up for success.

Use Excel 2013’s statistical tools to transform your data into knowledge Conrad Carlberg shows how to use Excel 2013 to perform core statistical tasks every business professional, student, and researcher should master. Using real-world examples, Carlberg helps you choose the right technique for each problem and get the most out of Excel’s statistical features, including recently introduced consistency functions. Along the way, he clarifies confusing statistical terminology and helps you avoid common mistakes. You’ll learn how to use correlation and regression, analyze variance and covariance, and test statistical hypotheses using the normal, binomial, t, and F distributions. To help you make accurate inferences based on samples from a population, this edition adds two more chapters on inferential statistics, covering crucial topics ranging from experimental design to the statistical power of F tests. Becoming an expert with Excel statistics has never been easier! You’ll find crystal-clear instructions, insider insights, and complete step-by-step projects—all complemented by extensive web-based resources. Master Excel’s most useful descriptive and inferential statistical tools Tell the truth with statistics—and recognize when others don’t Accurately summarize sets of values Infer a population’s characteristics from a sample’s frequency distribution Explore correlation and regression to learn how variables move in tandem Use Excel consistency functions such as STDEV.S() and STDEV.P() Test differences between two means using z tests, t tests, and Excel’s Data Analysis Add-in Use ANOVA to test differences between more than two means Explore statistical power by manipulating mean differences, standard errors, directionality, and alpha Take advantage of Recommended PivotTables, Quick Analysis, and other Excel 2013 shortcuts

This comprehensive guide prepares intermediate BizTalk developers to excel in the Microsoft BizTalk Server 2010 (70-595) certification exam. With in-depth coverage of essential concepts, practical examples, and end-to-end solutions, the book ensures you have the skills and knowledge necessary to become a BizTalk expert. What this Book will help me do Master the core architecture and functionalities of Microsoft BizTalk Server. Develop skills to create advanced schemas and maps with enhanced logic functionalities. Understand how to manage orchestrations, transactions, and handle exceptions efficiently. Learn administrative tasks, including configuration and troubleshooting, for BizTalk server environments. Explore integration with web services, WCF, and additional BizTalk features like EDI and BAM. Author(s) This book is written by a team of experienced BizTalk professionals who have hands-on working knowledge with Microsoft BizTalk Server. Their expertise encompasses enterprise-level solution architecture and implementation. They bring their comprehensive understanding and teaching aptitude together in this book, ensuring a balance of detailed technical content and accessible learning. Who is it for? This book is ideal for intermediate-level BizTalk developers focusing on obtaining the Microsoft BizTalk Server 2010 (70-595) certification. It is suitable for individuals with basic knowledge of BizTalk concepts and working with orchestrations. A foundation in WCF and understanding of EDI is recommended to benefit fully from the content of this book.

Tap the power of Big Data with Microsoft technologies Big Data is here, and Microsoft's new Big Data platform is a valuable tool to help your company get the very most out of it. This timely book shows you how to use HDInsight along with HortonWorks Data Platform for Windows to store, manage, analyze, and share Big Data throughout the enterprise. Focusing primarily on Microsoft and HortonWorks technologies but also covering open source tools, Microsoft Big Data Solutions explains best practices, covers on-premises and cloud-based solutions, and features valuable case studies. Best of all, it helps you integrate these new solutions with technologies you already know, such as SQL Server and Hadoop. Walks you through how to integrate Big Data solutions in your company using Microsoft's HDInsight Server, HortonWorks Data Platform for Windows, and open source tools Explores both on-premises and cloud-based solutions Shows how to store, manage, analyze, and share Big Data through the enterprise Covers topics such as Microsoft's approach to Big Data, installing and configuring HortonWorks Data Platform for Windows, integrating Big Data with SQL Server, visualizing data with Microsoft and HortonWorks BI tools, and more Helps you build and execute a Big Data plan Includes contributions from the Microsoft and HortonWorks Big Data product teams If you need a detailed roadmap for designing and implementing a fully deployed Big Data solution, you'll want Microsoft Big Data Solutions.

Enhance your SAS ODS output with this collection of basic to novel ideas.

SAS Output Delivery System (ODS) expert Kevin D. Smith has compiled a cookbook-style collection of his top ODS tips and techniques to teach you how to bring your reports to a new level and inspire you to see ODS in a new light.

This collection of code techniques showcases some of the most interesting and unusual methods you can use to enhance your reports within the SAS Output Delivery System. It includes general ODS tips, as well as techniques for styles, enhancing tabular output, ODS HTML, ODS PDF, ODS Microsoft Excel destinations, and ODS DOCUMENT.

Smith offers tips based on his own extensive knowledge of ODS, as well as those inspired by questions that frequently come up in his interactions with SAS users. There are simple techniques for beginners who have a minimal amount of ODS knowledge and advanced tips for the more adventurous SAS user. Together, these helpful methods provide a strong foundation for your ODS development and inspiration for building on and creating new, even more advanced techniques on your own.

This book is part of the SAS Press program.

"Expert Cube Development with SSAS Multidimensional Models" is a comprehensive guide designed for professionals looking to elevate their competence in creating and optimizing SSAS cube solutions. Focused on the multidimensional model, this book provides a detailed, pragmatic approach to delivering high-performance Business Intelligence solutions. What this Book will help me do Master the core features of multidimensional modeling with SSAS. Develop efficient and scalable OLAP cubes for business analysis. Implement advanced calculations and measures using MDX. Optimize and troubleshoot SSAS performance for real-world scenarios. Integrate SSAS models for insightful data visualization. Author(s) The authors of this book are seasoned SSAS consultants and developers, each with years of hands-on experience working with Microsoft Analysis Services in enterprise environments. Their deep understanding of multidimensional modeling shines through in this detailed and well-structured book, providing readers with not only practical guidance but also invaluable tips drawn from real-world projects. Who is it for? This book is tailored for BI developers and data professionals who already have some familiarity with Microsoft Analysis Services and want to deepen their expertise in SSAS multidimensional models. It is ideal for those looking to enhance their ability to design, implement, and optimize robust cube solutions for complex business scenarios. With step-by-step tutorials, it caters to intermediate to advanced learners seeking to take their SSAS skills to the next level.

Pro Microsoft HDInsight is a complete guide to deploying and using Apache Hadoop on the Microsoft Windows Azure Platforms. The information in this book enables you to process enormous volumes of structured as well as non-structured data easily using HDInsight, which is Microsoft's own distribution of Apache Hadoop. Furthermore, the blend of Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) offerings available through Windows Azure lets you take advantage of Hadoop's processing power without the worry of creating, configuring, maintaining, or managing your own cluster. With the data explosion that is soon to happen, the open source Apache Hadoop Framework is gaining traction, and it benefits from a huge ecosystem that has risen around the core functionalities of the Hadoop distributed file system (HDFS™) and Hadoop Map Reduce. Pro Microsoft HDInsight equips you with the knowledge, confidence, and technique to configure and manage this ecosystem on Windows Azure. The book is an excellent choice for anyone aspiring to be a data scientist or data engineer, putting you a step ahead in the data mining field. Guides you through installation and configuration of an HDInsight cluster on Windows Azure Provides clear examples of configuring and executing Map Reduce jobs Helps you consume data and diagnose errors from the Windows Azure HDInsight Service What you'll learn Create and Manage HDInsight clusters on Windows Azure Understand the different HDInsight services and configuration files Develop and run Map Reduce jobs using .NET and PowerShell Consume data from client applications like Microsoft Excel and Power View Monitor job executions and logs Troubleshoot common problems Who this book is for Pro Microsoft HDInsight: Hadoop on Windows is an excellent choice for developers in the field of business intelligence and predictive analysis who want that extra edge in technology on Microsoft Windows and Windows Azure platforms. The book is for people who love to slice and dice data, and identify trends and patterns through analysis of data to help in creative and intelligent decision making.

The 'SQL Server Analysis Services 2012 Cube Development Cookbook' equips you with the practical skills needed to design and implement OLAP cubes using both multidimensional and tabular models. By working through hands-on recipes, you'll quickly gain the expertise to create robust Business Intelligence solutions with SQL Server Analysis Services. What this Book will help me do Build and enhance multidimensional and tabular models for effective data analysis. Implement key OLAP features like dimensions, cubes, actions, and aggregations. Scale and optimize your Business Intelligence solutions for enterprise-level performance. Utilize MDX and DAX languages proficiently to query and manipulate data. Develop skills in securing, monitoring, and troubleshooting SQL Server Analysis Services. Author(s) None Dewald is an experienced business intelligence professional with years of hands-on expertise with SQL Server Analysis Services. His approach to teaching focuses on practical application and equipping his audience with tools to be successful in deploying and maintaining BI solutions. Who is it for? This book is perfect for BI and ETL developers who work with SQL Server Analysis Services to build OLAP cubes. It assumes familiarity with relational database management systems, Excel, and SQL. If you're looking to deepen your understanding of Microsoft's BI stack and improve your practical skills in SSAS, this book is for you.

BizTalk 2013 Recipes provides ready-made solutions to BizTalk Server 2013 developers. The recipes in the book save you the effort of developing your own solutions to common problems that have been solved many times over. The solutions demonstrate sound practice, the result of hard-earned wisdom by those who have gone before. Presented in a step-by-step format with clear code examples and explanations, the solutions in BizTalk 2013 Recipes help you take advantage of new features and deeper capabilities in BizTalk Server 2013. You'll learn to integrate your solutions with the cloud, configure BizTalk on Azure, work with electronic data interchange (EDI), and deploy the growing range of adapters for integrating with the different systems and technologies that you will encounter. You'll find recipes covering all the core areas: schemas, maps, orchestrations, messaging and more. BizTalk Server 2013 is Microsoft's market-leading platform for orchestrating process flow across disparate applications. BizTalk 2013 Recipes is your key to unlocking the full power of that platform. What you'll learn Automate business processes across different systems in your enterprise. Build, test, and deploy complex maps and schemas. Implement the business rules engine (BRE). Develop business activity monitoring (BAM) solutions. Manage electronic data interchange (EDI) with trading partners. Monitor and troubleshoot automated processes. Deploy BizTalk to Azure and build cloud based solutions. Who this book is for BizTalk 2013 Recipes is aimed at developers working in Microsoft BizTalk Server 2013. Experienced BizTalk developers will find great value in the information around new functionality in the 2013 release such as that for cloud based integrations. Those brand new to BizTalk will appreciate the clear examples of core functionality that help them understand how best to design and deploy BizTalk Server solutions.

Buy the print version of¿ 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. Microsoft SQL Server 2012 Unleashed ¿ 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 book, "Microsoft Visio 2013 Business Process Diagramming and Validation," is your comprehensive guide to leveraging the features of Microsoft Visio 2013 Professional for creating and validating structured diagrams. Through practical tutorials and code examples, it helps you master process diagramming and validation techniques for a range of business needs. What this Book will help me do Understand and utilize structured diagram functionality including basic and cross-functional flowcharts. Develop and apply custom validation rules to ensure diagram correctness and compliance using Visio 2013. Create and use advanced tools such as the Rules Tools add-on to enhance diagram validation. Learn to integrate Visio with platforms like SharePoint 2013 and Office365. Gain technical skills to build, publish, and share Visio templates and rule sets. Author(s) The authors of this book bring rich technical expertise in Microsoft Visio and business process management. They have extensive experience developing user-focused tutorials and tools, ensuring you gain both theoretical knowledge and practical skills. Their accessible writing makes complex topics approachable for a variety of learners. Who is it for? This book is for Microsoft Visio 2013 Professional Edition users who want to advance their skills in diagramming and validation. It's ideal for professionals who seek to improve diagram compliance and efficiency, including developers, analysts, and project managers. If you're already familiar with Visio basics, this book will take your skills to the next level by introducing advanced techniques for automation and standardization.

Dive deep inside the architecture of SQL Server 2012 Explore the core engine of Microsoft SQL Server 2012—and put that practical knowledge to work. Led by a team of SQL Server experts, you’ll learn the skills you need to exploit key architectural features. Go behind the scenes to understand internal operations for creating, expanding, shrinking, and moving databases—whether you’re a database developer, architect, or administrator. Discover how to: Dig into SQL Server 2012 architecture and configuration Use the right recovery model and control transaction logging Reduce query execution time through proper index design Track events, from triggers to the Extended Event Engine Examine internal structures with database console commands Transcend row-size limitations with special storage capabilities Choose the right transaction isolation level and concurrency model Take control over query plan caching and reuse

Geospatial mapping applications have become hugely popular in recent years. With smart-phone and tablet numbers snow-balling this trend looks set to continue well into the future. Indeed, it is true to say that in today's mobile world location-aware apps are becoming the norm rather than the exception. In Microsoft Mapping author Ray Rischpater showcases Microsoft's Bing Maps API and demonstrates how its integration features make it by far the strongest mapping candidate for business that are already using Windows 8 or the .NET Framework. Whether you want to build a new app from scratch of add a few modest geospatial features to your existing website Ray's carefully chosen examples will provide you with both the inspiration and the code you need to achieve your goals. What you'll learn Fully working code samples that show the concepts in use with ASP.NET 4.5, Windows 8 and Windows Phone. Complete solutions to the common problems of geospatial development: visualisation, hosting and localization of services are all explained. Demonstrates how the Bing Maps API can be connected to the Azure Cloud in order to provide a stand-alone mapping bolt-on with little additional up-front cost and great reliability. Unique coverage of how the Bing Maps API can be implanted within Windows Phone and iOS apps to provide a robust service tailored to the capabilities of each device. Who this book is for This book is for experienced Microsoft developers with a grounding in C# and .NET together with a basic understanding of WCF.