Useful tips for everyday
What to do about circular reference in Entity Framework? Second, you must break those circular reference to stop the possibility of stack overflow. Using JSON…
How does deleting rows in a database decrease file size? Deleting rows in a database will not decrease the actual database file size. You need…
What does a junior DBA do? A junior database administrator works with a senior database administrator or DBA consultant to design database infrastructure and monitor…
What is the use of alias in SQL? Aliases are the temporary names given to table or column for the purpose of a particular SQL…
How do you log a file in Python? Here’s an example: import logging logging. basicConfig(level=logging. DEBUG:root:This will get logged. import logging logging. basicConfig(filename=’app.log’, filemode=’w’, format=’%(name)s…
How do I show collections in MongoDB? connect with the MongoDB database using mongo . This will start the connection. then select the database you…
How to remove binary log files from MySQL? There are several ways to remove or clean up MySQL Binary Log, it’s not recommend to clean…
Which is the latest release of PostgreSQL 9.6? E.17. Release 9.6.6 This release contains a variety of fixes from 9.6.5. For information about new features…
How do I find long running jobs in SQL Server? You can use SSMS>SQL Server Agent>Reports to find some details on top jobs(slowest jobs,etc)….For jobs…
What are the numeric data types? These types include the exact numeric data types ( INTEGER , SMALLINT , DECIMAL , and NUMERIC ), as…