article thumbnail

Hybrid Buffer Pool in SQL Server 2019

SQL Shack

This article explores the Hybrid Buffer Pool feature available in the SQL Server 2019. Introduction SQL Server uses Dynamic Random Access Memory (D-RAM) buffer pool for caching data pages retrieved from the disk. The buffer cache stores the page and writes back to disk only if it is modified.

Servers 93
article thumbnail

2019 Database Trends – SQL vs. NoSQL, Top Databases, Single vs. Multiple Database Use

Scalegrid

Wondering which databases are trending in 2019? So, which databases are most popular in 2019? from these database reporters, and CouchDB, Berkeley DB, Microsoft SQL Server, Redshift, Firebase, Elasticsearch, and InfluxDB users combined our Other category at 2.4%. NoSQL Database Use: 39.52%. Most Popular Databases. Guess again.

Database 255
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Install SQL Server 2019 on Windows Server 2016 with SQL Server Always On Availability Groups

SQL Shack

In this article, we will proceed with configuring a SQL Server Always On Availability Groups and perform failover validations. A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016 Configuration of virtual machines on Oracle […].

Servers 69
article thumbnail

tempdb Enhancements in SQL Server 2019

SQL Performance

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. Now that 2019 CTP 3.2 I have SQL Server 2019 CTP 3.2

Servers 95
article thumbnail

Column-level SQL Server encryption with SQL Server Always On Availability Groups

SQL Shack

It is the 30th article in the SQL Server Always On Availability Groups series and explores column-level SQL Server encryption with AG groups. Introduction We might have sensitive data in our SQL database such as customers’ credit card details, bank account details, social security numbers, and medical history.

Servers 105
article thumbnail

A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016

SQL Shack

In this article, we will configure a SQL Server Always On Availability Group on the Windows Server 2016. We use SQL Server 2019 for configuration. Introduction SQL Server Always On Availability Groups offers high availability and disaster recovery solution for mission-critical databases.

Servers 69
article thumbnail

SQL Server Always On Availability Groups for SQL Server Linux instances

SQL Shack

In this 29th article of the SQL Server Always On Availability Groups series, we configure the AG between SQL Server Linux instances. Introduction SQL Server 2017 & 2019 works on the cross-platform operating system: Windows and Linux. You […].

Servers 52