Useful tips for everyday
How do I export SQL results to text file? Getting Started If you want to save the results in a txt file, you can do…
Can a primary key of one table be primary key of another table? Yes. You can have same column name as primary key in multiple…
How do I connect to Pgbouncer? Follow these steps to set up PgBouncer. Create a PgBouncer configuration file. Create an authentication file. Launch pgbouncer :…
Is MySQL multi-tenant? Multi-tenants approach or a “schema-per-customer” approach is pretty common nowadays to host multiple clients on the same MySQL sever. The new MySQL…
How do you group data based on time? Right-click any cell in the Rows area and choose Group… (Note: if the Group option is disabled…
What should I automate in SQL Server? The following are common repetitive tasks that should be automated. Install SQL Server. SQL Server Configurations. Install Service…
How do I use SSMS activity monitor? How to start Activity Monitor In the SQL Server Management Studio menu click Tools and then Options. Open…
How to fix Microsoft Access driver ODBC connection failure? Resolving The Problem 1 In the Access Database, from the File menu, click Get external data…
What is the difference between select 1 and select *? There is one essential difference between the use of SELECT Â * and SELECT 1.…
What does the grant command do in PostgreSQL? The GRANT command has two basic variants: one that grants privileges on a database object (table, column,…