Useful tips for everyday
How do I run Docker daemon as a non root user? Run Docker as a non-root user To run Docker as a non-root user, you…
Can you make a RAID array with SSD? Connecting multiple SSDs to a RAID controller to create an SSD RAID array in certain SSD RAID…
How do I migrate data from SQL to MySQL? We can migrate MS SQL database to MySQL using migration module of “MySQL Workbench” utility….The following…
Can a primary key have attributes? The primary key is an attribute or a set of attributes that uniquely identify a specific instance of an…
How does PostgreSQL try to improve its performance? PostgreSQL tries to hold the most frequently accessed data in memory to make performance improvements based on…
How do I give a user access to a read-only table in Oracle? SQL>create user scott_read_only_user identified by readonly; SQL>grant create session to scott_read_only_user; SQL>grant…
How do I restore a database to a restore point? To restore your database to a guaranteed restore point, follow the steps below: $> $>…
What is the page size in MySQL? By default, all tablespaces have a page size of 16KB; you can reduce the page size to 8KB…
Is allowed by Repeatable Read isolation? Repeatable Read Isolation Level. The Repeatable Read isolation level only sees data committed before the transaction began; it never…
How does the buffer pool work in SQL Server? In order to understand how the Buffer Pool works and how it benefits our query processing…