2010 Availability Database Servers 
Scalegrid
SEPTEMBER 16, 2019
PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. PostgreSQL is the fourth most popular database management system in the world, and heavily used in all sizes of applications from small to large. Why Use a GUI Tool? pgAdmin uses too many resources.
Percona
JUNE 4, 2023
In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Percona
APRIL 12, 2023
Let’s start with this: MongoDB is accurately referred to as source-available software. They came up with a horizontally scalable NoSQL database. Co-founder Eliot Horowitz recounts ( {coding}bootcamps.io ): “MongoDB was born out of our frustration using tabular databases in large, complex production deployments.
Percona
JANUARY 14, 2019
What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. Text search.
SQL Performance
MAY 20, 2022
The most important things to understand about server-side parameterization are it doesn’t happen all at once and a final decision to parameterize isn’t made until the end of the process. Decisions about parameterization at this early stage are generic and conservative because the only information available is the statement itself.
SQL Performance
AUGUST 4, 2022
Let’s now continue following the compilation process to see how SQL Server decides if simple parameterization is safe or unsafe. Code examples use the Stack Overflow 2010 database on SQL Server 2019 CU 16 with the following additional nonclustered index: CREATE INDEX [ IX dbo. Timing is a key point here.
SQL Performance
MARCH 30, 2021
This five-part series takes a deep dive into the way SQL Server row mode parallel plans start up. I used the public Stack Overflow 2013 database ( download details ). The desired plan shape can also be obtained against the smaller Stack Overflow 2010 data set if that is more convenient. It can be downloaded at the same link.
Expert insights. Personalized for you.
262 
Let's personalize your content