SQL Server 2019

Table Variable Deferred Compilation (SQL 2019)

  • Script

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.

5 (2)

2020-08-03

527 reads

Introduction to Running SQL Server 2019 on Kubernetes

  • Article

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!

2019-07-30

High Prices for High Security

  • Editorial

I was excited to see the new Secure Enclave technology come to Always Encrypted (AE) in SQL Server 2019. I've thought that the way Microsoft implemented the AE technology in SQL Server 2016 was a start and a good step forward, but it had too many restrictions. Kind of like Availability Groups in 2012 and […]

2019-05-30

197 reads

Blogs

VMworld 2020 SQL Server session preview

By

Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview...

A new malware attack on SQL Server

By

Tencent Security has released a report (written in Chinese) describing a new malware attack by...

Azure Synapse Analytics overlooked features

By

There are some options in Azure Synapse Analytics that are not obvious that I...

Read the latest Blogs

Forums

Size of table

By caz100

Hi This probably a silly question but..... If I query the size of a...

Cross Apply, sub query or something else.... I\'m stuck

By Geoff A

need help on a query please. given the following table; CREATE TABLE #T (CATEGORY...

Validate field in STaging before loading

By Bruin

I have a STaging table where I have defined all fields as Varchar(255), now...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers