IBM® Db2® Mirror for i provides a new solution for continuous availability for an IBM i environment based on an active-active clustering design that uses a low-latency communication protocol for synchronous database replication. With Db2 Mirror, IBM i customers can benefit from continuous application availability for both planned and unplanned outages. Db2 Mirror can help reduce or eliminate application downtime for regular maintenance operations such as program temporary fix (PTF) installations, operating system (OS) upgrades, or for planned server outages. This IBM Redpaper publication provides a broad overview and understanding of this new solution by covering its architecture, positioning, planning, and implementation aspects. It provides an introduction reference for a seller or technical specialist audience to become familiar with the new Db2 Mirror solution.

Get the most out of MongoDB using a problem-solution approach. This book starts with recipes on the MongoDB query language, including how to query various data structures stored within documents. These self-contained code examples allow you to solve your MongoDB problems without fuss. MongoDB Recipes describes how to use advanced querying in MongoDB, such as indexing and the aggregation framework. It demonstrates how to use the Compass function, a GUI client interacting with MongoDB, and how to apply data modeling to your MongoDB application. You’ll see recipes on the latest features of MongoDB 4 allowing you to manage data in an efficient manner using MongoDB. What You Will Learn Work with the MongoDB document model Design MongoDB schemas Use the MongoDB query language Harness the aggregation framework Create replica sets and sharding in MongoDB Who This Book Is For Developers and professionals who work with MongoDB.

Create database designs that scale, meet business requirements, and inherently work toward keeping your data structured and usable in the face of changing business models and software systems. This book is about database design theory. Design theory is the scientific foundation for database design, just as the relational model is the scientific foundation for database technology in general. Databases lie at the heart of so much of what we do in the computing world that negative impacts of poor design can be extraordinarily widespread. This second edition includes greatly expanded coverage of exotic and little understood normal forms such as: essential tuple normal form (ETNF), redundancy free normal form (RFNF), superkey normal form (SKNF), sixth normal form (6NF), and domain key normal form (DKNF). Also included are new appendixes, including one that provides an in-depth look into the crucial notion of data consistency.Sequencing of topics has been improved, and many explanations and examples have been rewritten and clarified based upon the author’s teaching of the content in instructor-led courses. This book aims to be different from other books on design by bridging the gap between the theory of design and the practice of design. The book explains theory in a way that practitioners should be able to understand, and it explains why that theory is of considerable practical importance. Reading this book provides you with an important theoretical grounding on which to do the practical work of database design. Reading the book also helps you in going to and understanding the more academic texts as you build your base of knowledge and expertise. Anyone with a professional interest in database design can benefit from using this book as a stepping-stone toward a more rigorous design approach and more lasting database models. What You Will Learn Understand what design theory is and is not Be aware of the two different goals of normalization Know which normal forms are truly significant Apply design theory in practice Be familiar with techniques for dealing with redundancy Understand what consistency is and why it is crucially important Who This Book Is For Those having a professional interest in database design, including data and database administrators; educators and students specializing in database matters; information modelers and database designers; DBMS designers, implementers, and other database vendor personnel; and database consultants. The book is product independent.

The Comprehensive Guide to Engineering and Implementing Privacy Best Practices As systems grow more complex and cybersecurity attacks more relentless, safeguarding privacy is ever more challenging. Organizations are increasingly responding in two ways, and both are mandated by key standards such as GDPR and ISO/IEC 27701:2019. The first approach, privacy by design, aims to embed privacy throughout the design and architecture of IT systems and business practices. The second, privacy engineering, encompasses the technical capabilities and management processes needed to implement, deploy, and operate privacy features and controls in working systems. In Information Privacy Engineering and Privacy by Design, internationally renowned IT consultant and author William Stallings brings together the comprehensive knowledge privacy executives and engineers need to apply both approaches. Using the techniques he presents, IT leaders and technical professionals can systematically anticipate and respond to a wide spectrum of privacy requirements, threats, and vulnerabilities–addressing regulations, contractual commitments, organizational policies, and the expectations of their key stakeholders. • Review privacy-related essentials of information security and cryptography • Understand the concepts of privacy by design and privacy engineering • Use modern system access controls and security countermeasures to partially satisfy privacy requirements • Enforce database privacy via anonymization and de-identification • Prevent data losses and breaches • Address privacy issues related to cloud computing and IoT • Establish effective information privacy management, from governance and culture to audits and impact assessment • Respond to key privacy rules including GDPR, U.S. federal law, and the California Consumer Privacy Act This guide will be an indispensable resource for anyone with privacy responsibilities in any organization, and for all students studying the privacy aspects of cybersecurity.

