Useful tips for everyday
How do you handle time zones? Time Zone Strategies Store all timestamps using UTC. As you might expect, it would be a lot easier if…
How to backup and restore MS SQL Server? Quickstart: Backup and restore a SQL Server database on-premises Prerequisites Create a test database. Launch SQL Server…
What is archive in Postgres? Archiving WALs. As you keep modifying the data in the databases on a server, WAL files keep getting generated (and…
Can you rename a table? To rename a table. In Object Explorer, right-click the table you want to rename and choose Design from the shortcut…
What will happen if any node in failover cluster is not working properly? All nodes in a failover cluster have access to shared storage. Some…
Which of the following are benefits of Amazon RDS Read replicas? Amazon RDS Read Replicas provide enhanced performance and durability for RDS database (DB) instances.…
How do I get the last index in SQL? If you want to get the index of the last space in a string of words,…
What is the default root password for MySQL in XAMPP? By default, when you install XAMPP in your windows machine, the root password for the…
What is SQL Server index fragmentation? The index fragmentation is the index performance value in percentage, which can be fetched by SQL Server DMV. According…
Can a return function return more than one value? Even though a function can return only one value but that value can be of pointer…