SQL Server 2019

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 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 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...

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...

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...

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...

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...

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...

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...