Useful tips for everyday
How do I stop pgAdmin backup? Open details and close with “X” and it’s gone….2 Answers closing PGAdmin 4. killing all pg_restore/pg_admin processes. for restore:…
How do I transfer data from one schema to another? In SQL Management studio right click the database that has the source table, select Tasks…
How do you improve performance in SSIS? Eliminate unneeded transformations. Perform work in your source queries if possible. Remove unneeded columns. SSIS Debugger will give…
Can we use two tables in update query? The most easiest and common way is to use join clause in the update statement and use…
What to do when Postgres blocks a query? By setting lock_timeout, the DDL command will fail if it ends up waiting for a lock, and…
How to monitor activities using SP _ whoisactive in SQL Server? In this article, we will talk about sp_WhoIsActive stored procedure and how we can…
How concurrency is handle in MongoDB? MongoDB uses multi-granularity locking [1] that allows operations to lock at the global, database or collection level, and allows…
How does ElasticSearch connect to database? The simplest way to connect to your cluster: On the Overview page for your new cluster in the Cloud…
What is server snapshot backup? A snapshot backup is a type of backup copy used to create the entire architectural instance/copy of an application, disk…
Can Db_ddladmin create tables? db_datareader: Members can read all data. db_datawriter: Members can add, delete, or modify data in the tables. db_ddladmin: allows a user…