Exporting Data From SQL Server to Script File

SQL Server provides the ability to generate scripts for creating databases, tables, stored procedures, functions, views and inserting data. For Read More …

Change the root password for MySQL (XAMPP)

By default, when you install XAMPP in your windows machine, the root password for the MySQL is set to empty. Read More …

Export table to CSV file (SQL Server Management Studio)

A very common requirement with SQL Server is to export a table to a CSV file. It’s actually an easy Read More …

Allow MySQL Client to Connect to Remote MySQL server

By default, MySQL does not allow remote clients to connect to the MySQL database. If you try to connect to Read More …

SQL Server Replication Step by Step

Earlier, most of the applications were using standalone environment where a single centralized server was responding to multiple users, working Read More …