Useful tips for everyday
How do I fix my ORA-02049? To resolve ORA-02049, you would need to increase the SHARED_POOL_SIZE value in init. ora . If you find that…
How do I upgrade .NET version? How do I update my Microsoft . NET Framework? Click the Download .NET Framework 4.6.2 Runtime button. (Do not…
Does BCNF decomposition guarantee lossless join? 3NF ensures lossless decomposition while BCNF does not. (R1,R2) is a lossless-join decomposition of R with respect to a…
How do I create a Login for SQL Server Management Studio? In the Object Explorer of SQL Server Management Studio, navigate to the Security folder…
Why are indexes so slow in MySQL database? As you can imagine, it’s way faster to search by an index than having to go through…
How do I add an article to an existing publication? How to add a new article to the existing Publication Open SSMS, connect to the…
What is difference between mirroring and replication? Mirroring refers to keeping copies of database to a geographically different location. Replication referes to creating multiple copies…
How do I view the contents of a MongoDB database? To get stats about MongoDB server, type the command db. stats() in MongoDB client. This…
How do I start SQL Server Agent agent XPs disabled? Solution Run sp_configure to check ‘Agent XPs’ value. The above screenshot shows that advanced options…
How to disable remote access to SQL Server? Is this feasible? box. 1) You should turn off “Allow remote connections” – do this in SQL…