Useful tips for everyday
How do I restrict access to MySQL? You can use iptables to create firewall rules that restrict access to port 3306. The advantage of this…
What is archival performance data? Data archiving is the process of moving data that is no longer actively used to a separate storage device for…
What does recovery.conf file do in PG _ basebackup? The recovery.conf file will record the connection settings and, if specified, the replication slot that pg_basebackup…
Is NoSQL good for data warehouse? Also, the NoSQL approach takes advantages of the cloud-based data warehousing solution much better than the SQL approach. It…
How do you calculate loan balance? To use it, all you need to do is: Enter the original Loan amount (the full amount when the…
Which can be used with always encrypted in SQL? Always Encrypted is a feature designed to protect sensitive data, such as credit card numbers or…
How to create a spatial view in SQL? To create a view, the user must have at least SELECT privileges on each table or feature…
How does vacuum full work in PostgreSQL 10? VACUUM FULL rewrites the entire contents of the table into a new disk file with no extra…
How does a buffer pool work? A buffer pool is an area of main memory that has been allocated by the database manager for the…
Is the always on availability group Listener missing? My client had 2 nodes Always On Availability Group on SQL Server 2017 and Windows Server 2016.…