SQL Server 2019 PMEM

Tempdb Improvements in 2019

Table Variable Deferred Compilation (SQL 2019)

I have explored the SQL Server 2019, Intelligent Query Processing Feature – “Table Variable Deferred Compilation”.

The script contains some theory at the top and links to read.
After that, there are required queries to run on SQL Server 2019.
This way we can see the feature in action and look at it's strengths and caveats.

SQL Server 2019 Feature

Use Polybase to consume Oracle data from SQL Server on Linux 2019

Learn how to set up Polybase in containers to access an Oracle database.

Memory-Optimized TempDB Metadata in SQL Server 2019

In this article we look at a new feature in SQL Server 2019 that can help improve TempDB performance.

What’s New in SQL Server 2019

In this video Brent takes a 40-minute look at some of his favorite new features: deferred compilation for table variables, adaptive memory grants, adaptive joins, and air_quote_actual plans

Spark

SQL Server 2019 Graph Database and SHORTEST_PATH

With SQL Server 2019 on the way, it’s time to begin learning about all the new features. In this article, Dennes Torres demonstrates how to use the new SHORTEST_PATH function that is part of the Graph Database feature.

Introduction to Running SQL Server 2019 on Kubernetes

The release of SQL Server 2019 further extends the ability to host SQL Server instances on Linux, including running Docker-based SQL Server images on Kubernetes clusters. This latest release further extends the multi-platform capabilities by allowing for Kubernetes-based deployments of SQL Server Always On Availability Groups, delivering increased level of resiliency. Read on to learn more about the basic characteristics of these deployments!