Results for the ‘Databases’ Category

Interacting with your SQL 2005 database

Interacting with your SQL 2005 database

We would highly recommend using Microsoft SQL Server Management Studio Express for management of your databases with Digiweb. SSMSE is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced...

Changing PostgreSQL disk quota

Changing PostgreSQL disk quota

PgSQL disk quota is the maximum allowed size of one PgSQL database. If you exceed this quota, you’ll be charged for overlimit at a different (usually higher) price. To change PgSQL disk quota, do the following: Select PGSQL DBs in the Databases...

Editing PostgreSql databases and user privileges

Editing PostgreSql databases and user privileges

You can edit the content of your databases and user privileges using the phpPgAdmin utility that comes with your control panel. To run phpPgAdmin, do the following: Select PGSQL DBs in the Databases menu. Click the name of the database...

Creating PostgreSQL databases

Creating PostgreSQL databases

Having at least one user, you can create a PostgreSQL database. This user will become the owner of this database. To create a database, do the following: Select PGSQL DBs in the Databases menu. Click Add Database in the PostgreSQL Databases section: Enter...

Deleting PostgreSQL users and changing their passwords

Deleting PostgreSQL users and changing their passwords

To delete the PgSQL database user, do the following: Select PGSQL Users in the Databases menu. Click the Trash icon next to the user name on the PostgreSQL user management page. Agree to additional charges. Important: Trash icon appears only next ...

Creating PostgreSQL users

Creating PostgreSQL users

Creating PostgreSQL Users Unlike with other databases, a PostgreSQL database cannot be created without a user. You must stick to the following sequence: Create a PostgreSQL user. Create a database. Note: The first user in the list of users is the owner...

Managing MSSQL 2005 Databases

Managing MSSQL 2005 Databases

Managing MSSQL 2005 Databases Once you have created a login, you can create databases. To access a database, you need to create DB users. // Creating MSSQL Logins Logins are used to access MS SQL server and to create DB users. You should create as many logins as many users...

Creating MSSQL logins

Creating MSSQL logins

Logins are used to access MS SQL server and to create DB users. You should create as many logins as many users you will have. To create an MS SQL login, do the following: Select MS SQL in the Databases menu. Click the Add New MS SQL login icon at the...

Creating MSSQL databases

Creating MSSQL databases

Databases are created under logins and there can be several databases under one login. To create a MS SQL database, do the following: Select MS SQL DBs in the Databases menu. Click the Add database icon at the bottom of the page that appears. Fill the MSSQL Database Creation...

Changing MSSQL database quota

Changing MSSQL database quota

Changing MS SQL Database quota Total quota size is the disk space allocated for the database file and the transaction log file. Database/Transaction Log file quota ratio is the portion of disk space allocated for...