All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Introducing Microsoft SQL Server 2019

You're reading from Introducing Microsoft SQL Server 2019

Product type Book

Published in Apr 2020

Publisher Packt

ISBN-13 9781838826215

Pages 488 pages

Edition 1st Edition

Languages

Concepts

Database Administration

Authors (8):

Kellyn Gorman

Allan Hirt

Dave Noderer

Mitchell Pearson

James Rowland-Jones

Dustin Ryan

Arun Sirpal

Buck Woody

View More author details

Table of Contents (15) Chapters

Preface

About Microsoft SQL Server 2019

1. Optimizing for performance, scalability and real‑time insights

2. Enterprise Security

3. High Availability and Disaster Recovery

4. Hybrid Features – SQL Server and Microsoft Azure

5. SQL Server 2019 on Linux

6. SQL Server 2019 in Containers and Kubernetes

7. Data Virtualization

8. Machine Learning Services Extensibility Framework

9. SQL Server 2019 Big Data Clusters

10. Enhancing the Developer Experience

11. Data Warehousing

12. Analysis Services

13. Power BI Report Server

14. Modernization to the Azure Cloud

PolyBase external tables

External tables provide SQL Server with the schema to reason over data in the external data source. When you create an external table, you are establishing a strongly typed interface to the data that includes data type, nullability, and column-level collation. The columns can, and should, be strongly typed as this improves query performance and data quality.

Note

The data that you reference via an external table is not directly under SQL Server management. This means that the data could change or be removed and will not be included in operations such as backup or restore.

The columns in an external table are mapped by position and so you can choose whatever column names you like. You can, therefore, treat external tables as a useful abstraction for aliasing column names. In this sense, an external table operates as a view:

CREATE EXTERNAL TABLE [Sales].[SalesTerritory]
([TerritoryID]       INT    ...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $15.99/month. Cancel anytime

Authors (8)

Kellyn Gorman

Kellyn Gorman is a Customer Success Engineer at Microsoft specializing on Oracle and data platforms on Azure. An alumnus of both Microsoft's Idera ACE and Oracle ACE Director programs, a Friend of Redgate, she has been recognized with numerous awards over the years for her technical contributions and community volunteerism. She is one of only six women part of the Oak Table, a network for the Oracle scientist. She has extensive experience in environment migrations, optimization, automation and architecture. Kellyn is well known for her technical content and thought leadership through her presentations, keynotes, webinars, publications and engaging with her on social media presence as DBAKevlar or her blog.

See other products by Kellyn Gorman

Allan Hirt

SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product as well as clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers no matter if they are on premises or in the public cloud and delivers training and speaks at events over the world.

See other products by Allan Hirt

Dave Noderer

Dave Noderer is a software developer and the CEO / President and founder of Computer Ways, Inc., a software development company since 1994. He is the leader of FlaDotNet holding monthly developer meetup, was a Microsoft MVP for 16 years, and is a co-founder of the Microsoft Cloud South Florida User Group. In 2005 he held the first South Florida Code Camp. This annual, free event now called the South Florida Software Developer Conference attracts over 1000 developers.

See other products by Dave Noderer

Mitchell Pearson

Mitchell Pearson has worked as a Data Platform Consultant and Trainer for the last 8 years. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure. Mitchell is very active in the community: Running the local Power BI User Group, presenting at user groups locally and virtually, and creating YouTube videos for MitchellSQL

See other products by Mitchell Pearson

James Rowland-Jones

James Rowland-Jones is a principal consultant for The Big Bang Data Company. His focus and passion is to architect and deliver highly scalable analytical platforms that are creative, simple, and elegant in their design. James specializes in big data warehouse solutions that leverage both SQL Server PDW and Hadoop ecosystems. James is a keen advocate for the SQL Server community, both internationally and in the United Kingdom. He currently serves on the board of directors for PASS and sits on the organizing committee for SQLBits (Europe's largest event for the Microsoft Data Platform). James has been awarded Microsoft's MVP accreditation since 2008 for his services to the community.

See other products by James Rowland-Jones

Dustin Ryan

Dustin Ryan is a Senior Cloud Solution Architect at Microsoft. He has worked in the business intelligence and data warehousing field since 2008, has spoken at community events such as SQL Saturday, SQL Rally, and PASS Summit, and has a wide range of experience designing and building data solutions using SQL Server and Azure. Prior to his time at Microsoft, Dustin worked as a business intelligence consultant and trainer for Pragmatic Works. He is also an author, contributor and technical editor of books. Dustin resides outside Jacksonville, Florida with his wife, three children, and three-legged cat and enjoys spending time with his family and serving at his local church.

See other products by Dustin Ryan

Arun Sirpal

Arun Sirpal is a Microsoft MVP specialized within the Microsoft Data Platform which includes SQL Server 2008 R2-2019 (performance tuning, HA/DR, T-SQL, security, backups and general DBA tasks) and Microsoft Azure based technologies such as SQL Server within Azure virtual machines (IaaS), Azure SQL Database (PaaS), SQL database elastic pools, managed instances, Azure SQL DW, Azure Synapse, ADFv2, Cosmos DB (NoSQL), and Azure Cloud Shell. He is a frequent writer, blogger, speaker and technical reviewer for subjects based on SQL Server and Microsoft Azure - Data Platform. He is also known as BlobEater.

See other products by Arun Sirpal

Buck Woody

Buck Woody works on the Azure Data Services team at Microsoft and uses data and technology to solve business and science problems. With over 35 years of professional and practical experience in computer technology, he is also a popular speaker at conferences around the world; author of over 700 articles and eight books on databases, machine learning, and R, he also sits on various Data Science Boards at two US Universities, and specializes in advanced data analysis techniques.

See other products by Buck Woody

Other recommended products

Related to this chapter

SQL Server on Azure Virtual Machines

SQL Server on Azure Virtual Machines

This book will teach you how to harness the capabilities of SQL Server and the cloud database by taking you through the steps to deploy the server in Azure virtual machine effectively.

Jun 2020 6 hours 40 minutes

SQL Server on Linux

SQL Server on Linux

Microsoft's launch of SQL Server on Linux has made SQL Server a truly versatile platform across different operating systems and data-types, both on-premise and on-cloud. You will start by understanding how SQL Server can be installed on supported and unsupported Linux distributions. With the help of this book you will be able to setup SQL Server on Linux and understand how SQL Server can be installed and implemented on this open source platform.

Aug 2017 7 hours 24 minutes

ETL with Azure Cookbook

ETL with Azure Cookbook

This book will take you through hand-on recipes for extracting, transforming, and loading data using big data tools and Azure services such as Data Factory and Azure Databricks. You will learn how to interact effectively with Azure services, along with covering automation with BIML and data profiling in Azure.

Sep 2020 14 hours 52 minutes

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook

Jan 2017 12 hours 24 minutes

Mastering Microsoft Power BI

Mastering Microsoft Power BI

This book will show you how to use Power BI effectively to create a variety of visualizations and BI dashboards. Right from gathering data through various data sources, you will learn to perform effective visual analytics. By the end of this book, you will be able to gain unique, hidden insights into your data using Microsoft Power BI.

Mar 2018 21 hours 16 minutes

SQL Server 2019 Administrator's Guide

SQL Server 2019 Administrator's Guide

This book will give you all the information you need to become an expert database administrator and master the administrative aspects of SQL Server 2019. From setting up and configuring your SQL Server instance to fine-tuning your database, this extensive guide will teach you the nitty-gritty of SQL Server 2019 administration.

Sep 2020 17 hours 24 minutes

SQL Server 2017 Machine Learning Services with R

SQL Server 2017 Machine Learning Services with R

With integrated R Services within SQL Server 2017, developers and data scientists can now benefit from the integrated, effective, efficient and more streamlined analytics environment. In this book, you will understand how to leverage the capabilities of R Services in SQL Server 2017. This short yet effective guide will help you get familiar with SQL Server 2017 R Services, and will show how to implement efficient data science models using it.

Feb 2018 11 hours 16 minutes

Professional SQL Server High Availability and Disaster Recovery

Professional SQL Server High Availability and Disaster Recovery

The Professional SQL Server High Availability and Disaster Recovery book explains the high availability and the disaster recovery technologies, their technical implementation, and different topologies that you can use when creating a highly available infrastructure with hybrid topologies.

Jan 2019 18 hours 48 minutes

Learn T-SQL Querying

Learn T-SQL Querying

T-SQL is an extension of the SQL language which allows you to tackle advanced querying and query-tuning challenges in SQL Server and Azure SQL Database. This book will be a perfect reference for you to write more efficient T-SQL code to perform simple-to-advanced tasks for data management and data analysis.

May 2019 16 hours 8 minutes

Implementing Hybrid Cloud with Azure Arc

Implementing Hybrid Cloud with Azure Arc

Azure Arc helps in simplifying the governance and monitoring of your infrastructure and gives you a single pane view across hybrid architectures deployed over multiple clouds or on-premises. If you are new to multi-cloud or cloud with Edge infrastructure, this book will provide a comprehensive introduction and get you up-to-speed in no time.

Jul 2021 8 hours 4 minutes

SQL Server 2017 Administrator's Guide

SQL Server 2017 Administrator's Guide

This book will give you all the information you need to become an expert database administrator, and master the administrative aspects of SQL Server 2017. From setting up and configuring your SQL Server instance to fine-tuning your database, this extensive guide will teach you the nitty-gritty of SQL Server 2017 administration.

Dec 2017 14 hours 28 minutes

Hands-On SQL Server 2019 Analysis Services

Hands-On SQL Server 2019 Analysis Services

This book will expand your ability to deliver meaningful, performant solutions to your organization. You’ll learn how to use an analytical engine for decision making and business analytics. With the help of this practical guide, you’ll also be able to work confidently with data and analytics.

Oct 2020 15 hours 48 minutes

Personalised recommendations for you

Based on your interests and search pattern

Ever wonder why speech recognition systems don't understand the Scottish accent, or what would happen if an astronaut only ate mac 'n' cheese, or other spurious reflections you'd have at a bar? We did, then collated those deliberations into absurd research articles with fake figures and methodologies inspired by even more fictionally absurd studies.

Aug 2023 7 hours 40 minutes

Generative AI with LangChain

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

Dec 2023 12 hours 0 minutes

Generative AI with LangChain

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

Dec 2023 12 hours 0 minutes

Generative AI with LangChain

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

Dec 2023 12 hours 0 minutes

Generative AI with LangChain

Generative AI with LangChain

This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.

Dec 2023 12 hours 0 minutes

Mastering Tableau 2023

Mastering Tableau 2023

This book is a comprehensive resource to mastering your Tableau skills and becoming a BI expert. As you progress, you will learn how to build advanced dashboards and improve your storytelling to derive key business insight, as well as make you well-versed with advanced functionalities of Tableau in the business intelligence domain.

Aug 2023 22 hours 48 minutes

Building AI Applications with ChatGPT APIs

Building AI Applications with ChatGPT APIs

This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.

Sep 2023 8 hours 36 minutes

Building AI Applications with ChatGPT APIs

Building AI Applications with ChatGPT APIs

This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.

Sep 2023 8 hours 36 minutes

Data Engineering with AWS

Data Engineering with AWS

Embark on a journey to master data engineering pipelines on AWS! Our book offers a hands-on experience of AWS services for ingesting, transforming, and consuming data. Whether you're an absolute beginner or someone with basic data engineering experience, this guide is an indispensable resource.

Oct 2023 21 hours 12 minutes

Modern Data Architecture on AWS

Modern Data Architecture on AWS

Every organization wants an agile, performant, and cost-effective data platform that meets all their current and future business needs. Purpose-built AWS analytics services and their features play a big part in building such a modern data platform. This book brings to you all the design and architectural patterns that’ll help you achieve this goal.

Aug 2023 14 hours 0 minutes

Practical Guide to Applied Conformal Prediction in Python

Practical Guide to Applied Conformal Prediction in Python

Discover the power of Conformal Prediction with the "Practical Guide to Applied Conformal Prediction in Python." Master the latest techniques to quantify uncertainty in machine learning and computer vision models, and seamlessly apply them to your industry applications.

Dec 2023 8 hours 0 minutes

TinyML Cookbook

TinyML Cookbook

With over 70 project-based recipes, the TinyML Cookbook is a practical guide that will help you to get the most out of your microcontrollers. It provides a comprehensive understanding of the theoretical foundations while giving you hands-on experience training ML models for deployment on Arduino Nano 33 BLE Sense, Raspberry Pi Pico, and SparkFun RedBoard Artemis Nano microcontrollers.

Nov 2023 22 hours 8 minutes