Mastering chance has, for a long time, been a preoccupation of mathematical research. Today, we possess a predictive approach to the evolution of systems based on the theory of probabilities. Even so, uncovering this subject is sometimes complex, because it necessitates a good knowledge of the underlying mathematics. This book offers an introduction to the processes linked to the fluctuations in chance and the use of numerical methods to approach solutions that are difficult to obtain through an analytical approach. It takes classic examples of inventory and queueing management, and addresses more diverse subjects such as equipment reliability, genetics, population dynamics, physics and even market finance. It is addressed to those at Master's level, at university, engineering school or management school, but also to an audience of those in continuing education, in order that they may discover the vast field of decision support.

A guide to the various models and methods to multicriteria decision-making in conditions of uncertainty presented in a systematic approach Multicriteria Decision-Making under Conditions of Uncertainty presents approaches that help to answer the fundamental questions at the center of all decision-making problems: "What to do?" and "How to do it?" The book explores methods of representing and handling diverse manifestations of the uncertainty factor and a multicriteria nature of problems that can arise in system design, planning, operation, and control. The authors—noted experts on the topic—and their book covers essential questions, including notions and fundamental concepts of fuzzy sets, models and methods of multiobjective as well as multiattribute decision-making, the classical approach to dealing with uncertainty of information and its generalization for analyzing multicriteria problems in condition of uncertainty, and more. This comprehensive book contains information on "harmonious solutions" in multiobjective problem-solving (analyzing < X, F> models), construction and analysis of < X, R> models, results aimed at generating robust solutions in analyzing multicriteria problems under uncertainty, and more. In addition, the book includes illustrative examples of various applications, including real-world case studies related to the authors’ various industrial projects. This important resource: Explains the design and processing aspect of fuzzy sets, including construction of membership functions, fuzzy numbers, fuzzy relations, aggregation operations, and fuzzy sets transformations Describes models of multiobjective decision-making (< X. M> models), their analysis on the basis of using the Bellman-Zadeh approach to decision-making in a fuzzy environment, and their diverse applications, including multicriteria allocation of resources Investigates models of multiattribute decision-making (< X, R> models) and their analysis on the basis of the construction and processing of fuzzy preference relations as well as demonstrating their applications to solve diverse classes of multiattribute problems Explores notions of payoff matrices and fuzzy-set-based generalization and modification of the classic approach to decision-making under conditions of uncertainty to generate robust solutions in analyzing multicriteria problems Written for students, researchers and practitioners in disciplines in which decision-making is of paramount relevance, Multicriteria Decision-Making under Conditions of Uncertainty presents a systematic and current approach that encompasses a range of models and methods as well as new applications.

This IBM® Redpaper™ publication is a comprehensive guide that covers the IBM Power Systems™ LC921 and LC922 (9006-12P and 9006-22P)) servers that use the current IBM POWER9™ processor-based technology and supports Linux operating systems (OSes). The objective of this paper is to introduce the offerings and their capacities and available features. These new Linux scale-out systems provide differentiated performance, scalability, and low acquisition cost, and include the following features: Superior throughput and performance for high-value Linux workloads. Low acquisition cost through system optimization (industry-standard memory and industry-standard three-year warranty). Rich I/O options in the system unit. There are 12 large form factor (LFF)/small form factor (SFF) bays for 12 SAS/SATA hard disk drives (HDDs) or solid-state drives (SSDs), and four bays that are available for Non-Volatile Memory Express (NVMe) Gen3 adapters. Includes Trusted Platform Module (TPM) 2.0 Nuvoton NPCT650ABAWX through I2C (for secure boot and trusted boot). Integrated MicroSemi PM8069 SAS/SATA 16-port Internal Storage Controller Peripheral Component Interconnect Express (PCIe) 3.0 x8 with RAID 0, 1, 5, and 10 support (no write cache). Integrated Intel XL710 Quad Port 10 GBase-T PCIe 3.0 x8 UIO built-in local area network (LAN) (one shared management port). Dedicated 1 Gb Intelligent Platform Management Interface (IPMI) port. This publication is for professionals who want to acquire a better understanding of IBM Power Systems products. The intended audience includes: Clients Sales and marketing professionals Technical support professionals IBM Business Partners Independent software vendors (ISVs)

Did fake Twitter accounts help sway a presidential election? What can Facebook and Reddit archives tell us about human behavior? In Mining Social Media, senior BuzzFeed reporter Lam Thuy Vo shows you how to use Python and key data analysis tools to find the stories buried in social media. Whether you’re a professional journalist, an academic researcher, or a citizen investigator, you’ll learn how to use technical tools to collect and analyze data from social media sources to build compelling, data-driven stories. Learn how to: •Write Python scripts and use APIs to gather data from the social web •Download data archives and dig through them for insights •Inspect HTML downloaded from websites for useful content •Format, aggregate, sort, and filter your collected data using Google Sheets •Create data visualizations to illustrate your discoveries •Perform advanced data analysis using Python, Jupyter Notebooks, and the pandas library •Apply what you’ve learned to research topics on your own Social media is filled with thousands of hidden stories just waiting to be told. Learn to use the data-sleuthing tools that professionals use to write your own data-driven stories.

Manage your data with a system designed to support modern application development. Updated for MongoDB 4.2, the third edition of this authoritative and accessible guide shows you the advantages of using document-oriented databases. You’ll learn how this secure, high-performance system enables flexible data models, high availability, and horizontal scalability. Authors Shannon Bradshaw, Eoin Brazil, and Kristina Chodorow provide guidance for database developers, advanced configuration for system administrators, and use cases for a variety of projects. NoSQL newcomers and experienced MongoDB users will find updates on querying, indexing, aggregation, transactions, replica sets, ops management, sharding and data administration, durability, monitoring, and security. In six parts, this book shows you how to: Work with MongoDB, perform write operations, find documents, and create complex queries Index collections, aggregate data, and use transactions for your application Configure a local replica set and learn how replication interacts with your application Set up cluster components and choose a shard key for a variety of applications Explore aspects of application administration and configure authentication and authorization Use stats when monitoring, back up and restore deployments, and use system settings when deploying MongoDB

Learn the intricate workings of DAX and the mechanics that are necessary to solve advanced Power BI challenges. This book is all about DAX (Data Analysis Expressions), the formula language used in Power BI—Microsoft’s leading self-service business intelligence application—and covers other products such as PowerPivot and SQL Server Analysis Services Tabular. You will learn how to leverage the advanced applications of DAX to solve complex tasks. Often a task seems complex due to a lack of understanding, or a misunderstanding of core principles, and how certain components interact with each other. The authors of this book use solutions and examples to teach you how to solve complex problems. They explain the intricate workings of important concepts such as Filter Context and Context Transition. You will learn how Power BI, through combining DAX building blocks (such as measures, table filtering, and data lineage), can yield extraordinary analytical power. Throughout Pro Dax with Power BI these building blocks are used to create and compose solutions for advanced DAX problems, so you can independently build solutions to your own complex problems, and gain valuable insight from your data. What You Will Learn Understand the intricate workings of DAX to solve advanced problems Deconstruct problems into manageable parts in order to create your own recipes Apply predefined solutions for addressing problems, and link back step-by-step to the mechanics of DAX, to know the foundation of this powerful query language Get fully on board with DAX, a new and evolving language, by learning best practices Who This Book Is For Anyone who wants to use Power BI to build advanced and complex models. Some experience writing DAX is helpful, but not essential if you have experience with other data query languages such as MDX or SQL.

This IBM® Redpaper™ publication gives a broad understanding of a new architecture of the IBM Power System E950 (9040-MR9) server that supports IBM AIX®, and Linux operating systems. The objective of this paper is to introduce the major innovative Power E950 offerings and relevant functions: The IBM POWER9™ processor, which is available at frequencies of 2.8 - 3.4 GHz. Significantly strengthened cores and larger caches. Supports up to 16 TB of memory, which is four times more than the IBM POWER8® processor-based IBM Power System E850 server. Integrated I/O subsystem and hot-pluggable Peripheral Component Interconnect Express (PCIe) Gen4 slots, which have double the bandwidth of Gen3 I/O slots. Supports EXP12SX and ESP24SX external disk drawers, which have 12 Gb Serial Attached SCSI (SAS) interfaces and support Active Optical Cables (AOCs) for greater distances and less cable bulk. New IBM EnergyScale™ technology offers new variable processor frequency modes that provide a significant performance boost beyond the static nominal frequency. This publication is for professionals who want to acquire a better understanding of IBM Power Systems™ products. The intended audience includes the following roles: Clients Sales and marketing professionals Technical support professionals IBM Business Partners Independent software vendors (ISVs) This paper expands the current set of Power Systems documentation by providing a desktop reference that offers a detailed technical description of the Power E950 server. This paper does not replace the current marketing materials and configuration tools. It is intended as an extra source of information that, together with existing sources, can be used to enhance your knowledge of IBM server solutions.

