Useful tips for everyday
How are permissions assigned in Microsoft SQL Server? Microsoft SQL Server gives the user and role-based security. Server predefined role with a group of permissions…
How does the UPDATE statement work in PostgreSQL? The PostgreSQL UPDATE statement allows you to modify data in a table. The following illustrates the syntax…
What is the difference between upgrade and install? A: A clean install refers to installing an Operating system on a computer which does not currently…
What is SHM size in Docker? You can now use the Docker shm-size and tmpfs parameters in Amazon Elastic Container Service (Amazon ECS) task definitions.…
Do DBAs write SQL? Regardless of a DBA involvement in databases development DBAs write T-SQL scripts and often create tables, stored procedures, views, etc. DBAs…
What happens when I enable balancing in MongoDB? When you enable balancing for a collection, MongoDB will not immediately begin balancing data. However, if the…
How does SQL deal with missing values? Using SQL to Improve Missing Values Listwise deletion: if a variable has so many missing cases that it…
When to use a BEFORE trigger in PostgreSQL? In a BEFORE trigger, you can also change its value with SET NEW.col_name = value if you…
Where does the archive command go in PostgreSQL? The archive command will be executed under the ownership of the same user that the PostgreSQL server…
How do I concatenate the same column value in SQL? You can concatenate rows into single string using COALESCE method. This COALESCE method can be…