Apress, 2019. — 224 p. — ISBN: 1484250036. Apply the new Query Store feature to identify and fix poorly performing queries in SQL Server. Query Store is an important and recent feature in SQL Server that provides insight into the details of query execution and how that execution has changed over time. Query Store helps to identify queries that aren’t performing well, or that...
Apress, 2019. — 224 p. — ISBN: 1484250036. Apply the new Query Store feature to identify and fix poorly performing queries in SQL Server. Query Store is an important and recent feature in SQL Server that provides insight into the details of query execution and how that execution has changed over time. Query Store helps to identify queries that aren’t performing well, or that...
Apress, 2019. — 173 p. — ISBN13: (electronic): 978-1-4842-5004-4. Apply the new Query Store feature to identify and fix poorly performing queries in SQL Server. Query Store is an important and recent feature in SQL Server that provides insight into the details of query execution and how that execution has changed over time. Query Store helps to identify queries that aren’t...
Apress, 2019. — 173 p. — ISBN13: (electronic): 978-1-4842-5004-4. Apply the new Query Store feature to identify and fix poorly performing queries in SQL Server. Query Store is an important and recent feature in SQL Server that provides insight into the details of query execution and how that execution has changed over time. Query Store helps to identify queries that aren’t...
3rd ed. — Apress, 2020. — 282 p. — ISBN: 9781484264782. Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This third edition is newly-updated to cover the 2019 editions of both SQL Server and Windows Server and includes strong coverage of implementing AlwaysOn Availability Groups on both Windows and Linux operating systems....
3rd ed. — Apress, 2020. — 282 p. — ISBN: 9781484264782. Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This third edition is newly-updated to cover the 2019 editions of both SQL Server and Windows Server and includes strong coverage of implementing AlwaysOn Availability Groups on both Windows and Linux operating systems....
3rd Edition. — Apress Media LLC., 2020. — 282 p. — ISBN13: (electronic): 978-1-4842-6479-9. Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This third edition is newly-updated to cover the 2019 editions of both SQL Server and Windows Server and includes strong coverage of implementing AlwaysOn Availability Groups on both...
3rd Edition. — Apress Media LLC., 2020. — 282 p. — ISBN13: (electronic): 978-1-4842-6479-9. Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This third edition is newly-updated to cover the 2019 editions of both SQL Server and Windows Server and includes strong coverage of implementing AlwaysOn Availability Groups on both...
Apress, 2019. 940 p. eng. 2nd edition. Pro SQL Server 2019 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. Finally, readers will learn how to perform advanced maintenance and...
2nd edition. — Apress, 2019. — 940 p. Pro SQL Server 2019 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. Finally, readers will learn how to perform advanced maintenance and...
2nd edition. — Apress, 2019. — 791 p. — ISBN13: (electronic): 978-1-4842-5089-1. Use this comprehensive guide for the SQL Server DBA, covering all that practicing database administrators need to know to get their daily work done. Updated for SQL Server 2019, this edition includes coverage of new features such as Memory-optimized TempDB Metadata, and Always Encrypted with Secure...
Apress Media LLC, 2023. — 244 p. — ISBN 978-1-4842-9458-1. Use the graph table features in Azure SQL that were introduced in SQL Server 2017 and further refined in SQL Server 2019. This book shows you how to create data structures to capture complex connections between items in your data. These connections will help you analyze and draw insights from connections in your data...
Apress Media LLC, 2023. — 244 p. — ISBN 978-1-4842-9459-8. Use the graph table features in Azure SQL that were introduced in SQL Server 2017 and further refined in SQL Server 2019. This book shows you how to create data structures to capture complex connections between items in your data. These connections will help you analyze and draw insights from connections in your data...
Apress Media LLC, 2023. — 244 p. — ISBN 978-1-4842-9459-8. Use the graph table features in Azure SQL that were introduced in SQL Server 2017 and further refined in SQL Server 2019. This book shows you how to create data structures to capture complex connections between items in your data. These connections will help you analyze and draw insights from connections in your data...
Apress Media LLC, 2023. — 244 p. — ISBN 978-1-4842-9459-8. Use the graph table features in Azure SQL that were introduced in SQL Server 2017 and further refined in SQL Server 2019. This book shows you how to create data structures to capture complex connections between items in your data. These connections will help you analyze and draw insights from connections in your data...
Packt, 2020. - 475p. - ISBN: 9781800204768 Get up to speed with the new features added to Microsoft SQL Server 2019 Analysis Services and create models to support your business Key Features Explore tips and tricks to design, develop, and optimize end-to-end data analytics solutions using Microsoft's technologies Learn tabular modeling and multi-dimensional cube design...
Packt, 2020. - 475p. - ISBN: 9781800204768 Get up to speed with the new features added to Microsoft SQL Server 2019 Analysis Services and create models to support your business Key Features Explore tips and tricks to design, develop, and optimize end-to-end data analytics solutions using Microsoft's technologies Learn tabular modeling and multi-dimensional cube design...
2nd Edition. — Apress, 2019. — 220 p. — ISBN13: 978-1-4842-5196-6. 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...
2nd Edition. — Apress, 2019. — 194 p. — ISBN13: (electronic): 978-1-4842-5197-3. 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...
2nd Edition. — Apress, 2019. — 194 p. — ISBN13: (electronic): 978-1-4842-5197-3. 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...
2nd Edition. — Apress, 2019. — 194 p. — ISBN13: (electronic): 978-1-4842-5197-3. 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...
2nd.ed. - Apress, 2021. - 714p. - ISBN: 9781484264812 Build custom SQL Server Integration Services (SSIS) tasks using Visual Studio Community Edition and C#. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you’ve already spent on licensing SQL Server. New in this edition is a demonstration deploying a...
2nd.ed. - Apress, 2021. - 714p. - ISBN: 9781484264812 Build custom SQL Server Integration Services (SSIS) tasks using Visual Studio Community Edition and C#. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you’ve already spent on licensing SQL Server. New in this edition is a demonstration deploying a...
Apress, 2020. — 410 p. — ISBN13: 978-1-4842-5589-6. Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL that pulls back correct results can be challenging. This book provides the help you need in writing T-SQL that performs fast and is easy to maintain. You also will learn how to implement version control, testing, and deployment...
Apress, 2020. — 410 p. — ISBN13: (electronic): 978-1-4842-5590-2. Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL that pulls back correct results can be challenging. This book provides the help you need in writing T-SQL that performs fast and is easy to maintain. You also will learn how to implement version control, testing, and...
Apress, 2020. — 410 p. — ISBN13: (electronic): 978-1-4842-5590-2. Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL that pulls back correct results can be challenging. This book provides the help you need in writing T-SQL that performs fast and is easy to maintain. You also will learn how to implement version control, testing, and...
Apress, 2020. — 410 p. — ISBN13: (electronic): 978-1-4842-5590-2. Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL that pulls back correct results can be challenging. This book provides the help you need in writing T-SQL that performs fast and is easy to maintain. You also will learn how to implement version control, testing, and...
7th Edition. - McGraw-Hill, 2020. — 865 p. — ISBN 978-1-26-045888-6. Get Up to Speed on Microsoft SQL Server 2019 Quickly and Easily Start working with Microsoft SQL Server 2019 in no time with help from this thoroughly revised, practical resource. Filled with real-world examples and hands-on exercises, Microsoft SQL Server 2019: A Beginner’s Guide, Seventh Edition starts by...
Independently published, 2021. — 998 p. — ISBN B08SL77GRG. This book is a Guide for the installation of SQL Server 2019. About the Author About the Technical Reviewer Installation and Configuration Planning the Deployment GUI Installation Server Core Installation Installation on Heterogeneous Operating Systems Configuring the Instance Database Administration Database...
Independently published, 2021. — 998 p. — ISBN B08SL77GRG. This book is a Guide for the installation of SQL Server 2019. About the Author About the Technical Reviewer Installation and Configuration Planning the Deployment GUI Installation Server Core Installation Installation on Heterogeneous Operating Systems Configuring the Instance Database Administration Database...
Independently published, 2021. — 998 p. — ISBN B08SL77GRG. This book is a Guide for the installation of SQL Server 2019. About the Author About the Technical Reviewer Installation and Configuration Planning the Deployment GUI Installation Server Core Installation Installation on Heterogeneous Operating Systems Configuring the Instance Database Administration Database...
Great Britain, amazon.com, 2019. — 69 p. — (Skills Today). —ISBN-13 978-1-9160586-1-3. If you're a beginner and want to learn practical SQL reporting skills in the shortest time possible, this is the course for you. The course's examples use free software, meaning you don't need to make any additional purchases. To follow the course's examples, you will need a Windows computer....
3rd edition. — Apress, 2019. — 615 p. 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...
3rd edition. — Apress, 2019. — 615 p. 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...
3rd edition. — Apress, 2019. — 615 p. — ISBN13: 978-1-4842-5464-6. 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...
3rd edition. — Apress, 2019. — 615 p. — ISBN13: 978-1-4842-5464-6. 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...
Amazon.com Services LLC, 2020. — 394 p. This Book is helpful for the data professionals who intend to implement SQL Server on Linux. SQL Server 2019 runs on Linux. It's the same SQL Server database engine, with many similar features and services regardless of your operating system. SQL Server tools on Windows connect to SQL Server instances on Linux in the same way they would...
Amazon Services LLC, 2020. — 394 p. This Book is helpful for the data professionals who intend to implement SQL Server on Linux. SQL Server 2019 runs on Linux. It's the same SQL Server database engine, with many similar features and services regardless of your operating system. SQL Server tools on Windows connect to SQL Server instances on Linux in the same way they would...
Amazon.com Services LLC, 2020. — 394 p. This Book is helpful for the data professionals who intend to implement SQL Server on Linux. SQL Server 2019 runs on Linux. It's the same SQL Server database engine, with many similar features and services regardless of your operating system. SQL Server tools on Windows connect to SQL Server instances on Linux in the same way they would...
Amazon.com Services LLC, 2020. — 394 p. This Book is helpful for the data professionals who intend to implement SQL Server on Linux. SQL Server 2019 runs on Linux. It's the same SQL Server database engine, with many similar features and services regardless of your operating system. SQL Server tools on Windows connect to SQL Server instances on Linux in the same way they would...
Independently published, 2021. — 344 p. — ISBN B08VF5HCHK. Most organizations are generating a huge amount of data and they are storing them in the databases. SQL Server is one of the most preferred relational database solutions on the market and plays a role as a data server for mission-critical applications. When considered from this point of view, any delay or performance...
Independently published, 2021. — 344 p. — ISBN B08VF5HCHK. Most organizations are generating a huge amount of data and they are storing them in the databases. SQL Server is one of the most preferred relational database solutions on the market and plays a role as a data server for mission-critical applications. When considered from this point of view, any delay or performance...
Independently published, 2021. — 344 p. — ISBN B08VF5HCHK. Most organizations are generating a huge amount of data and they are storing them in the databases. SQL Server is one of the most preferred relational database solutions on the market and plays a role as a data server for mission-critical applications. When considered from this point of view, any delay or performance...
Apress, 2019. — 422 p. SQL Server 2019 Revealed begins with a look at the project’s team goal to integrate the world of big data with SQL Server into a major product release. The book then dives into the details of key new capabilities in SQL Server 2019 using a “learn by example” approach for Intelligent Performance, security, mission-critical availability, and features for...
Apress, 2019. — 422 p. SQL Server 2019 Revealed begins with a look at the project’s team goal to integrate the world of big data with SQL Server into a major product release. The book then dives into the details of key new capabilities in SQL Server 2019 using a “learn by example” approach for Intelligent Performance, security, mission-critical availability, and features for...
Apress, 2019. — 277 p. — ISBN13: (electronic): 978-1-4842-5419-6. Get up to speed on the game-changing developments in SQL Server 2019. No longer just a database engine, SQL Server 2019 is cutting edge with support for machine learning (ML), big data analytics, Linux, containers, Kubernetes, Java, and data virtualization to Azure. This is not a book on traditional database...
Apress, 2019. — 277 p. — ISBN13: (electronic): 978-1-4842-5419-6. Get up to speed on the game-changing developments in SQL Server 2019. No longer just a database engine, SQL Server 2019 is cutting edge with support for machine learning (ML), big data analytics, Linux, containers, Kubernetes, Java, and data virtualization to Azure. This is not a book on traditional database...
Apress, 2019. — 230 p. — ISBN13: (electronic): 978-1-4842-5110-2. Get a head-start on learning one of SQL Server 2019’s latest and most impactful features―Big Data Clusters―that combines large volumes of non-relational data for analysis along with data stored relationally inside a SQL Server database. This book provides a first look at Big Data Clusters based upon SQL Server...
Apress, 2019. — 230 p. — ISBN13: (electronic): 978-1-4842-5110-2. Get a head-start on learning one of SQL Server 2019’s latest and most impactful features―Big Data Clusters―that combines large volumes of non-relational data for analysis along with data stored relationally inside a SQL Server database. This book provides a first look at Big Data Clusters based upon SQL Server...
Apress, 2019. — 230 p. — ISBN13: (electronic): 978-1-4842-5110-2. Get a head-start on learning one of SQL Server 2019’s latest and most impactful features―Big Data Clusters―that combines large volumes of non-relational data for analysis along with data stored relationally inside a SQL Server database. This book provides a first look at Big Data Clusters based upon SQL Server...
Apress, 2019. — 254 p. — ISBN: 1484251091. Get a head-start on learning one of SQL Server 2019’s latest and most impactful features―Big Data Clusters ―that combines l arge volumes of non-relational data for analysis along with data stored relationally inside a SQL Server database. This book provides a first look at Big Data Clusters based upon SQL Server 2019 Release Candidate...
Microsoft Press, 2020. — 992 p. — ISBN: 978-0135561089. Conquer SQL Server 2019 administration–from the inside out. Dive into SQL Server 2019 administration–and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to plan, implement, manage, and secure SQL Server 2019 in...
Randolph West, Melody Zacharias, William Assaf, Sven Aelterman, Louis Davidson, Joseph D'Antoni. — Microsoft Press, 2020. — 992 p. — ISBN: 978-0135561089. Conquer SQL Server 2019 administration–from the inside out Dive into SQL Server 2019 administration–and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving...
Randolph West, Melody Zacharias, William Assaf, Sven Aelterman, Louis Davidson, Joseph D'Antoni. — Microsoft Press, 2020. — 992 p. — ISBN: 978-0135561089. Conquer SQL Server 2019 administration–from the inside out Dive into SQL Server 2019 administration–and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving...
Пер. с англ. Желновой Н.Б. — Москва: ДМК Пресс, 2020. — 408 с. — ISBN 978-5-97060-595-0. В книге представлен исчерпывающий обзор SQL Server 2019 - инновационной версии популярной СУБД. Авторы рассказывают о производительности и безопасности, об использовании контейнеров и технологии Kubernetes, о работе с кластерами больших данных и средствах машинного обучения. Подробное...
Пер. с англ. Желновой Н.Б. — Москва: ДМК Пресс, 2020. — 408 с. — ISBN 978-5-97060-595-0. В книге представлен исчерпывающий обзор SQL Server 2019 - инновационной версии популярной СУБД. Авторы рассказывают о производительности и безопасности, об использовании контейнеров и технологии Kubernetes, о работе с кластерами больших данных и средствах машинного обучения. Подробное...
Комментарии