This IBM® Redpaper™ publication is a comprehensive guide that covers the IBM Power System H924 (9223-42H), and IBM Power System H922 (9223-22H) servers that support memory-intensive workloads such as SAP HANA, and deliver superior price/performance for mission-critical applications in IBM AIX®, IBM i, and Linux operating systems. The objective of this paper is to introduce the major innovative Power H92 and Power H922 offerings and their relevant functions: The new IBM POWER9™ processor, which is available at frequencies of 2.8 - 3.8 GHz, 2.9 - 3.8 GHz, 2.8 - 3.8 GHz, 3.4 - 3.9 GHz, 3.5 - 3.9 GHz, and 3.8 - 4.0 GHz. Significantly strengthened cores and larger caches. Two integrated memory controllers that allow doubled the memory footprint of IBM POWER8® servers. An integrated I/O subsystem and hot-pluggable Peripheral Component Interconnect Express (PCIe) Gen4 and Gen3 I/O slots. I/O drawer expansion options offer greater flexibility. Support for Coherent Accelerator Processor Interface (CAPI) 2.0. IBM EnergyScale™ technology provides new variable processor frequency modes that provide a significant performance boost beyond the static nominal frequency. This publication is for professionals who want to acquire a better understanding of IBM Power Systems™ products. The intended audience includes the following roles: Clients Sales and marketing professionals Technical support professionals IBM Business Partners Independent software vendors (ISVs) This paper expands the current set of IBM Power Systems documentation by providing a desktop reference that offers a detailed technical description of the Power H92 and Power H922 systems. This paper does not replace the latest marketing materials and configuration tools. It is intended as an extra source of information that, together with existing sources, can be used to enhance your knowledge of IBM server solutions.

Gain a practical introduction to DataOps, a new discipline for delivering data science at scale inspired by practices at companies such as Facebook, Uber, LinkedIn, Twitter, and eBay. Organizations need more than the latest AI algorithms, hottest tools, and best people to turn data into insight-driven action and useful analytical data products. Processes and thinking employed to manage and use data in the 20th century are a bottleneck for working effectively with the variety of data and advanced analytical use cases that organizations have today. This book provides the approach and methods to ensure continuous rapid use of data to create analytical data products and steer decision making. Practical DataOps shows you how to optimize the data supply chain from diverse raw data sources to the final data product, whether the goal is a machine learning model or other data-orientated output. The book provides an approach to eliminate wasted effort and improve collaboration between data producers, data consumers, and the rest of the organization through the adoption of lean thinking and agile software development principles. This book helps you to improve the speed and accuracy of analytical application development through data management and DevOps practices that securely expand data access, and rapidly increase the number of reproducible data products through automation, testing, and integration. The book also shows how to collect feedback and monitor performance to manage and continuously improve your processes and output. What You Will Learn Develop a data strategy for your organization to help it reach its long-term goals Recognize and eliminate barriers to delivering data to users at scale Work on the right things for the right stakeholders through agile collaboration Create trust in data via rigorous testing and effective data management Build a culture of learning and continuous improvement through monitoring deployments and measuring outcomes Create cross-functional self-organizing teams focused on goals not reporting lines Build robust, trustworthy, data pipelines in support of AI, machine learning, and other analytical data products Who This Book Is For Data science and advanced analytics experts, CIOs, CDOs (chief data officers), chief analytics officers, business analysts, business team leaders, and IT professionals (data engineers, developers, architects, and DBAs) supporting data teams who want to dramatically increase the value their organization derives from data. The book is ideal for data professionals who want to overcome challenges of long delivery time, poor data quality, high maintenance costs, and scaling difficulties in getting data science output and machine learning into customer-facing production.

