SQL Server Big Data Clusters, 2nd Edition

SQL Server Big Data Clusters, 2nd Edition

Use this guide to one of SQL Server 2019’s most impactful features―Big Data Clusters. You will learn about data virtualization and data lakes for this complete artificial intelligence (AI) and machine learning (ML) platform within the SQL Server database engine. You will know how to use Big Data Clusters…

Practical Oracle SQL

Practical Oracle SQL

Write powerful queries using as much of the feature-rich Oracle SQL language as possible, progressing beyond the simple queries of basic SQL as standardized in SQL-92. Both standard SQL and Oracle’s own extensions to the language have progressed far over the decades in terms of how much you…

Pro T-SQL 2019

Pro T-SQL 2019

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…

SQL in 10 Minutes a Day, Sams Teach Yourself, 5th Edition

SQL in 10 Minutes a Day, Sams Teach Yourself, 5th Edition

Sams Teach Yourself SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book’s 22 lessons of 10 minutes or less, you’ll learn what you need to know to take advantage of the SQL language. Lessons cover IBM DB2, Microsoft SQL Server…

SQL Server Big Data Clusters

SQL Server Big Data Clusters

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…

Refactoring Legacy T-SQL for Improved Performance

Refactoring Legacy T-SQL for Improved Performance

Breathe new life into older applications by refactoring T-SQL queries and code using modern techniques. This book shows you how to significantly improve the performance of older applications by finding common anti-patterns in T-SQL code, then rewriting those anti-patterns using new functionality that is supported in current versions…

Expert Performance Indexing in SQL Server 2019, 3rd Edition

Expert Performance Indexing in SQL Server 2019, 3rd Edition

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…

Pro SQL Server 2019 Administration, 2nd Edition

Pro SQL Server 2019 Administration, 2nd Edition

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 Enclaves. Other new…

SQL Server 2019 Revealed

SQL Server 2019 Revealed

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…