Categories Tech News

SQL Server 2019 comes with host of new features

More than a quarter-century after the launch of the original SQL Server, Microsoft unveiled the new features coming with SQL Server 2019, the company’s a follow-up to last year’s SQL Server 2017. SQL Server 2019 preview relational engine is said to deliver new and enhanced features for performance, security and compliance, database availability, and developer productivity. Here’s some more information about the database engine features that are available in the first public Community Technology Preview of SQL Server 2019.

Intelligent Query Processing in SQL Server 2019

Microsoft

The new Intelligent Query Processing suite is meant to rectify some of the common query performance problems by taking some automatic corrective approaches during runtime. It leverages a feedback loop based on statistics collected from past executions. Microsoft has already started leveraging some of these features in Azure SQL Database and plans to continue building on this area for SQL Server 2019.

Persistent memory support

Microsoft is also improving persistent memory support for this release. It’s doing so with a newly optimized I/O path that’s meant to interact with persistent memory storage. When an SQL Server file is placed on a persistent memory device, it allows SQL Server to access the device directly, bypassing the operating system’s storage stack entirely. Basically, this improves performance and low latency I/O without actually changing your database design.

Always On Availability Groups

Always On Availability Groups are also getting an upgrade, including the ability to automatically redirect connections based on read/write intent. This essentially allows applications to redirect without the need for a listener to handle scenarios. This lets users leverage Availability Groups even when creating a listener is not possible or when legacy applications depend on a hard-coded server or hostname.

UTF-8 Support

Microsoft is also unveiling UTF-8 support to give users more options for character data storage. With this improvement, you can compress your existing character data without writing additional routines, allowing you to save up to 50 percent on character data. You can also use external software to compress existing data to UTF-8.

These are just a few of the upgrades available in the new version of SQL Server 2019. The preview version is now available for Windows, Linux, and Docker.

Featured image: Shutterstock

Annie Pilon

Annie Pilon is a freelance writer specializing in topics related to business, marketing, social media, and tech. She has a degree in journalism and marketing from Columbia College Chicago and currently works and lives in Michigan.

Share
Published by
Annie Pilon
Tags SQL

Recent Posts

Hardware RAID vs. software RAID: Pros and cons for each

RAID is a technique to virtualize independent disks into arrays for improved performance. Should you…

3 days ago

After the plague: What IT will look like in a post-COVID-19 world

COVID-19 has changed everything, but once it disappears, we will not go back to how…

3 days ago

Solved: Outlook defaults to Microsoft 365 version with Exchange server

An Exchange server with a hybrid connection to Microsoft 365 is usually pretty seamless —…

4 days ago

How chatbots are changing the way teams communicate internally

Chatots are primarily thought of as consumer-facing solutions. They bring life to customer interactions by…

4 days ago

Hakbit ransomware campaign targeting specific European countries

The newly uncovered Hakbit ransomware campaign spread via spear-phishing emails may indicate a shift in…

4 days ago

Credential stuffing: Everything you need to know to avoid being a victim

Credential stuffing is yet another weapon being used by cybercriminals. Here’s what credential stuffing is…

5 days ago