Useful tips for everyday
What is the difference between normalized and denormalized data? Normalization is used to remove redundant data from the database and to store non-redundant and consistent…
How to increase the size of the InnoDB buffer? Configuring InnoDB Buffer Pool Chunk Size innodb_buffer_pool_chunk_size can be increased or decreased in 1MB (1048576 byte)…
How to create a trigger procedure in PostgreSQL? A trigger procedure is created with the CREATE FUNCTION command, declaring it as a function with no…
Why is Redshift query so slow? Data distribution – Amazon Redshift stores table data on the compute nodes according to a table’s distribution style. Dataset…
How do you count cells with conditions? To count cells by criteria, do the following: 1. Select the cell where want Excel to return the…
How do you check how many connections are open in Postgres? You can check the number of connections to your deployment with the admin user,…
How to create a secondary replica in SQL Server? For a secondary replica on the second availability group of a distributed availability group, you must…
How to replication a table without a primary key? When we try to add an article to the transactional replication ( sp_addarticle ) for the…
How do you identify a change agent? How to Identify Your Team’s Best Change Agents Demonstrate persistence. Look for individuals who keep their cool when…
How do you handle Change Data Capture? How to use change data capture to optimize the ETL process Full replication. One way to replicate a…