Контакты/Проезд  Доставка и Оплата Помощь/Возврат
История
  +7(495) 980-12-10
  пн-пт: 10-18 сб,вс: 11-18
  shop@logobook.ru
   
    Поиск книг                    Поиск по списку ISBN Расширенный поиск    
Найти
  Зарубежные издательства Российские издательства  
Авторы | Каталог книг | Издательства | Новинки | Учебная литература | Акции | Хиты | |
 

Expert Performance Indexing in Azure SQL and SQL Server 2022, Pollack


Варианты приобретения
Цена: 9083.00р.
Кол-во:
Наличие: Поставка под заказ.  Есть в наличии на складе поставщика.
Склад Америка: Есть  
При оформлении заказа до: 2025-07-28
Ориентировочная дата поставки: Август-начало Сентября
При условии наличия книги у поставщика.

Добавить в корзину
в Мои желания

Автор: Pollack
Название:  Expert Performance Indexing in Azure SQL and SQL Server 2022
ISBN: 9781484292143
Издательство: Springer
Классификация:

ISBN-10: 1484292146
Обложка/Формат: Soft cover
Страницы: 638
Вес: 1.23 кг.
Дата издания: 08.03.2023
Язык: English
Издание: 4th ed.
Иллюстрации: 249 illustrations, black and white; xxi, 638 p. 249 illus.
Размер: 253 x 180 x 38
Читательская аудитория: Professional & vocational
Основная тема: Computer Science
Подзаголовок: Toward faster results and lower maintenance both on premises and in the cloud
Ссылка на Издательство: Link
Рейтинг:
Поставляется из: Германии
Описание: Take a deep dive into perhaps the single most important facet of query performance—indexes—and how to best use them. Newly updated for SQL Server 2022 and Azure SQL, this fourth edition includes new guidance and features related to columnstore indexes, improved and consolidated content on Query Store, deeper content around Intelligent Query Processing, and other updates to help you optimize query execution and make performance improvements to even the most challenging workloads. The book begins with explanations of the types of indexes and how they are stored in a database. Moving further into the book, you will learn how statistics are critical for optimal index usage and how the Index Advisor can assist in reviewing and optimizing index health. This book helps you build a clear understanding of how indexes work, how to implement and use them, and the many options available to tame even the most large and complex workloads. What You Will Learn * Properly index row store, columnstore, and memory-optimized tables * Make use of Intelligent Query Processing for faster query results * 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 Who This Book Is For Azure SQL and SQL Server administrators and developers who are ready to improve 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
Дополнительное описание: 1. Index Fundamentals.- 2. Index Storage Fundamentals.- 3. Examining Index Contents.- 4. Fragmentation.- 5. Index Metadata and Statistics.- 6. XML Indexes.- 7. Spatial Indexing.- 8. Indexing Memory-Optimized Tables.- 9. Full-Text Indexing.- 10. Indexing M



Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance

Автор: Davidson Louis
Название: Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance
ISBN: 1484264967 ISBN-13(EAN): 9781484264966
Издательство: Springer
Цена: 10480.00 р.
Наличие на складе: Поставка под заказ.

Описание:

1. The Fundamentals

2. Introduction to Requirements

3. The Language of Data Modeling

4. Conceptual and Logical Data Model Production

5. Normalization
6. Physical Model Case Study

7. Physical Model Implementation

8. Data Protection Patterns with Check Constraints and Triggers

9. Patterns and Anti-Patterns

10. Database Security and Security Patterns

11. Data Structures, Indexes, and Their Applications

12. Matters of Concurrency

13. Coding Architecture

14. Appendix A: Scalar Datatype Reference.

Refactoring Legacy T-SQL for Improved Performance: Modern Practices for SQL Server Applications

Автор: Bohm Lisa
Название: Refactoring Legacy T-SQL for Improved Performance: Modern Practices for SQL Server Applications
ISBN: 1484255801 ISBN-13(EAN): 9781484255803
Издательство: Springer
Рейтинг:
Цена: 7685.00 р.
Наличие на складе: Есть у поставщика Поставка под заказ.

Описание: Intermediate-Advanced user level

Cloud Debugging and Profiling in Microsoft Azure: Application Performance Management in the Cloud

