Useful tips for everyday
How use AES encryption in SQL Server? How to use SQL Server Encryption with Symmetric Keys Create a Database Master Key CREATE MASTER KEY ENCRYPTION…
What is the error not a single-group group function? Error ORA-00937 occurs when the GROUP BY command is improperly used. The GROUP BY command allows…
Can I restore database from LDF file? ldf file are all that is needed to completely recover the database without losing any schema or data…
How do you make a good entity relationship diagram? Here are some best practice tips for constructing an ERD: Identify the entities. The first step…
What do you need to know about merge replication? Subscribers need to receive data, make changes offline, and later synchronize changes with the Publisher and…
Which statement is used to revoke a database authorization? REVOKE DROPIN ON REVOKE DROPIN ON is used to revoke authorization to delete database objects in…
What does validate mean in SQL? EVALUATE. The EVALUATE operator is used in the WHERE clause of a SQL statement to compare stored expressions to…
How to monitor the performance of SQL Server? For example, @@CPU_BUSY contains the amount of time the CPU has been executing SQL Server code; @@CONNECTIONS…
How do I move datafile from one directory to another in Oracle 12c? It requires five steps: Shutting down the database. SQL> SHUTDOWN IMMEDIATE; Mounting…
How do I concatenate null values in a string in mysql? CONCAT function concatenates 2 or more strings into one string….MySQL – CONCAT Function –…