Useful tips for everyday
How to update column with null value using Update Query? If you want to set null value using update query set column value to NULL…
Do you need an index on a foreign key? MySQL requires that foreign key columns be indexed; if you create a table with a foreign…
What is MariaDB enterprise? MariaDB Enterprise™ is an umbrella distribution containing optimized MariaDB server and cluster, LGPL connectors, developer enablement and DBA productivity tools. You…
How do I check my SQL Server Activity Monitor? To use the Activity Monitor, type “Ctrl-Alt-A” or click the icon within the SSMS toolbar. You…
What is SQL LOB data? Dealing with large object (LOB) data is one of the challenges of managing SQL Server installations. LOBs are usually composed…
How do you schedule a job for SQL query to run daily? In the ‘Steps’ window enter a step name and select the database you…
How do I add connections to pgAdmin? Launch pgAdmin 4. Go to the “Dashboard” tab. In the “Quick Link” section, click “Add New Server” to…
When does replication increment the identity column value? When replication inserts data at each Subscriber, it does not increment the identity column value in the…
How do I restore an Oracle backup file? Step 1: Restore ControlFile from Backup Set the DBID. You can get the dbid from the name…
How do you alter a table in production? Create and alter temporary table. Capture changes from the table to the temporary table. Copy rows from…