Автор: Atkinson Название: Beginning Microsoft SQL Server 2012 Programming ISBN: 1118102282 ISBN-13(EAN): 9781118102282 Издательство: Wiley Рейтинг: Цена: 4909.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Get up to speed on the extensive changes to the newest release of Microsoft SQL Server The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server.
Автор: Korotkevitch Название: Pro SQL Server Internals ISBN: 1484219635 ISBN-13(EAN): 9781484219638 Издательство: Springer Рейтинг: Цена: 7685.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание:
Improve your ability to develop, manage, and troubleshoot SQL Server solutions by learning how different components work “under the hood,” and how they communicate with each other. The detailed knowledge helps in implementing and maintaining high-throughput databases critical to your business and its customers. You’ll learn how to identify the root cause of each problem and understand how different design and implementation decisions affect performance of your systems.New in this second edition is coverage of SQL Server 2016 Internals, including In-Memory OLTP, columnstore enhancements, Operational Analytics support, Query Store, JSON, temporal tables, stretch databases, security features, and other improvements in the new SQL Server version. The knowledge also can be applied to Microsoft Azure SQL Databases that share the same code with SQL Server 2016. Pro SQL Server Internals is a book for developers and database administrators, and it covers multiple SQL Server versions starting with SQL Server 2005 and going all the way up to the recently released SQL Server 2016. The book provides a solid road map for understanding the depth and power of the SQL Server database server and teaches how to get the most from the platform and keep your databases running at the level needed to support your business. The book: • Provides detailed knowledge of new SQL Server 2016 features and enhancements • Includes revamped coverage of columnstore indexes and In-Memory OLTP • Covers indexing and transaction strategies • Shows how various database objects and technologies are implemented internally, and when they should or should not be used • Demonstrates how SQL Server executes queries and works with data and transaction log
What You Will LearnDesign and develop database solutions with SQL Server.Troubleshoot design, concurrency, and performance issues.Choose the right database objects and technologies for the job.Reduce costs and improve availability and manageability.Design disaster recovery and high-availability strategies.Improve performance of OLTP and data warehouse systems through in-memory OLTP and Columnstore indexes.Who This Book Is ForDevelopers and database administrators who want to design, develop, and maintain systems in a way that gets the most from SQL Server. This book is an excellent choice for people who prefer to understand and fix the root cause of a problem rather than applying a 'band aid' to it.
Автор: Simmons, Ken Carstarphen, Sylvester Название: Pro sql server 2012 administration ISBN: 1430239158 ISBN-13(EAN): 9781430239154 Издательство: Springer Рейтинг: Цена: 7400.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Pro SQL Server 2012 Administration is a one-stop source for all the knowledge you`ll need to professionally manage a database under Microsoft SQL Server 2012.
Автор: Sarka Dejan, Radivojević Milos, Durkin William Название: SQL Server 2016 Developer`s Guide ISBN: 1786465345 ISBN-13(EAN): 9781786465344 Издательство: Неизвестно Рейтинг: Цена: 12137.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Get the most out of the rich development capabilities of SQL Server 2016 to build efficient database applications for your organization About This Book - Utilize the new enhancements in Transact-SQL and security features in SQL Server 2016 to build efficient database applications - Work with temporal tables to get information about data stored in the table at any point in time - A detailed guide to SQL Server 2016, introducing you to multiple new features and enhancements to improve your overall development experience Who This Book Is For This book is for database developers and solution architects who plan to use the new SQL Server 2016 features for developing efficient database applications. It is also ideal for experienced SQL Server developers who want to switch to SQL Server 2016 for its rich development capabilities. Some understanding of the basic database concepts and Transact-SQL language is assumed. What You Will Learn - Explore the new development features introduced in SQL Server 2016 - Identify opportunities for In-Memory OLTP technology, significantly enhanced in SQL Server 2016 - Use columnstore indexes to get significant storage and performance improvements - Extend database design solutions using temporal tables - Exchange JSON data between applications and SQL Server in a more efficient way - Migrate historical data transparently and securely to Microsoft Azure by using Stretch Database - Use the new security features to encrypt or to have more granular control over access to rows in a table - Simplify performance troubleshooting with Query Store - Discover the potential of R's integration with SQL Server In Detail Microsoft SQL Server 2016 is considered the biggest leap in the data platform history of the Microsoft, in the ongoing era of Big Data and data science. Compared to its predecessors, SQL Server 2016 offers developers a unique opportunity to leverage the advanced features and build applications that are robust, scalable, and easy to administer. This book introduces you to new features of SQL Server 2016 which will open a completely new set of possibilities for you as a developer. It prepares you for the more advanced topics by starting with a quick introduction to SQL Server 2016's new features and a recapitulation of the possibilities you may have already explored with previous versions of SQL Server. The next part introduces you to small delights in the Transact-SQL language and then switches to a completely new technology inside SQL Server - JSON support. We also take a look at the Stretch database, security enhancements, and temporal tables. The last chapters concentrate on implementing advanced topics, including Query Store, columnstore indexes, and In-Memory OLTP. You will finally be introduced to R and how to use the R language with Transact-SQL for data exploration and analysis. By the end of this book, you will have the required information to design efficient, high-performance database applications without any hassle. Style and approach This book is a detailed guide to mastering the development features offered by SQL Server 2016, with a unique learn-as-you-do approach. All the concepts are explained in a very easy-to-understand manner and are supplemented with examples to ensure that you-the developer-are able to take that next step in building more powerful, robust applications for your organization with ease.
Автор: Dmitri Korotkevitch Название: Expert SQL Server In-Memory OLTP ISBN: 1484227719 ISBN-13(EAN): 9781484227718 Издательство: Springer Рейтинг: Цена: 4611.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Tagline: Revolutionizing OLTP Performance in SQL Server
Автор: Kevin Feasel Название: PolyBase Revealed ISBN: 1484254600 ISBN-13(EAN): 9781484254608 Издательство: Springer Рейтинг: Цена: 4611.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Intermediate-Advanced user level
Автор: 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)
Описание: 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
Автор: Syverson, Bryan Название: Murach`s sql server 2022 for developers ISBN: 1943873062 ISBN-13(EAN): 9781943873067 Издательство: Неизвестно Рейтинг: Цена: 10466.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Автор: LaRock Название: Pro SQL Server 2022 Wait Statistics ISBN: 1484287703 ISBN-13(EAN): 9781484287705 Издательство: Springer Рейтинг: Цена: 8384.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: 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 improvements first. This edition is updated to cover analysis of wait statistics current with SQL Server 2022. Whether you are new to wait statistics, or already familiar with them, this book provides a deeper understanding on how wait statistics are generated and what they mean for your SQL Server instance’s performance. The book goes beyond the most common wait types into the more complex and performance-threatening wait types. You’ll learn about per-query wait statistics and session-based wait statistics, and the types of problems they can help you solve. The different wait types are categorized by their area of impact, including CPU, IO, Latching, Locking, and many more. Clear examples are included to help you gain practical knowledge of why and how specific wait times increase or decrease, how they impact your SQL Server’s performance, and what you can do to improve performance. After reading this book, you won’t want to be without the valuable information that wait statistics provide regarding where you should be spending your limited tuning time to maximize performance and value to your business. What You'll Learn * Understand how the SQL Server engine processes requests * Identify resource bottlenecks in a running SQL Server instance * Locate wait statistics information inside DMVs and Query Store * Analyze the root cause of sub-optimal performance * Diagnose I/O contention and locking contention * Benchmark SQL Server performance * Improve database performance by lowering overall wait time Who This Book Is For Database administrators who want to identify and resolve performance bottlenecks, those who want to learn more about how the SQL Server engine accesses and uses resources inside SQL Server, and administrators concerned with achieving—and knowing they have achieved—optimal performance
ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru
