YoVDO

What's New in SQL Server 2019

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses Application Development Courses Privacy Courses Database Administration Courses Performance Improvement Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Explore the latest features and improvements in SQL Server 2019 through this comprehensive conference talk. Discover performance enhancements, including Accelerated Database Recovery and adaptive memory grant. Learn about security and privacy updates, Linux support, and the groundbreaking SQL Server Big Data Edition. Gain insights into UTF-8 space, dynamic vs static IP, and other key features. Understand the implications for BI and Excel integration. By the end of this session, acquire a solid grasp of SQL Server 2019's capabilities, preparing you for its upcoming release.

Syllabus

Introduction
Overview
Performance Improvements
Accelerated Database Recovery
Security Privacy
Linux
Other Features
SQL Server Big Data Edition
Questions
Demos
Long string
Trace flag
Adaptive memory grant
UDF inlining
Batch mode
UTF8 space
Dynamic vs static IP
Do we have anything else
Microsoft Excel
Does Excel need to be licensed
What is the sequel master instance
BI features to focus on


Taught by

PASS Data Community Summit

Related Courses

Doing More with Less - The Challenges Ahead for Every Data Professional
PASS Data Community Summit via YouTube
Build a Modern Data Strategy and Put Your Data to Work
PASS Data Community Summit via YouTube
Transform Your Data Estate
PASS Data Community Summit via YouTube
Azure SQL and SQL Server 2022 - Intelligent Database Futures
PASS Data Community Summit via YouTube
SQL Server in Azure Virtual Machines Reimagined
PASS Data Community Summit via YouTube