This can be an important query for your while debugging slowness of SQL server. This will help you find currently running SQL queries on SQL Server. You can find which queries are running from a long time and utilizing CPU. To run this query, start SQL Server Management Studio, Open New Query window and...
PostgreSQL is an open source object-relational database system. It is one of leading database server used for production servers. This tutorial will help you to install PostgreSQL database server on Debian 8 and Debian 7 systems. How to Install PostgreSQL on Ubuntu Step 1. Configure Apt Repository First, you need to import PostgreSQL packages...
Using SQL Query Window: Use WITH REPLACE option with the RESTORE command on MSSQL query window. Change database name and backup file location as per your setup. USE MASTER GO RESTORE DATABASE MyDB FROM DISK = 'C:\Backups\MyDB_15082016.bak' WITH REPLACE GO
MySQL database restoration process failed with a error message while restoring a large backup file. I got the below message. After reading about this problem i found that this is not with size of backup, this problem occurred when a single package size is greater than allowed packet size. [email protected]:~$ mysql -p mydb <...
MySQL configuration file (my.cnf) file location depends on operating system or installation method. There are no command available to trace this file location on your system. In this tutorial you will get some default location’s of my.cnf file can be found. /etc/my.cnf /etc/mysql/my.cnf $MYSQL_HOME/my.cnf [DATADIR]/my.cnf ~/.my.cnf In case my.cnf file is available on more...
MongoDB is a nosql database server. The default installation provides you the access of database using mongo command through command line without authentication. In this tutorial you will learn how to create users in Mongodb server with proper authentications. Create Admin User You can use below commands to create user with admin privileges in...
Indexes are very useful to improve search queries on database tables. For example you are searching for particular record in a database table having millions of records. You will find that search queries taking very less time on tables having indexes enables. CREATE INDEX:- This will creates index on mysql table. This will allow...
Few days back PHP version 7.0 has been released. Which has number of changes and improvements over PHP version 5.X. This article will help you to install PHP 7, NGINX and MySQL 5.6 on CentOS / RHEL 7.1 & 6.7 operating systems. This tutorial has been tested with CentOS 7.1, so all the services...
The latest major release of PHP version 7.0 has been released with lots of speed optimizations and security. So you should try this version for your development. This tutorial will help you to install PHP 7.0, Nginx, & MySQL 5.6 on Ubuntu 15.10, 14.04 and 12.04 LTS release. Step 1 – Install PHP 7...
LEMP Stack (Linux, Nginx, MySQL and PHP ) is a popular web hosting environment for websites developed in php programming language. Linux is the operating system, Nginx is the popular web server and MySQL is relational database management system used for storing data. This tutorial will help you to setup LEMP Stack on Ubuntu...