Автор: Chilberto Jeffrey, Zaal Sjoukje, Aroraa Gaurav
Название: Cloud Debugging and Profiling in Microsoft Azure: Application Performance Management in the Cloud
ISBN: 1484254368 ISBN-13(EAN): 9781484254363
Издательство: Springer
Рейтинг:
Цена: 9083.00 р.
Наличие на складе: Есть у поставщика Поставка под заказ.

Описание: Intermediate-Advanced user level

SQL Server 2022 Query Performance Tuning

Автор: Fritchey
Название: SQL Server 2022 Query Performance Tuning
ISBN: 1484288904 ISBN-13(EAN): 9781484288900
Издательство: Springer
Рейтинг:
Цена: 9083.00 р.
Наличие на складе: Есть у поставщика Поставка под заказ.

Описание: Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expanded information on using extended events, automatic execution plan correction, and other advanced features now available in SQL Server. These modern features are covered while still providing the necessary fundamentals to better understand how statistics and indexes affect query performance. The book gives you knowledge and tools to help you identify poorly performing queries and understand the possible causes of that poor performance. The book also provides mechanisms for resolving the issues identified, whether on-premises, in containers, or on cloud platform providers. You’ll learn about key fundamentals, such as statistics, data distribution, cardinality, and parameter sniffing. You’ll learn to analyze and design your indexes and your queries using best practices that ward off performance problems before they occur. You’ll also learn to use important modern features, such as Query Store to manage and control execution plans, the automated performance tuning feature set, and memory-optimized OLTP tables and procedures. You will be able to troubleshoot in a systematic way. Query tuning doesn’t have to be difficult. This book helps you to make it much easier. What You Will Learn * Use Query Store to understand and easily change query performance * Recognize and eliminate bottlenecks leading to slow performance * Tune queries whether on-premises, in containers, or on cloud platform providers * Implement best practices in T-SQL to minimize performance risk * Design in the performance that you need through careful query and index design * Understand how built-in, automatic tuning can assist your performance enhancement efforts * Protect query performance during upgrades to the newer versions of SQL Server Who This Book Is For Developers and database administrators with responsibility for query performance in SQL Server environments, and anyone responsible for writing or creating T-SQL queries and in need of insight into bottlenecks (including how to identify them, understand them, and eliminate them)

High Performance SQL Server: Consistent Response for Mission-Critical Applications

Автор: Nevarez Benjamin
Название: High Performance SQL Server: Consistent Response for Mission-Critical Applications
ISBN: 1484264908 ISBN-13(EAN): 9781484264904
Издательство: Springer
Цена: 7685.00 р.
Наличие на складе: Есть у поставщика Поставка под заказ.

Описание: intermediate-Advanced user level

SQL Server 2022 Revealed

Автор: Ward
Название: SQL Server 2022 Revealed
ISBN: 1484288939 ISBN-13(EAN): 9781484288931
Издательство: Springer
Рейтинг:
Цена: 7685.00 р.
Наличие на складе: Есть у поставщика Поставка под заказ.

Описание: Know how to use the new capabilities and cloud integrations in SQL Server 2022. This book covers the many innovative integrations with the Azure Cloud that make SQL Server 2022 the most cloud-connected edition ever. The book covers cutting-edge features such as the blockchain-based Ledger for creating a tamper-evident record of changes to data over time that you can rely on to be correct and reliable. You'll learn about built-in Query Intelligence capabilities to help you to upgrade with confidence that your applications will perform at least as fast after the upgrade than before. In fact, you'll probably see an increase in performance from the upgrade, with no code changes needed. Also covered are innovations such as contained availability groups and data virtualization with S3 object storage. New cloud integrations covered in this book include Microsoft Azure Purview and the use of Azure SQL for high availability and disaster recovery. The book covers Azure Synapse Link with its built-in capabilities to take changes and put them into Synapse automatically. Anyone building their career around SQL Server will want this book for the valuable information it provides on building SQL skills from edge to the cloud. What You Will Learn * Know how to use all of the new capabilities and cloud integrations in SQL Server 2022 * Connect to Azure for disaster recovery, near real-time analytics, and security * Leverage the Ledger to create a tamper-evident record of data changes over time * Upgrade from prior releases and achieve faster and more consistent performance with no code changes * Access data and storage in different and new formats, such as Parquet and S3, without moving the data and using your existing T-SQL skills * Explore new application scenarios using innovations with T-SQL in areas such as JSON and time series Who This Book Is For SQL Server professionals who want to upgrade their skills to the latest edition of SQL Server; those wishing to take advantage of new integrations with Microsoft Azure Purview (governance), Azure Synapse (analytics), and Azure SQL (HA and DR); and those in need of the increased performance and security offered by Query Intelligence and the new Ledger

