Compare In-Memory Technology in Oracle, IBM and SQL Server – Part Three (Final)

By increasing the amount of data as well as the need for faster processing, database providers also have capabilities in their products. The In-Memory feature is one of these, and in the first and second parts of this series, we compared In-Memory to SQL Server and Oracle. In this article, which is the third part (final), we will examine this technology in IBM DB2 10.5 and compare it with SQL Server. Data Analysis with BLU Acceleration in IBM DB2 10.5 The IBM DB2 BLU Acceleration feature is available as an integrated In-Memory integration solution with IBM DB2 10.5 . This solution has several optimization processes, but…

Read More

How to detach and attached databases

This article will cover one of the most common SQL Server Detach and Attach the database.  please make sure you have a recent backup for any case of data loss. If you are not used in computer administration and database administration.   Please go to Start >> Programs >>Microsoft SQL Server 2012 >> SQL Server Management Studio and open the application. Connect with Windows Authentication (You have Windows administration rights) or Connect with SQL Server Authentication (You have no Windows administration rights) Expand the folder Databases in the object explorer,…

Read More

How to create a User and SQL server authentication

SQL Server Authentication is a default mechanism to connect to MS SQL Server, but there are times that you need to use SQL Server Authentication to connect to the server, like when you have to connect to an MS SQL Server Database on a different network or when you have an SSPI problem. In order to use SQL Server Authentication, you need to create a SQL Server Authentication Login ID first. we will create a new SQL Server account. Run Microsoft SQL Server Management Studio. with local windows Authentication    Expand the Security folder,…

Read More

Start, Stop, Pause, Resume, Restart SQL Server Services

This article will cover one of the most common SQL servers using full system ram: start, stop, pause, resume, or restart the SQL Server Database Engine, the SQL Server Agent, or the SQL Server Browser service by using Services. Open Task Manager Press Ctrl + Alt + Delete or Right-Click on Taskbar and then click ” Start Task Manager” In the results pane, right-click SQL Server (MSSQLServer) or a named instance, and then click Start, Stop, Pause, Resume, or Restart.   Restarting services   After restarting services “SQL Server” using 700 mb ram    

Read More

how to create MySQL database in cPanel

First Login the Cpanel with Username and Password click on the MySQL Databases menu in the Databases section:   Type the database name in new Database to  which database you need to Create New Database, click on the Create Database button:    The database is created and ready to use.   The successfully created database in MySQL   To create a MySQL User, in under the Create new MySQL database. MySQL Users > Add New User and enter the username you wish to assign to your database. Once done, choose a secure password and password (again) for MySQL User and type it into…

Read More

How to Install MySQL on CentOS7

MySql is an open source database management system. In version 7 of the CentOS operating system, this database is set aside and MariaDB is the default relational database, and by installing the yum install mysql command, the MariaDB software is installed instead of MySql. In this article, we will examine how to install and run the MySQL version 5.7 on CentOS7. You can use the link below to install MariaDB. Step One: Install As explained in the previous section, MariaDB is the default database management software in CentOS7. In order to install…

Read More

How to Install MariaDB on CentOS7

MariaDB is an open source database management system that is derived from MySql. This relational database is an alternative to MySql, and the default database is the CentOS version 7 operating system. In this article, we will examine how to install this database on CentOS7. Step One: Install To install this database, run the command in the terminal.

To run the service of this database, run the following command.

To view the service status, run the following command.

The error is executed correctly. You will see the MySQL…

Read More

Install PostgreSQL on Windows

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, macOS, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and…

Read More

How To Restart/Start/Stop/Pause/ SQL Server Service

Just open SQL Server Configuration Manager, we could start, stop, pause or restart SQL Server Service. Step 1: On the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager.   Step 2: click on SQL Server Services Step 2:select any instance of SQL Server such as SQL Server (SQLEXPRESS). Right-click any instance of SQL Server such as SQL Server (SQLEXPRESS), and then click Stop, Pause, Start orRestart.  buttons on toolbar, meaning Start, Pause, Stop and Restart.

Read More

how to check MySQL status in windows

take time to check MySQL server status 01- go to “localhost” or IP “127.0.0.1” to login MySQL server and click “status”   02 –  Click on server to show you MySQL Server traffic, MySQL server connection, MySQL server Failed attempt, MySQL server total traffic.   03 –  it show to MySQL server Processes details.   04 – display the MySQL Query statistics   05 – it show you all status variables   06 – Monitor show you overall traffic and system health 07 – Advisor Possible performance issues Issue Recommendation…

Read More