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

Virtual consensus in Delos

The Morning Paper

Virtual consensus in Delos , Balakrishnan et al. If you think of this a bit like mapping memory addresses to data in memory, then another parallel comes to mind: the virtual address space. We propose the novel abstraction of a virtual shared log (or VirtualLog). Facebook, Inc. ), OSDI’2020. What does the VirtualLog give us?

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

Web Development Trends 2019

KeyCDN

Here is a roundup of front end web development trends to keep an eye on in 2019. Frontend Frameworks If you’re not using a frontend framework like React, Vue.js, or Angular to help build your projects, then 2019 is a good year to start. It can be used to decouple your frontend from your backend and improve server efficiency.

article thumbnail

Configure Domain Controller and Active Directory for SQL Server Always On Availability Groups

SQL Shack

In this series for SQL Server Always On availability groups, we are covering end to end configurations for SQL Server 2019 on Windows Server 2016. In this article, we […].

article thumbnail

ScaleGrid DBaaS Expands MySQL Hosting Services Through AWS Cloud

Scalegrid

June 6, 2019 – ScaleGrid , the Database-as-a-Service (DBaaS) leader in the SQL and NoSQL space, has announced the expansion of their fully managed MySQL Hosting services to support Amazon Web Services (AWS) cloud. PALO ALTO, Calif.,

AWS 191
article thumbnail

The SQL Server Transaction Log, Part 2: Log Architecture

SQL Performance

The transaction log contains virtual log files, which contain log blocks, which store the actual log records. Virtual Log Files. The transaction log is split up into sections called virtual log files , commonly just called VLFs. Due to this problem, in SQL Server 2014 the algorithm changed for auto-growth of the log file.