Expert T-SQL Window Functions in SQL Server 2019

Автор: Kathi Kellenberger; Clayton Groom; Ed Pollack
Название: Expert T-SQL Window Functions in SQL Server 2019
ISBN: 1484251962 ISBN-13(EAN): 9781484251966
Издательство: Springer
Рейтинг:
Цена: 4191.00 р.
Наличие на складе: Есть у поставщика Поставка под заказ.

Описание:

Become an expert who can use window functions to solve T-SQL query problems. Replace slow cursors and self-joins with queries that are easy to write and perform better. This new edition provides expanded examples, including a chapter from the world of sports, and covers the latest performance enhancements through SQL Server 2019.
Window functions are useful in analytics and business intelligence reporting. They came into full blossom with SQL Server 2012, yet they are not as well known and used as often as they ought to be. This group of functions is one of the most notable developments in SQL, and this book shows how every developer and DBA can benefit from their expressive power in solving day-to-day business problems. Once you begin using window functions, such as ROW_NUMBER and LAG, you will discover many ways to use them. You will approach SQL Server queries in a different way, thinking about sets of data instead of individual rows. Your queries will run faster, be easier to write, and easier to deconstruct, maintain, and enhance in the future.
Just knowing and using these functions is not enough. You also need to understand how to tune the queries. Expert T-SQL Window Functions in SQL Server clearly explains how to get the best performance. The book also covers the rare cases when older techniques are the best bet.
What You Will Learn
Solve complex query problems without cumbersome self-joins that run slowly and are difficult to readCreate sliding windows in a result set for computing such as running totals and moving averagesReturn aggregate and detail data simultaneously from the same SELECT statementCompute lag and lead and other values that access data from multiple rows in a result setUnderstand the OVER clause syntax and how to control the windowAvoid framing errors that can lead to unexpected results
Who This Book Is For
Anyone who writes T-SQL queries, including database administrators, developers, business analysts, and data scientists. Before reading this book, you should understand how to join tables, write WHERE clauses, and build aggregate queries.
Azure sql revealed

Автор: Ward, Bob
Название: Azure sql revealed
ISBN: 1484259300 ISBN-13(EAN): 9781484259306
Издательство: Springer
Рейтинг:
Цена: 6288.00 р.
Наличие на складе: Поставка под заказ.

Описание: Intermediate-Advanced user level

Sql server data automation through frameworks

Автор: Leonard, Andy Bradshaw, Kent
Название: Sql server data automation through frameworks
ISBN: 1484262123 ISBN-13(EAN): 9781484262122
Издательство: Springer
Рейтинг:
Цена: 6288.00 р.
Наличие на складе: Есть у поставщика Поставка под заказ.

Описание: Intermediate-Advanced user level

Pro SQL Server 2022 Administration

Автор: Carter
Название: Pro SQL Server 2022 Administration
ISBN: 1484288637 ISBN-13(EAN): 9781484288634
Издательство: Springer
Рейтинг:
Цена: 10480.00 р.
Наличие на складе: Есть у поставщика Поставка под заказ.

Описание: 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. Readers will learn how to perform advanced maintenance and tuning techniques, and discover SQL Server's hybrid cloud functionality. This book teaches you how to make the most of new SQL Server 2022 functionality, including integration for hybrid cloud scenarios. The book promotes best-practice installation, shows how to configure for scalability and high availability, and demonstrates the gamut of database-level maintenance tasks, such as index maintenance, database consistency checks, and table optimizations. What You Will Learn * Integrate SQL Server with Azure for hybrid cloud scenarios * Audit changes and prevent malicious data changes with SQL Server’s Ledger * Secure and encrypt data to protect against embarrassing data breaches * Ensure 24 x 7 x 365 access through high availability and disaster recovery features in today’s hybrid world * Use Azure tooling, including Arc, to gain insight into and manage your SQL Server enterprise * Install and configure SQL Server on Windows, Linux, and in containers * Perform routine maintenance tasks, such as backups and database consistency checks * Optimize performance and undertake troubleshooting in the Database Engine Who This Book Is For SQL Server DBAs who manage on-premise installations of SQL Server. This book is also useful for DBAs who wish to learn advanced features, such as integration with Azure, Query Store, Extended Events, and Policy-Based Management, or those who need to install SQL Server in a variety of environments.

