Top "Database-administration" questions

the aspects of database usage not directly related to the insertion and extraction of information, such as security, configuration and performance tuning

Oracle specific timestamp format 'DD-MON-RR HH.MI.SSXFF AM'

I have a problem with Oracle 11g specific timestamp format. This is what I have: select to_timestamp('21-OCT-15 08.24.30.000000000 …

database oracle oracle11g database-administration nls-lang
list user who have root (administrative) privilege

I want to know the list of all users who have root (administrative) privilege in Oracle. I would like it …

oracle database-administration
How to lock all tables in one mysql db?

I write a backup shell script to execute mysqldump. mysqldump -u$BACKUP_USER -p$BACKUP_PASS --flush-logs --lock-tables $DB_NAME &…

mysql database database-administration
How do I add an admin user to Mongo in 2.6?

I upgraded from 2.4 to 2.6 and authentication broke. This tutorial seems pretty straightforward but I keep getting locked out of my …

mongodb database-administration
Notify Operator if ANY step in job fails

Can I (How do I) configure Sql Server 2008 to notify an operator if any step in the Job fails? I …

sql-server notifications database-administration sql-server-agent server-administration
Why only one clustered index per table should be created in sql server?

I have read tips about sql server database on http://www.sql-server-performance.com/2007/clustered-indexes In conclusion section author mentioned: "Since …

sql sql-server database-administration
Database administration tool for MongoDB

I'm kinda confused. MongoDB is one of the most popular DB. Is there any DB administration tool available for MongoDB …

mongodb database-administration
Disable users of a database not Logins in SQL server 2008

To disable users of a Database in SQL Server 2008, I gave the command: Use Database Go Revoke Connect from username; …

sql-server database sql-server-2008 tsql database-administration
Drop SQL Server database from powershell

I have a SQL Server instance on my local computer called .\SC. I want to drop a database from that …

sql-server powershell database-administration
Postgresql | No space left on device

I am getting space issue while running a batch process on PostgreSQL database. However, df -h command shows that machine …

postgresql database-administration postgresql-9.6