SQL Server – Creating linked server in SQL Server Management Studio

In SQL Server environments the linked server functionality is commonly used to connect to another (remote) database or file (Xls, CVX) using SQL Server Management Studio (SSMS) and access and use the remote data and objects. Read More …

SQL Server – Performance Best Practices

Talking about SQL Server optimization, query tuning is often the fastest way to accelerate SQL Server performance. Most often system-level Read More …

Microsoft SQL Server – TCP Port vs TCP Dynamic Ports

The default instance of SQL Server will listen on port 1433 (unless you’ve changed it to something else). However, by default, named instances will use a dynamic port, and SQL Server Browser will determine which port has been allocated and direct traffic accordingly. Read More …

SQL Server – ANSI_Padding and Scripting from SSMS

Let’s say that you want to quickly create a table from an existing table in another database. If you are 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 …

Triggers – SQL Server

In SQL Server, a trigger is a special type of stored procedure which will run automatically in response to some Read More …

Create New User and Grant Permissions in MySQL

MySQL is an open source database management software that helps users store, organize, and later retrieve data. It has a 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 …