Useful tips for everyday
How do I connect to MariaDB Docker? To use MariaDB we will need to edit the configuration file to change the appropriate option, and then…
How do I create a DDL script in PostgreSQL? PostgreSQL: Generate full Database Script using PGAdmin Tool Right click on the database and select backup…
What is default size of Oracle data block? 8k The default block size is 8k in Oracle. This is the most common. Sometimes, people create…
How do I create a group in SSRS report? To group data in a report Select the Design tab. If you don’t see the Row…
What is the use of XML in Oracle? The data models are incorporated into Oracle Database. Ways to store, query, update, and transform XML data…
How do I format a log file? Fantastic Log Files and Where to Find Them: N Log Formatting Best Practices Make Your Log Entries Meaningful…
What is the instance name of my SQL Server? Identify the SQL Server instance name Open a command prompt window. Scroll down to entries beginning…
What happens if an index does not fit into ram? Indexes do not have to fit entirely into RAM in all cases. If the value…
Is there a way to pass information onto a delete trigger? This allows the INSERT/UPDATE trigger to have access to the field “UpdatedBy” via inserted.UpdatedBy.…
How do I connect to a MariaDB cluster? To start MariaDB cluster: Check ports 4444 and 4567. These ports must be free and open for…