Useful tips for everyday
How to check the size of a SQL Server Backup? Now let us take backup of the entire database using the following script. Now let…
Can I install Oracle 11g on Windows 7? In this article, you will learn how to install Oracle 11g on your Window 7 64-bit PC.…
What is meant by SQL joins? From Wikipedia, the free encyclopedia. A join clause in SQL – corresponding to a join operation in relational algebra…
Why do we use UUID? UUIDs are generally used for identifying information that needs to be unique within a system or network thereof. Their uniqueness…
How do you make a path relative? The algorithm to make a relative path would look as follows: Remove the longest common prefix (in this…
Can I buy Oracle license without support? Oracle’s license set definition is available in the current technical support policies. If you decide not to purchase…
What role should testing in backup and recovery? Backup and recovery testing is an essential part of a disaster recovery plan. However, it is not…
What is used to combine data? Use the CONCATENATE function to combine two or multiple cells. To do this, right click the cell and select…
How do I export data from a MySQL workbench table? Create a backup using MySQL Workbench Connect to your MySQL database. Click Server on the…
How do I find the size of a data table in SQL? Get size of tables in SQL Server USE {Database_Name}; GO. SELECT. (SUM(a. total_pages)…