The role of the business analyst sits at the intersection of business operations, technology, and change management. The job requires a plethora of both soft skills and technical skills, as it must translate the needs of business users into action items for functional applications. On top of this, in-demand technologies have caused tectonic shifts in the way companies operate today, and business analysts must be prepared to adapt. The Inside Track to Excelling as a Business Analyst teaches you how to effectively harness skills, techniques, and hacks to grow your career. Author Roni Lubwama expertly walks you through case studies that illustrate how to diffuse the challenges and bottlenecks that business analysts commonly encounter. He provides you with digestible answers to the complexities faced when delivering digital transformation projects to end users. This book is not a self-help guide rife with corporate buzzwords, but a practical handbook with immediate applications from a true insider. Equip yourself with vital soft skills, ask the right questions, manage your stakeholders, and bring your projects to a successful close with The Inside Track to Excelling as a Business Analyst. Whether you are new to the role and want a leg up, or a veteran business operator looking to infuse new strategies into your work, this book instills lessons that will assist you throughout your entire career. In this time of rapid change in the digital space, business analysts are asked for more adaptability than ever before, and The Inside Track to Excelling as a Business Analyst is your ideal starting point. What You Will Learn Deploy a non-technical skills toolkit to resolve a wide array of bottlenecks particular to the business analyst practice. Defuse the many intractable and common scenarios you will encounter as a business analyst by the application of soft skills. Understand the difference between the theory and the actual practice of the business analyst role. Who This Book Is For Newbie and experienced business analysts who are looking to understand and contextualize their role; managers; other tech professionals looking to understand the business analyst role; and curious lay readers.

Presents a useful guide for applications of SEM whilst systematically demonstrating various SEM models using Mplus Focusing on the conceptual and practical aspects of Structural Equation Modeling (SEM), this book demonstrates basic concepts and examples of various SEM models, along with updates on many advanced methods, including confirmatory factor analysis (CFA) with categorical items, bifactor model, Bayesian CFA model, item response theory (IRT) model, graded response model (GRM), multiple imputation (MI) of missing values, plausible values of latent variables, moderated mediation model, Bayesian SEM, latent growth modeling (LGM) with individually varying times of observations, dynamic structural equation modeling (DSEM), residual dynamic structural equation modeling (RDSEM), testing measurement invariance of instrument with categorical variables, longitudinal latent class analysis (LLCA), latent transition analysis (LTA), growth mixture modeling (GMM) with covariates and distal outcome, manual implementation of the BCH method and the three-step method for mixture modeling, Monte Carlo simulation power analysis for various SEM models, and estimate sample size for latent class analysis (LCA) model. The statistical modeling program Mplus Version 8.2 is featured with all models updated. It provides researchers with a flexible tool that allows them to analyze data with an easy-to-use interface and graphical displays of data and analysis results. Intended as both a teaching resource and a reference guide, and written in non-mathematical terms, Structural Equation Modeling: Applications Using Mplus, 2nd edition provides step-by-step instructions of model specification, estimation, evaluation, and modification. Chapters cover: Confirmatory Factor Analysis (CFA); Structural Equation Models (SEM); SEM for Longitudinal Data; Multi-Group Models; Mixture Models; and Power Analysis and Sample Size Estimate for SEM. Presents a useful reference guide for applications of SEM while systematically demonstrating various advanced SEM models Discusses and demonstrates various SEM models using both cross-sectional and longitudinal data with both continuous and categorical outcomes Provides step-by-step instructions of model specification and estimation, as well as detailed interpretation of Mplus results using real data sets Introduces different methods for sample size estimate and statistical power analysis for SEM Structural Equation Modeling is an excellent book for researchers and graduate students of SEM who want to understand the theory and learn how to build their own SEM models using M plus.

Dive into 'Learn Microsoft PowerApps' to discover how to build practical business applications without writing any code. This book demonstrates how to simplify complex business workflows into efficient, customized applications using Microsoft's PowerApps platform. From setting up your first app to advanced integrations, you'll learn step by step how to realize your ideas. What this Book will help me do Grasp how to build and customize apps using a no-code approach with PowerApps. Harness Microsoft Power Automate for automating business processes effectively. Utilize PowerApps to integrate GPS and barcode functionality into business apps. Develop enterprise-grade applications leveraging Common Data Service within PowerApps. Share and deploy your applications securely through SharePoint and Teams. Author(s) Matthew Weston is a seasoned developer and consultant passionate about helping professionals adopt and thrive with Microsoft technologies. With years of experience working in enterprise solutions and conducting trainings, Matthew writes with a focus on making complex topics accessible and actionable for a wide range of audiences. Who is it for? This book is tailored for business analysts, IT professionals, and developers of any expertise who wish to create functional apps without the burden of coding. Beginners new to PowerApps will find clear, incremental guidance, while experienced users can explore advanced integrations and functionalities. If streamlining business workflows interests you, this book is for you.

