3rd ed. — Apress, 2022. — 989 p. — ISBN 1484288637. 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...
6th Edition. — Apress Media LLC, 2022. — 730 p. — ISBN-13: 978-1-4842-8890-0. 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...
6th Edition. — Apress Media LLC, 2022. — 745 p. — ISBN-13: 978-1-4842-8891-7. 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...
6th Edition. — Apress Media LLC, 2022. — 745 p. — ISBN-13: 978-1-4842-8891-7. 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...
6th Edition. — Apress Media LLC, 2022. — 745 p. — ISBN-13: 978-1-4842-8891-7. 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...
6th Edition. Apress, 2022. — 893 p. 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...
6th Edition. Apress, 2022. — 893 p. 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...
3rd Edition. — Apress Media LLC, 2023. — 425 p. — ISBN-13: 978-1-4842-8770-5. Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You’ll learn to identify precisely why your queries are running slowly. And you’ll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest...
3rd Edition. — Apress Media LLC, 2023. — 425 p. — ISBN-13: 978-1-4842-8771-2. Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You’ll learn to identify precisely why your queries are running slowly. And you’ll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest...
3rd Edition. — Apress Media LLC, 2023. — 425 p. — ISBN-13: 978-1-4842-8771-2. Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You’ll learn to identify precisely why your queries are running slowly. And you’ll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest...
3rd Edition. — Apress Media LLC, 2023. — 425 p. — ISBN-13: 978-1-4842-8771-2. Use this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You’ll learn to identify precisely why your queries are running slowly. And you’ll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest...
Apress Media LLC, 2022. — 353 p. — ISBN-13: 978-1-4842-8663-0. 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...
Apress Media LLC, 2022. — 353 p. — ISBN-13: 978-1-4842-8664-7. 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...
Apress Media LLC, 2022. — 353 p. — ISBN-13: 978-1-4842-8664-7. 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...
Apress Media LLC, 2022. — 353 p. — ISBN-13: 978-1-4842-8664-7. 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...
Birmingham: Packt Publishing, 2022. — 445 p. — ISBN 1803242620. Get well-versed with ready-to-use techniques for creating high-performance queries and applications. Key Features Speed up queries and dramatically improve application performance by both understanding query engine. internals and practical query optimization. Understand how the query optimizer works. Learn about...
2nd Edition. — Apress Media LLC, 2023. — 555 p. — ISBN-13: 978-1-4842-9255-6. Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations. New in this edition is coverage of Parameter Sensitive Plan (PSP) optimization, Azure Synapse Link for real-time analytics,...
2nd Edition. — Apress Media LLC, 2023. — 555 p. — ISBN-13: 978-1-4842-9256-3. Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations. New in this edition is coverage of Parameter Sensitive Plan (PSP) optimization, Azure Synapse Link for real-time analytics,...
2nd Edition. — Apress Media LLC, 2023. — 555 p. — ISBN-13: 978-1-4842-9256-3. Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations. New in this edition is coverage of Parameter Sensitive Plan (PSP) optimization, Azure Synapse Link for real-time analytics,...
2nd Edition. — Apress Media LLC, 2023. — 555 p. — ISBN-13: 978-1-4842-9256-3. Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations. New in this edition is coverage of Parameter Sensitive Plan (PSP) optimization, Azure Synapse Link for real-time analytics,...
4th Edition. — Apress Media, LLC., 2023. — 649 p. — ISBN13: 978-1-4842-9214-3. 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...
Microsoft Press/Pearson Education, 2023. — 1953 p. Conquer SQL Server 2022 and Azure SQL administration from the inside out! Dive into SQL Server 2022 administration and grow your Microsoft SQL Server data platform skillset. This well-organized reference packs in timesaving solutions, tips, and workarounds, all you need to plan, implement, deploy, provision, manage, and secure...
СПб.: БХВ-Петербург, 2024. — 522 с.: ил. — ISBN 978-5-9775-1805-5. Книга посвящена установке, настройке, администрированию и разработке баз данных с помощью СУБД MS SQL Server 2022. Материал сопровождается большим количеством примеров кода, которые можно использовать на практике. Рассмотрены основы языка запросов, используемые типы данных, создание базы данных и основных ее...
Пер. с англ. Д. Павлов. — СПб.: Питер, 2023. — 2023. — 512 с.: ил. — (Для профессионалов). — ISBN:978-5-4461-2332-2. Исчерпывающий обзор лучших практик по устранению неисправностей и оптимизации производительности Microsoft SQL Server. Специалисты по базам данных, в том числе разработчики и администраторы, научатся выявлять проблемы с производительностью, системно устранять...
Пер. с англ. Д. Павлов. — СПб.: Питер, 2023. — 2023. — 512 с.: ил. — (Для профессионалов). — ISBN:978-5-4461-2332-2. Исчерпывающий обзор лучших практик по устранению неисправностей и оптимизации производительности Microsoft SQL Server. Специалисты по базам данных, в том числе разработчики и администраторы, научатся выявлять проблемы с производительностью, системно устранять...
Комментарии