SQL Server 2019 RevealedSQL Server 2019 Revealed

SQL Server 2019 Revealed
Author : Bob Ward
Publisher : Apress
Total Pages : 435
Release : 2019-10-18
ISBN 10 : 9781484254196
ISBN 13 : 1484254198
Language : EN, FR, DE, ES & NL


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 administration for SQL Server. It focuses on all that is new for one of the most successful modernized data platforms in the industry. It is a book for data professionals who already know the fundamentals of SQL Server and want to up their game by building their skills in some of the hottest new areas in technology. 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 the modern developer. Also covered are enhancements to SQL Server 2019 for Linux and gain a comprehensive look at SQL Server using containers and Kubernetes clusters. The book concludes by showing you how to virtualize your data access with Polybase to Oracle, MongoDB, Hadoop, and Azure, allowing you to reduce the need for expensive extract, transform, and load (ETL) applications. You will then learn how to take your knowledge of containers, Kubernetes, and Polybase to build a comprehensive solution called Big Data Clusters, which is a marquee feature of 2019. You will also learn how to gain access to Spark, SQL Server, and HDFS to build intelligence over your own data lake and deploy end-to-end machine learning applications. What You Will LearnImplement Big Data Clusters with SQL Server, Spark, and HDFS Create a Data Hub with connections to Oracle, Azure, Hadoop, and other sourcesCombine SQL and Spark to build a machine learning platform for AI applicationsBoost your performance with no application changes using Intelligent PerformanceIncrease security of your SQL Server through Secure Enclaves and Data ClassificationMaximize database uptime through online indexing and Accelerated Database RecoveryBuild new modern applications with Graph, ML Services, and T-SQL Extensibility with JavaImprove your ability to deploy SQL Server on Linux Gain in-depth knowledge to run SQL Server with containers and KubernetesKnow all the new database engine features for performance, usability, and diagnosticsUse the latest tools and methods to migrate your database to SQL Server 2019Apply your knowledge of SQL Server 2019 to Azure Who This Book Is For IT professionals and developers who understand the fundamentals of SQL Server and wish to focus on learning about the new, modern capabilities of SQL Server 2019. The book is for those who want to learn about SQL Server 2019 and the new Big Data Clusters and AI feature set, support for machine learning and Java, how to run SQL Server with containers and Kubernetes, and increased capabilities around Intelligent Performance, advanced security, and high availability.

More Books:

SQL Server 2019 Revealed
Language: en
Pages: 435
Authors: Bob Ward
Categories: Computers
Type: BOOK - Published: 2019-10-18 - Publisher: Apress

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
Azure SQL Revealed
Language: en
Pages: 380
Authors: Bob Ward
Categories: Computers
Type: BOOK - Published: 2021-02-11 - Publisher: Apress

Access detailed content and examples on Azure SQL, a set of cloud services that allows for SQL Server to be deployed in the cloud. This book teaches the fundame
SQL Server 2022 Revealed
Language: en
Pages: 0
Authors: Bob Ward
Categories: Computers
Type: BOOK - Published: 2022-10-28 - Publisher: Apress

Know how to use the new capabilities and cloud integrations in SQL Server 2022. This book covers the many innovative integrations with the Azure Cloud that make
Database and Expert Systems Applications
Language: en
Pages: 457
Authors: Sven Hartmann
Categories: Computers
Type: BOOK - Published: 2020-09-13 - Publisher: Springer Nature

The double volumes LNCS 12391-12392 constitutes the papers of the 31st International Conference on Database and Expert Systems Applications, DEXA 2020, which wi
PolyBase Revealed
Language: en
Pages: 320
Authors: Kevin Feasel
Categories: Computers
Type: BOOK - Published: 2019-12-20 - Publisher: Apress

Harness the power of PolyBase data virtualization software to make data from a variety of sources easily accessible through SQL queries while using the T-SQL sk
Pro SQL Server 2019 Wait Statistics
Language: en
Pages: 407
Authors: Enrico van de Laar
Categories: Computers
Type: BOOK - Published: 2019-06-03 - Publisher: Apress

Here is a practical guide for analyzing and troubleshooting SQL Server performance using wait statistics. Learn to identify precisely why your queries are runni
Pro SQL Server 2019 Administration
Language: en
Pages: 941
Authors: Peter A. Carter
Categories: Computers
Type: BOOK - Published: 2019-10-18 - Publisher: Apress

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 Administrator's Guide
Language: en
Pages: 522
Authors: Marek Chmel
Categories: Computers
Type: BOOK - Published: 2020-09-11 - Publisher: Packt Publishing Ltd

Use Microsoft SQL Server 2019 to implement, administer, and secure a robust database solution that is disaster-proof and highly available Key FeaturesExplore ne
SQL Server Query Tuning and Optimization
Language: en
Pages: 446
Authors: Benjamin Nevarez
Categories: Computers
Type: BOOK - Published: 2022-08-12 - Publisher: Packt Publishing Ltd

Get well-versed with ready-to-use techniques for creating high-performance queries and applications Key Features Speed up queries and dramatically improve appli
Mastering SQL Server 2017
Language: en
Pages: 696
Authors: Miloš Radivojević
Categories: Computers
Type: BOOK - Published: 2019-08-22 - Publisher: Packt Publishing Ltd

Leverage the power of SQL Server 2017 Integration Services to build data integration solutions with ease Key FeaturesWork with temporal tables to access informa