Mastering PostgreSQL 12 delves into advanced features of PostgreSQL to help database professionals optimize, secure, and scale their database systems. Through practical examples, this book equips you with the necessary skills to address challenges in modern PostgreSQL environments. What this Book will help me do Gain expertise in PostgreSQL 12's advanced SQL functions and features. Master replication and backup techniques for scalable and fault-tolerant databases. Effectively optimize PostgreSQL queries and index utilization for performance gains. Enhance the security of PostgreSQL servers to ensure data integrity. Acquire hands-on experience in troubleshooting and resolving PostgreSQL-related issues. Author(s) Hans-Jürgen Schönig is a renowned database expert specializing in PostgreSQL. With years of experience in both database administration and development, he brings clarity to complex technical topics. His teaching approach emphasizes practical applications, making PostgreSQL's advanced features accessible for professionals. Who is it for? This book is ideal for PostgreSQL developers, administrators, and database professionals who have foundational knowledge and intend to enhance their expertise. Readers should be familiar with general database concepts and aim to master PostgreSQL's advanced functionalities. Whether you are handling enterprise environments or exploring data topology, this book serves as a vital resource.

From the top experts on healthcare workforce engagement comes a vital road map to reduce the alarmingly high—and fast-growing—rate of staff burnout and to transform care. More than half of U.S. physicians and 40 percent of nurses experience one or more symptoms of burnout. This crisis poses a serious threat to our health systems, impacting not only the well-being of the caregiving workforce but also that of their patients. Written by a team of thought leaders with deep expertise in healthcare workforce engagement and cultural development, The Engaged Caregiver shows leaders, managers, and front-line providers how to: •Recognize the early signs of burnout and turn it around •Address staff more effectively to keep them engaged •Build strong, reliable teams with a real sense of purpose •Map their organization’s core values and get everyone on board •Create a positive culture that’s cohesive, inclusive, and resilient •Develop highly effective leadership and organizational systems •Hire, engage, and manage talent strategically—and successfully •Promote diversity, equity, and inclusion in the workplace •Leverage data to drive improvements throughout the organization In this wide-ranging guide, healthcare professionals will learn how to identify, diagnose, address, and overcome caregiver burnout on a personal level, as well as measure, develop, and implement strategies that improve the entire workplace culture. The Engaged Caregiver provides an actionable plan for creating a resilient work culture that empowers caregivers and gives them the support they need to fulfill the patient promise with every care experience, every day.

Employ essential and hands-on tools and functions of the MATLAB and Simulink packages, which are explained and demonstrated via interactive examples and case studies. This book contains dozens of simulation models and solved problems via m-files/scripts and Simulink models which help you to learn programming and modeling essentials. You’ll become efficient with many of the built-in tools and functions of MATLAB/Simulink while solving engineering and scientific computing problems. Beginning MATLAB and Simulink explains various practical issues of programming and modelling in parallel by comparing MATLAB and Simulink. After reading and using this book, you'll be proficient at using MATLAB and applying the source code from the book's examples as templates for your own projects in data science or engineering. What You Will Learn Get started using MATLAB and Simulink Carry out data visualization with MATLAB Gain the programming and modeling essentials of MATLAB Build a GUI with MATLAB Work with integration and numerical root finding methods Apply MATLAB to differential equations-based models and simulations Use MATLAB for data science projects Who This Book Is For Engineers, programmers, data scientists, and students majoring in engineering and scientific computing.

Take a deep dive into perhaps the single most important facet of good performance: indexes, and how to best use them. Recent updates to SQL Server have made it possible to create indexes in situations that in the past would have prevented their use. Other improvements covered in this book include new dynamic management views, the ability to pause and resume index maintenance, and the ability to more easily recover from failures during index creation and maintenance operations. This new edition also brings new content around the indexing of columnstore and in-memory tables, showing how these new types of tables and the queries that execute against them can also benefit from good indexing practices. The book begins with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. You will better understand what indexes are doing in the database and what can be done to mitigate and improve their effect on performance. You will get a look at the Index Advisor now available in Azure SQL Database, and learn how to review and maintain the health of your indexes. The final chapters present a guided tour through a number of scenarios showing approaches you can take to investigate, mitigate, and improve the performance of your database. What You Will Learn Properly index row store, columnstore, and in-memory tables Review statistics to understand indexing choices made by the optimizer Apply indexing strategies such as covering indexes, included columns, and index intersections Recognize and remove unnecessary indexes Design effective indexes for full-text, spatial, and XML data types Manage the big picture: Encompass all indexes in adatabase, and all database instances on a server Who This Book Is For Database administrators and developers who are ready to lift the performance of their database environment by thoughtfully building indexes to speed up queries that matter the most and make a difference to the business