Database Management Systems (DBMS) offer several advantages compared to traditional file-based systems. Here are some of the key advantages:1. Data Independence:? ?Logical Data Independence: ... See More

One-to-one: A single table is linked to another table with a matching column. Each primary key corresponds to just one or zero records in the connected table.?One-to-many: A table is connect ... See More

1. First Normal Form (1NF) requires that all entities in a table have unique or atomic values.2. Second Normal Form (2NF) builds on 1NF by ensuring that all non-key attributes are fully depe ... See More

I have two tables, each with a round and an id column and additional data columns. One table is the planned version, the other one is the actual one. E.g.: planned: round | id | ... See More

So we moved both ssrs databases ( ReportingServices and temp ) and the main DB from PROD to one of our test environment. I moved the DBs, I cleaned subscription table, I backup/ ... See More

I have created a procedure in Postgres that will create a table with the contents of another three tables (SELECT with JOINS). Then the resulting table will be altered adding tw ... See More

I have a query, but want to create a store procedure that will set a reminder if 'Stock on Hand is 0' 'Blank' The following columns(Crystal, Cylical) needs to set a reminder to ... See More

We have a collection in our MongoDB where due to a changed use-case a so-far small query is now really slow. The aggregate in question is somewhat like this: db.collection.aggre ... See More

After shrinking of datafile there is around 180Gb of free space on hard drive (prior to operation shrink file dialog also shows that it is possible to free up around 180Gb of sp ... See More

I have been asked several times by users why certain configuration properties in Cassandra 4.0 conf/cassandra.yaml are no longer in 4.1. For example, the flag which enables the ... See More

New to work with replication - unable to figure out solution as this runs on prod. Kindly help me with a fix. - Thank you! Error messages: The process could not execute 'sp_rep ... See More

Trying to create VIP on Fortinet which will be pointed to Percona cluster. It wont work, any experience. 2 posts - 2 participants Read full topic ... See More

Description: Using Operator v2.4.0, the backup job pods aren?t being cleaned up. PerconaPGBackup are being deleted according to the retention configuration, but the backup job p ... See More

Hi there, I have 3 bare metal servers running Ubuntu 20.04 LTS AMD64, finally I will upgrade very soon to Ubuntu 22.04 LTS - AMD64. The current version of Mongo running as Repli ... See More

Description: HI Team, Since there is no option to monitor multi channel replication yet in PMM, I am looking for an alternate solution in which I can run a query to get the requ ... See More

Hello Folks, is there anybody who can help me? it would be possible create postgress DB via DBaaS on PMM ? (in the same way as mysql or mongo). Thanks 4 posts - 3 pa ... See More

I?ve got a 3 member replica set and have an Azure Storage accounts prepared for remote storage. I used the template provided in the walk through and filled in the relevant valu ... See More

Hi! I have a fully working MariaDB Replication Environment: Master: MariaDB 10.3.27 (about 450 databases, all with the MyISAM engine, almost 500GB of total storage) Slave: Maria ... See More

I?m very new to both PBM and PMM. I have just installed PBM and got a backup working and into Azure external storage. I?m looking at PMM for monitoring the db and VM as well as ... See More

Hello Channel, Good day to all. I have deployed pmm and percona mongodb in kubernetes cluster. i can abule see mongodb logs in pmm ui. enabled backup option in ui. configured a ... See More