Useful tips for everyday
How do I create a merge replication in SQL Server? Create merge publication and define articles Connect to the publisher in SQL Server Management Studio,…
What is Oracle RAC and Data Guard? DataGuard is mainly for disaster recovery, i.e. standby database whereas RAC is for load balancing. With RAC, you…
How to stop MySQL server from starting replication? Hint: You can change/reset the ‘root’ password on MySQL server as follows: Start MySQL so that it…
How do I get the last record in a select query? to get the last row of a SQL-Database use this sql string: SELECT *…
How can I take SQL Server offline and online database? Taking Database Offline using SSMS Login to SQL Server Management Studio. In the Object Explorer,…
What is FTI compliance? The release of federal tax information (FTI) to a federal, state or local agency requires compliance with the Internal Revenue Code…
What is database migration assistant for Unicode? Oracle Database Migration Assistant for Unicode (DMU) is a unique next-generation migration tool providing an end-to-end solution for…
What does it mean when MongoDB is not connecting? In short, MongoDB not connecting error happens due to failed MongoDB server, firewall restrictions, auth failure,…
How much RAM should a SQL Server have? The minimum requirements are easy to meet: at least 3 GB of RAM and enough hard drive…
How to use Max ( ) on a subquery result? The only way I found to get around this issue was to replace the max…