Pro Encryption in SQL Server 2022

Автор: McGiffen
Название: Pro Encryption in SQL Server 2022
ISBN: 1484286634 ISBN-13(EAN): 9781484286630
Издательство: Springer
Рейтинг:
Цена: 8384.00 р.
Наличие на складе: Есть у поставщика Поставка под заказ.

Описание: This in-depth look at the encryption tools available in SQL Server shows you how to protect data by encrypting it at rest with Transparent Data Encryption (TDE) and in transit with Transport Level Security (TLS). You will know how to add the highest levels of protection for sensitive data using Always Encrypted to encrypt data also in memory and be protected even from users with the highest levels of access to the database. The book demonstrates actions you can take today to start protecting your data without changing any code in your applications, and the steps you can subsequently take to modify your applications to support implementing a gold standard in data protection. The book highlights work that Microsoft has been doing since 2016 to make encryption more accessible, by making TDE available in the standard edition, and the introduction of Always Encrypted that requires minimal work on your part to implement powerful and effective encryption, protecting your data and meeting regulatory requirements. The book teaches you how to work with the encryption technologies in SQL Server with the express goal of helping you understand those technologies on an intuitive level. You’ll come away with a deep level of understanding that allows you to answer questions and speak as an expert. The book’s aim is to make you as comfortable in deploying encryption in SQL Server as you would be in driving your car to buy groceries. Those with a data security mindset will appreciate the discussion of how each feature protects you and what it protects you from, as well as how to implement things in the most secure manner. Database administrators will appreciate the high level of detail around managing encryption over time and the effect of encryption on database performance. All readers will appreciate the advice on how to avoid common pitfalls, ensuring that your projects to implement encryption run smoothly. What You Will Learn * Architect an effective encryption strategy for new applications * Retrofit encryption into your existing applications * Encrypt data at rest, in memory, and in transit * Manage key and certificate life cycles, including backup and restore * Recover encrypted databases in case of server failure * Work with encryption in cloud-based scenarios Who This Book Is For Database developers, architects, and administrators who want to work with encryption in SQL Server; those who want to maintain encryption whether data is at rest or being transmitted over the network; and those who wish to encrypt their data even when in the server’s own memory. Readers should be familiar with SQL Server, but no existing knowledge of encryption is assumed.

Dynamic SQL

Автор: Edward Pollack
Название: Dynamic SQL
ISBN: 148424317X ISBN-13(EAN): 9781484243176
Издательство: Springer
Рейтинг:
Цена: 4611.00 р.
Наличие на складе: Есть у поставщика Поставка под заказ.

Описание: Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the changing landscape of analytics and database administration. Code examples have been updated with new system objects and functions to improve efficiency and maintainability.Executing dynamic SQL is key to large-scale searching based on user-entered criteria. Dynamic SQL can generate lists of values and even code with minimal impact on performance. Dynamic SQL enables dynamic pivoting of data for business intelligence solutions as well as customizing of database objects. Yet dynamic SQL is feared by many due to concerns over SQL injection or code maintainability. Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server helps you bring the productivity and user-satisfaction of flexible and responsive applications to your organization safely and securely. Your organization’s increased ability to respond to rapidly changing business scenarios will build competitive advantage in an increasingly crowded and competitive global marketplace. With a focus on new applications and modern database architecture, this edition illustrates that dynamic SQL continues to evolve and be a valuable tool for administration, performance optimization, and analytics.What You'ill LearnBuild flexible applications that respond to changing business needsTake advantage of creative, innovative, and productive uses of dynamic SQLKnow about SQL injection and be confident in your defenses against itAddress performance concerns in stored procedures and dynamic SQLTroubleshoot and debug dynamic SQL to ensure correct resultsAutomate your administration of features within SQL Server

Who This Book is For
Developers and database administrators looking to hone and build their T-SQL coding skills. The book is ideal for developers wanting to plumb the depths of application flexibility and troubleshoot performance issues involving dynamic SQL. The book is also ideal for programmers wanting to learn what dynamic SQL is about and how it can help them deliver competitive advantage to their organizations.

ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru
   В Контакте     В Контакте Мед  Мобильная версия