Название: Up Up and Array!: Dynamic Array Formulas for Excel 365 and Beyond
Автор: Abbott Ira Katz
Издательство: Apress
Год: 2023
Страниц: 235
Язык: английский
Формат: pdf
Размер: 20.6 MB

Understand the power of dynamic arrays: a single formula can generate new and vastly more efficient spreadsheet possibilities. This book introduces spreadsheet users to dynamic array functions in Microsoft Excel 365, defines and details the distinctive ways in which they work, and shows how they can be applied to a wide swath of data-analytic tasks. While array formulas and functions have long held a place in the spreadsheet toolbox (although, for many of us, shunted to an obscure corner), the dynamic array engine offers a more user-friendly and intelligible set of means for manipulating spreadsheet data in the array mode. The single-formula, multi-cell capability of dynamic arrays has been extended to nearly all existing spreadsheet functions, offering a new, default way of working. As a result, many tasks can now be executed with dynamic arrays without having to resort to the new functions at all.

Название: Security Strategies in Linux Platforms and Applications, 3rd Edition
Автор: Ric Messier, Michael Jang
Издательство: Jones & Bartlett Learning
Год: 2022
Страниц: 500
Язык: английский
Формат: epub (true)
Размер: 32.1 MB

Security Strategies in Linux Platforms and Applications, Third Edition covers major aspects of security on a Linux system. The first part of this book describes the risks, threats, and vulnerabilities associated with Linux as an operating system. Linux is a common operating system used for Internet infrastructure. As a result, a big focus for this book is on implementing strategies that you can use to protect your system implementations, even in cases where they are public facing. To that end, this book uses examples from two of the major distributions built for the server: Red Hat Enterprise Linux and Ubuntu (Server Edition). With Linux, security is much more than just firewalls and permissions. Part Two of the book shows you how to take advantage of the layers of security available to Linux—user and group options, filesystems, and security options for important services, as well as the security modules associated with Application Armor (AppArmor) and Security Enhanced Linux (SELinux). It also covers encryption options where available. The final part of this book explores the use of both open source and proprietary tools when building a layered security strategy for your Linux operating system environments.

Название: Exam Ref AZ-305 Designing Microsoft Azure Infrastructure Solutions
Автор: Ashish Agrawal, Gurvinder Singh, Avinash Bhavsar
Издательство: Microsoft Press/Pearson Education
Год: 2023
Страниц: 285
Язык: английский
Формат: pdf, epub
Размер: 10.2 MB

Prepare for Microsoft Exam AZ-305 and help demonstrate your real-world expertise in designing cloud and hybrid solutions that run on Microsoft Azure, including identity, governance, monitoring, data storage, business continuity, and infrastructure. Designed for modern IT professionals, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified Expert level. The purpose of the AZ-305 certification exam is to test your knowledge and understanding of the Microsoft Azure platform, including networking, virtualization, identity, security, business continuity, disaster recovery, data platforms, and governance. The exam is targeted toward Azure Solutions Architects, and includes coverage of advising the stakeholders responsible for translating business requirements into secure, scalable, and reliable cloud solutions. This book provides comprehensive coverage of exam domain objectives, including in-depth explanations and demonstrations of real-world design scenarios.

Название: Microsoft Azure Monitoring & Management: The Definitive Guide
Автор: Avinash Valiramani
Издательство: Microsoft Press/Pearson Education
Серия: IT Best Practices
Год: 2023
Страниц: 304
Язык: английский
Формат: epub
Размер: 29.7 MB

For cloud environments to deliver the business benefits and value they promise, their monitoring and management services must be optimally designed and configured. This is a complete, best-practice guide to selecting, deploying, and running Microsoft Azure's comprehensive monitoring and management services. Writing for every professional involved in delivering Azure services, leading cloud consultant Avinash Valiramani shows how to simplify administration, reduce downtime, avoid unnecessary cost, uncover and solve problems faster, and prepare yourself to address any new cloud workload or requirement. Valiramani offers practical guidance for all stages of your Azure journey, and all environments, no matter how sophisticated. You'll find detailed coverage of Azure Backup and Site Recovery, Azure Migrate, Azure Monitor, Azure Service Health, Azure Cost Optimization & Billing Center, Azure Cloud Shell, Azure Policy, and more.

Название: Pro SQL Server 2022 Administration: A Guide for the Modern DBA, 3rd Edition
Автор: Peter A. Carter
Издательство: Apress
Год: 2023
Страниц: 990
Язык: английский
Формат: pdf (true)
Размер: 52.2 MB

Get your daily work done efficiently using this comprehensive guide for SQL Server DBAs that covers all that a practicing database administrator needs to know. Updated for SQL Server 2022, this edition includes coverage of new features, such as Ledger, which provides an immutable record of table history to protect you against malicious data tampering, and integration with cloud providers to support hybrid cloud scenarios. You’ll also find new content on performance optimizations, such as query pan feedback, and security controls, such as new database roles, which are restructured for modern ways of working. Coverage also includes Query Store, installation on Linux, and the use of containerized SQL. Pro SQL Server 2022 Administration takes DBAs on a journey that begins with planning their SQL Server deployment and runs through installing and configuring the instance, administering and optimizing database objects, and ensuring that data is secure and highly available.

