Remove 2022 Remove Database Remove Efficiency Remove Servers
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

Can You Trust AI Chatbots When Seeking Help With Databases?

Percona

I don’t know, but certainly, the launching of ChatGPT at the end of 2022 sparked a huge hype explosion around that technology throughout this year. I played a bit with ChatGPT in February to see how it would respond to random database-related inquiries, and I found it pretty impressive and annoying at the same time.

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

PostgreSQL Vacuuming to Optimize Database Performance and Reclaim Space

Percona

In PostgreSQL, vacuuming is a maintenance task that helps to optimize database performance and reclaim space. PostgreSQL and other database management systems use MVCC to ensure consistent reads and prevent data loss from concurrent updates. It is essential to run a vacuum to keep the database running smoothly periodically.

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

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

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

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.