Useful tips for everyday
How to restore a MongoDB sharded cluster from a backup? In the case of MongoDB sharded clusters, the official documentation covers the procedure to restore…
How to identify performance issues with slow queries? If we are talking about interactive applications, most likely anything slower than a second is noticeable. Ideally…
How to select rows where column value changed? In the example above, the query should return the rows 2011-01-03 (StatusA changed between 2011-01-01 and 2011-01-03…
Why Is My PC backup taking so long? Select Files and Objects – The selection phase of the backup process can take a long time…
What is recursion in array? Exercises on recursion (arrays) that, given an array of integers a and an integer n, returns the number of occurrences…
Are Oracle Forms outdated? For instance, Oracle Forms is increasingly becoming outdated because many enterprises have difficulties upgrading their Oracle Forms applications. Yes, Forms applications…
How do I run a mongod config file? Create Configuration File. Create a text file and name it as mongodb. Start MongoDB. Start the MongoDB…
What should I use for primary key? Primary keys should be as small as necessary. Prefer a numeric type because numeric types are stored in…
How do I replace text in SQL Server? To replace all occurrences of a substring within a string with a new substring, you use the…
How to set up binlog based replication in MySQL? With the command-line client, execute the FLUSH TABLES WITH READ LOCK statement: This will flush all…