Название: Automated Taxonomy Discovery and Exploration
Автор: Jiaming Shen, Jiawei Han
Издательство: Springer
Серия: Synthesis Lectures on Data Mining and Knowledge Discovery
Год: 2022
Страниц: 112
Язык: английский
Формат: pdf (true), epub
Размер: 17.1 MB

This book provides a principled data-driven framework that progressively constructs, enriches, and applies taxonomies without leveraging massive human annotated data. Traditionally, people construct domain-specific taxonomies by extensive manual curations, which is time-consuming and costly. In today’s information era, people are inundated with the vast amounts of text data. Despite their usefulness, people haven’t yet exploited the full power of taxonomies due to the heavy curation needed for creating and maintaining them. To bridge this gap, the authors discuss automated taxonomy discovery and exploration, with an emphasis on label-efficient machine learning methods and their real-world usages. Taxonomy organizes entities and concepts in a hierarchy way. It is ubiquitous in our daily life, ranging from product taxonomies used by online retailers, topic taxonomies deployed by news outlets and social media, as well as scientific taxonomies deployed by digital libraries across various domains. When properly analyzed, these taxonomies can play a vital role for science, engineering, business intelligence, policy design, e-commerce, and more. Intuitive examples are used throughout enabling readers to grasp concepts more easily.

Название: Database Security: Problems and Solutions
Автор: Christopher Diaz
Издательство: Mercury Learning and Information
Год: 2022
Страниц: 261
Язык: английский
Формат: pdf (true), epub (true)
Размер: 24.0 MB

Database Security: Problems and Solutions describes and demonstrates how to resolve database security issues at the design, implementation, and production phases. Database securityconsiders and implements those measures or controls in more specific ways than are generally realized in the broader realm of information security. Database security also involves other confidentiality approaches, such as techniques for account credential management, techniques to manage access to data, as well as techniques to manage the types of access. Database security also considers other, less realized, approaches such as database normalization, referential integrity, transactions, locks, and check constraints. Designed for professionals, workshop settings, and self-learners, the book demonstrates several databases so the reader can follow along in a hands-on approach.

Название: Data for All (MEAP v4)
Автор: John K. Thompson
Издательство: Manning Publications
Год: 2022
Страниц: 159
Язык: английский
Формат: pdf (true)
Размер: 10.2 MB

Take control of your personal data. Learn how companies manipulate and exploit your data and what you can do to access, delete, and monetize it yourself. Both a handbook and a manifesto, Data for All is a must-read for anyone who wants to take control of their personal data. It lays out how businesses collect, use, and exploit your data, and clearly explains the legislation that will overturn the existing system. Follow John Thompson’s direct and accessible guidance and you’ll completely change your relationship with your data. In this fascinating book, you will learn how to oversee who accesses your data, how much different types of data are worth, and how to keep private details private. You’ll soon stop being a passive source of free data, and start earning a “data dividend”—hundreds or thousands of dollars paid out simply for your daily online activities. Data scientists bring together multiple sources of related data to create a model or models that produces results that are as close as possible as to how the world actually works. That is the primary objective of predictive analytics, to build a model or a stream of models, that takes data and predicts as accurately as possible what the future of that business process or business environment will look like. Data scientists bring these data sets together and create features that feed into models.

Название: Pro DAX and Data Modeling in Power BI: Creating the Perfect Semantic Layer to Drive Your Dashboard Analytics
Автор: Adam Aspin
Издательство: Apress
Год: 2023
Страниц: 475
Язык: английский
Формат: pdf, epub
Размер: 35.5 MB

Develop powerful data models that bind data from disparate sources into a coherent whole. Then extend your data models using DAX–the query language that underpins Power BI–to create reusable measures to deliver finely-crafted custom calculations in your dashboards. This book starts off teaching you how to define and enhance the core structures of your data model to make it a true semantic layer that transforms complex data into familiar business terms. You’ll learn how to create calculated columns to solve basic analytical challenges. Then you’ll move up to mastering DAX measures to finely slice and dice your data. The book also shows how to handle temporal analysis in Power BI using a Date dimension. You will see how DAX Time Intelligence functions can simplify your analysis of data over time. Finally, the book shows how to extend DAX to filter and calculate datasets and develop DAX table functions and variables to handle complex queries.

Название: IBM DB2 Administration Guide Installation, Upgrade and Configuration of IBM DB2 on RHEL 8, Windows 10 and IBM Cloud
Автор: Alan S. Bluck
Издательство: BPB Publications
Год: 2022
Страниц: 506
Язык: английский
Формат: epub (true)
Размер: 35.5 MB

IT professionals and software architects are overloaded with knowledge due to the rapid advancement of technology and the launch of new Cloud-based services. This book provides helpful instructions for installing and configuring IBM Database on multiple operating systems and enterprise platforms. The book's troubleshooting sections are designed to increase IT support productivity and speed up problem resolution. Software Architects, Installation specialists, database developers, and IBM Document, Case, and Workflow management software developers can all benefit from this book. This book offers a centralised resource that discusses the most recent version of IBM software that readers can use on the most recent versions of Red Hat Linux and IBM Cloud platforms.