article thumbnail

Additional T-SQL Improvements in SQL Server 2022

SQL Performance

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here.

Servers 142
article thumbnail

Why PostgreSQL Needs Transparent Database Encryption (TDE)

Percona

As Ibrar Ahmed noted in his blog post on Transparent Database Encryption (TDE). PostgreSQL is a surprising outlier when it comes to offering Transparent Database Encryption. If database files are copied or otherwise exposed in their raw form, exposure does not happen. Does PostgreSQL Need TDE (Transparent Data Encryption)?

Database 125
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

Trends and Topics for 2022

Adrian Cockcroft

The need for systems to be resilient is still increasing, and chaos engineering tools and techniques are developing as a key way to validate that resilience is working as designed. link] For 2022 my focus is on sustainability, and I’m planning to present at events?—?primarily primarily virtual?—?and

article thumbnail

Open Source vs. Proprietary Database Software: What To Choose?

Percona

Let’s start with a simple introductory comparison: With proprietary (closed source) database software, the public does not have access to the source code; only the company that owns it and those given access can modify it. Myth #2: Proprietary databases are better and therefore more suitable for large enterprises.

article thumbnail

The Ultimate Guide to Database High Availability

Percona

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

article thumbnail

Mega List of Updates, Bug Fixes, New Features! Release Roundup December 12, 2022

Percona

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Today’s post includes those releases and updates that have come out since November 28, 2022. was released on December 8, 2022.

article thumbnail

Percona Monitoring and Management 2.33, Percona Distribution for MongoDB 4.4.18: Release Roundup December 27, 2022

Percona

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Today’s post includes those releases and updates that have come out since December 12, 2022. was released on December 19, 2022.