Steps to create SQL server alias

Steps for Deleting an alias using SQL Server Configuration Manager ?
#SQL aliases are used to give a table, or a column in a table, a temporary name. Aliases are often used to make column names more readable. An alias only exists for the duration of the query.
To find my SQL Server #alias name:
Expand SQL Native client #configuration, and you can find a subfolder Alias. By default, we do not have any alias defined for the SQL Server #instance. In the screenshot, we can see it does not see any items for the Alias. Right-click on Aliases and click on New Alias.
1. Take SQL Server Configuration Manager and go to SQL Server Native #Client Configuration, then click Aliases.
2. We can right-click the alias that we want to delete, and then click Delete.
3. A warning will pop up, we can click on Yes to remove the alias. This removes the SQL Server alias.

Read More




Install Froxlor on CentOS 7

This article will guide you on steps to #install Froxlor on #CentOS 7 and also resolve common Froxlor #errors.
#Froxlor is a simple but powerful server administration #software for managing #domains, emails and files.
To install Froxlor web hosting control panel:
1. Ensure that your webserver serves /var/www.
2. Extract froxlor into /var/www.
3. Point your browser to http://[ip-of-webserver]/froxlor.
4. Follow the #installer.
5. Login as #administrator.
6. Adjust "System > Settings" according to your needs.
7. Choose your distribution under "System > Configuration".
8. Follow the steps for your services.

Read More




Rsync to Exclude Files and Directories

This article will guide you on easily exclude #files and #directories using the #rsync #command.
The --exclude option with the rsync command uses relative paths to the source #directory. Append the --exclude option to the rsync command, followed by the relative path to a directory or file(s).
The basic syntax for the rsync exclude option looks like this:
rsync [OPTIONS] --exclude 'file_or_directory' source/ destination/
Replace source/ with the directory name you want to use as a source for data transfer to another location.
Replace destination/ with the directory name rsync will use as the target location for your data. If the directory does not exist, rsync creates one for you and transfers the files to that directory.

Read More




Improve SQL Server Bulk Data Import Performance

This article will guide you improve #bulk #data #import #performance. The BULK INSERT command is much faster than bcp or the data pump to perform text file import operations, however, the BULK INSERT statement cannot bulk copy data from #SQL Server to a data file. Use the bcp utility instead of DTS when you need to export data from the SQL Server table into a text file.
To Speed up SQL Bulk Insert with #transactions:
1. Declare the variables that store the number of desired items ( @items ), the size of the chunks( @chunk_size ) and the counter of the number of executed inserts( @counter )
2. Open the first transaction and initialize the while loop.

Read More




Database version or build from backup file

This article will guide you on how to determine the database #version or build from a #backup file.
To know what #SQL version a #database is:
The first is by using either Enterprise Manager or SQL Server Management Studio and right clicking on the instance name and selecting Properties. In the general section you will see information such as on the following screenshots. The "Product version" or "Version" gives you a number of the version that is installed.
In order to find the SQL Server version from a bak file:
1. Here is the output returned by the RESTORE HEADERONLY statement. Here you will see a DatabaseVersion column that contains the value.
2. That's how you find out from which version of SQL Server a given backup file came.

Read More




Webmail timeout issue in DirectAdmin


This article will guide you on how to resolve #timeout #error in #webmail in #DirectAdmin. Generally, webmail timeout issue can occur if the timeout value is exceeded.
The term timeout or time-out has several meanings, including: A network parameter related to an enforced event designed to occur at the conclusion of a predetermined elapsed time.
To fix Webmail timeout error in DirectAdmin:
Modify the config file "/var/www/html/webmail/inc/config.php" or in /var/www/html/webmail/inc/config.security.php
and set
Code:
# Session timeout for inactivity
#
$idle_timeout = 10; //minutes
to whatever value you need.

Read More





Focus on your business, not your servers.

Click Here to Learn More




Recent Post