Useful tips for everyday
How do I add a database to IBM data Studio? Procedure In IBM Data Studio, click All Databases > New Connection to a database. On…
Which operators are used to assign values? The most common form of statement in a program uses the assignment operator, =, and either an expression…
How to create a database in WAMP server? Set the username as root and make empty password column and hit go. The admin page window…
How do I change the date format in Oracle? If your existing data is in MM/DD/YYYY format, then you want: select to_date(date_column,’MM/DD/YYYY’) from table; to…
Why is NoSQL better than RDBMS? The biggest advantage of NoSQL over RDBMS is Scalability. NoSQL databases can easily scale-out to many nodes, but for…
What are the Oracle database architecture components? An Oracle instance consists of three main parts: System Global Area (SGA), Program Global Area (PGA), and background…
How do I enable an AD user? Steps to enable an user AD account using PowerShell. Get the value for necessary attributes like the the…
How do I find the SQL Server connection string? Right-click on your connection and select “Properties”. You will get the Properties window for your connection.…
How do you do a failover? Use SQL Server Management Studio In Object Explorer, connect to a server instance that hosts a secondary replica of…
How do you create an index in MySQL? In MySQL, an index can be created on a table when the table is created with CREATE…